HSQL Database Manager
Recently I’ve been working with the Liferay platform and I found myself in a situation where I wanted to inspect the data stored in the Hypersonic database that comes bundled with Liferay. I found two recommended products for inspecting the database:
The Liferay wiki already has a pretty decent post detailing how to setup SquirrelSQL to interact with the database so I will focus entirely on what I had to do to get the HSQL Database Manager to connect to my local database instance.
First, I had to locate my hsql.jar file. For me, that was in the ext folder under my tomcat instance:
%LIFERAY_HOME%\tomcat\lib\ext\hsql.jar
Next, I ran the following command:
java -cp %LIFERAY_HOME%\tomcat\lib\ext\hsql.jar org.hsqldb.util.DatabaseManagerSwing
This launched the HSQL Database Manager:
Finally, I supplied my database URL:
jdbc:hsqldb:file:%LIFERAY_HOME%\data\hsql\lportal
Click “Ok” and…
