Configuring the Hsqldb client

To run from within Eclipse:

Download a complete distribution of HiberObjects or separate plugins for HiberObjects, Hibernate and HSQLDB, from http://objectgeneration.com/eclipse/download.html. Unzip the ZIP file(s) in the Eclipse installation directory and restart Eclipse. Now each project will have HiberObjects properties. To use the Database Manager, stop Tomcat and go to Open Perspective in Eclipse, and select HiberObjects. Find hsqldb-1.7.3.jar and expand. Expand org.hsqldb.util and right-click DatabaseManager.class. Select Run As -> Java Application. In the Connect box, the Type: should be HSQL Database Engine Server. The URL: will be found in $HOME/apache-tomcat-5.5.25/webapps/gridsphere/WEB-INF/CustomPortal/database/hibernate.properties, under hibernate.connection.url. In our case it will be jdbc:hsqldb:/home/<username goes here>/apache-tomcat-5.5.25/webapps/gridsphere/WEB-INF/CustomPortal/database/gridsphere. The username is sa with a default blank password. Of course you can change the sa password in your hibernate.properties file.

Reference: http://objectgeneration.com/eclipse

To run from a command line:

In $HOME/apache-tomcat-5.5.25/webapps/gridsphere/WEB-INF/lib/ you should find hsqldb-1.7.3.jar. The following command run from within the lib directory will open the database client as a gui:

 java -cp hsqldb-1.7.3.jar org.hsqldb.util.DatabaseManager

In the Connect box, the Type: and URL: will be the same as described above in the instructions for running the client from within Eclipse.

Reference: http://hsqldb.org/doc/guide/ch01.html#N100B7