Showing posts with label HSQL. Show all posts
Showing posts with label HSQL. Show all posts

Saturday, December 8, 2012

How to connect different databases with HSQL client

To connect different databases with HSQL client. this is very useful in a production environment, where a single client (in fact, just a jar file and lightweight) can connect to multiple databases.

prerequisites:
1. hsql.jar
2. jdbc driver for the target database.

How to connect Liferay database with HSQL client

To connect Liferay HSQL database, this is useful during development.
at the same time, the HSQL client can be used to connect different database servers.

Steps:
1. locate hsql.jar in <LIFERAY_HOME>. (the hsql.jar may be located in different location for different application server package).
2. d-click on the hsql.jar to launch the HSQL client.
3. Fill in the name and url as jdbc:hsqldb:file:<LIFERAY_HOME>/data/hsql/lportal
4. click ok.

LinkWithin

Related Posts Plugin for WordPress, Blogger...