How to Execute a SQL Query in HSQL

Goal

Sometimes, when troubleshooting, there is a need to manually manipulate the HSQL database. This article describes how to connect to the HSQL file instance with an SQL prompt.

 

Learn

One may access the HSQL query environment by following these steps (note that a Java GUI X-Window is required):

  1. Navigate to the Datameer installation directory.
  2. Run the following command:
    • java -cp webapps/conductor/WEB-INF/lib/hsqldb-2.3.2.jar org.hsqldb.util.DatabaseManager.
    • This should launch a Java DatabaseManager Applet.
  3. A Connect dialog box should be open automatically. If not, open it from the File menu of the Java Applet.
  4. Use the following connection information:
    • Type: HSQL Database Engine Standalone
    • Driver: org.hsqldb.jdbcDriver
    • URL: jdbc:hsqldb:file:das-data/database/hsql-db
    • User: SA
    • Password: [empty]
  5. Execute the following query to ensure that access is granted successfully:
    • SELECT * FROM property;