Saturday, December 8, 2012

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.

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.

5.Enter your query, and click on "Execute SQL", the following screen appears.

 6. Done!

No comments:

Post a Comment


Related Posts Plugin for WordPress, Blogger...