Querying a HSQL database on the command line with hsqldb-sqltool

If you have a HyperSQL (HSQL) database stored in a file, it is often useful to be able to query that database from the command line. This can be done using the following command:

hsqldb-sqltool --inlineRc url=jdbc:hsqldb:file:<db_name>,user=<username>,password=[<password>]

By default, user SA with no password will exist for each database file. If the database does not exist, it will be created for you.

Leave a Reply

Your email address will not be published.