by XTIVIA | Oct 28, 2015 | Blog, Data Management, Databases
To run any SQL or perform runstats or other actions, you must establish a connection to a DB2 database. Connecting to a Database Connecting to an existing database on the same database server the database exists on, or connecting to an already cataloged database is...
by XTIVIA | Oct 22, 2015 | Blog, Data Management, Databases
In order to connect to a DB2 database that is not on the server or workstation you’re connecting from, you’ll need to make DB2 aware of that database by cataloging it, unless you’re using JDBC type 4 drivers. JDBC type 4 drivers do not require that a...
by XTIVIA | Oct 19, 2015 | Blog, Databases
Having frequently repeated SELECT queries and their results stored in memory can significantly optimize performance on your MySQL database. The query cache will perform such a task however, you must analyze whether your query cache is effective for your workload or if...
by XTIVIA | Oct 14, 2015 | Blog, Data Management, Databases
Keeping track of SQL Server Jobs is an important part of maintaining a database proactively. The below script pulls a quick list of all jobs, completion status, and date the job ran. Taking this a step further one could have the SQL Server email them a copy...
by XTIVIA | Oct 8, 2015 | Blog, Databases
The option binlog_ignore_db can be used to exclude certain information from the binary log by setting the option equal to a given database name. However, we advise our clients to not use this option. Why? The binary log is a valuable resource for point in time...
by XTIVIA | Oct 6, 2015 | Blog, Data Management, Databases
Data Corruption is something that no one really wants. Yet every now and then, we see some customers run into this. Any such issues are almost always the result of disk or SAN level issues. You will see errors like this: SQL1655C The operation could not be completed...
by XTIVIA | Oct 5, 2015 | Applications, Blog, Cloud, Enterprise Infrastructure, Enterprise Java, Portals
A key step for setting up a reliable Liferay environment is to configure Liferay clustering. Liferay clustering can be achieved in multiple ways. Some of the supported clustering methods are UDP Multicast, UDP Unicast and TCP Unicast. While Multicast is...
by XTIVIA | Oct 2, 2015 | Blog, Cloud, Databases, Enterprise Infrastructure, Enterprise Java, Portals
Microsoft recently updated the Azure SQL database to only allow encrypted communication. Now communication between Azure SQL Database and your application requires encryption (SSL) at all times. If your client application does not validate certificates upon...
by XTIVIA | Sep 30, 2015 | Blog, Customer Relationship Management
The customer portal security can be customized by implementing and registering a IEntitySecurityService. Practically, this means extending CustomerPortalSecurityService and overriding 3 methods (and optionally a 4th one): BuildRestriction – add a restriction to...
by Cameron McBride | Sep 29, 2015 | Applications, Blog, Enterprise Java, Mobility, Portals
Today we will demonstrate part two of the XTIVIA Mobile Demo application for Android. If you haven’t watched part one you should check it out by clicking here. Since the last video we have added several new features that will be covered: Revamped article...
by XTIVIA | Sep 28, 2015 | Blog, Enterprise Java, Portals
This post describes the process of Migrating Liferay EXT plugin projects from SDK to Maven. Maven EXT plugins are set up as multi-module Maven projects. Migrating from the SDK to Maven is pretty easy, but there are some things that you need to be aware of. Creating...
by XTIVIA | Sep 25, 2015 | Blog, Enterprise Java, Portals
This posting helps you with the process of migrating Liferay ServiceBuilder projects from SDK to Maven. Migrating Liferay plugin projects from the Liferay SDK to Maven is normally a straight-forward process. ServiceBuilder plugins, however, are structured differently...
