by XTIVIA | May 22, 2014 | Blog, Databases
SQL1035N The database is currently in use. SQLSTATE=57019 IBM UDB DB2 V9.7/10.1/10.5 on Windows/UNIX/Linux I have been trying to create a script that will refresh the test database using QA data on a regular schedule. As part of the script I force all...
by XTIVIA | May 14, 2014 | Blog, Portals
As a follow up to my last blog post on Integration Liferay with Solr Cloud, I felt that this post will help enhance Liferay’s integration with Solr cloud further by reducing the number of indexing requests that are fired off to Solr instances thus reducing the...
by XTIVIA | May 9, 2014 | Blog, Enterprise Java, Portals
This article is part of an ongoing series. See the blog entry Delivering Your Enterprise: The ilities for an overall discussion. Today, girls and boys, we’ll talk about Availability, Reliability, and Scalability. Is this simply a way to keep your boss and your...
by XTIVIA | May 9, 2014 | Blog, Databases
Anyone who has worked with an Informix database knows that the moment you run into a query performance issue, you start with update statistics on that table. This was always what we were taught in support and talking with big names at IIUG, it’s still the...
by XTIVIA | May 7, 2014 | Blog, Data Management, Databases
Managing Logins If you have worked with SQL Server a while you may recognize there is a difference between logins and users. When it comes to managing security with SQL Server it is important to know the difference, and the differences that have come about over...
by XTIVIA | May 5, 2014 | Blog, Portals
Overview Liferay is at the forefront of providing integration with many popular platforms for Documents and Media. One of the options provided by Liferay out-of-the-box is integration with S3. S3 is a service provided by Amazon. Amazon S3 (Simple Storage Service) is...
by XTIVIA | Apr 30, 2014 | Blog, Enterprise Java, Perspectives, Portals
Recently I was thinking about how I describe to others what our group does on a daily basis. Perhaps it’s my background with startups, but I’ve long felt that having a good elevator pitch for yourself or your company increases your ability to communicate...
by XTIVIA | Apr 28, 2014 | Blog, Customer Relationship Management
How to fix Could not find UpdatePanel with ID ‘mainformUpdatePanel’ If you get this error while in ListView: This may come from the fact that the group viewer “hides” the control that contains the “mainformUpdatePanel”. There is an...
by XTIVIA | Apr 28, 2014 | Blog, Portals
Sharing links on Facebook and Twitter is a huge traffic driver for websites. We’ve all pasted a link into that little box and watched that preview magically appear, but how does it know what to put in there? The answer is ‘Well, it does kind of, but not...
by XTIVIA | Apr 24, 2014 | Blog, Portals
In a previous blog I had posted what can only be described as a rather complicated process for enabling Xuggler in Liferay 6.1. The primary problem was Xuggler itself. Since then, Xuggler, had a couple of releases that greatly improved it’s deployability,...
by XTIVIA | Apr 19, 2014 | Blog, Portals
Liferay Dynamic Data List is a powerful tool to create simple CRUD applications without writing any code. But it is not powerful enough to create a real dynamic application, because simple CRUD actions do not contain business logic. For example, if we want to...
by XTIVIA | Apr 16, 2014 | Blog, Databases
Many of our Virtual-DBA clients need to complete audits for compliance with regulations. SOX (Sarbanes Oxley) is a common audit that our customers need to successfully complete. A common question the auditors ask is, “How do you know a user has been granted elevated...
by XTIVIA | Apr 3, 2014 | Blog, Databases
If you’re like me, you tend to brush off concerns of compatibility between Oracle Client and Server versions. After all, SQL*Plus hasn’t changed much in the last 15-20 years, and I’ve gotten used to being able to connect to pretty much any...
by XTIVIA | Apr 3, 2014 | Blog, Portals
Tasked to think of an easy way for users to create a mega menu, I came up with a 2 portlet display/config portlet combo. At the same time, I also wanted to try JSF after hearing so many good things about it. Here we go! Menu Config Portet Let’s first see how the UI...
