How to Execute a SQL Query in HSQL
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.
One may access the HSQL query environment by following these steps (note that a Java GUI X-Window is required):
- Navigate to the Datameer installation directory.
- 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.
- Type: HSQL Database Engine Standalone
- Password: [empty]
- SELECT * FROM property;