Connect To HyperSQL Database Via SqlTool

The following command executed in the lib directory of the HyperSQL tool will connect to a HyperSQL database:

java -cp sqltool.jar;hsqldb.jar org.hsqldb.cmdline.SqlTool --inlineRc url=jdbc:hsqldb:file:path_to_db\db_name

Remember to run commit; before exiting the tool as any statements you run will not be committed until you do.

This entry was posted in Programming and tagged , . Bookmark the permalink.

One Response to Connect To HyperSQL Database Via SqlTool

  1. Walter says:

    I am an amateur at automating databases. I have not been able to connect to a personal
    HSQL Database 2.3.0 w/sqltool. I have the tool running and get to the prompt, +>
    I have not been able to connect w/your code, or the code from Ch1 or Ch8.
    Maybe my rc file is wrong, it is:
    urlid mem
    url jdbc:hsqldb:mem:memdbid
    username SA
    password
    I have tried other variations of this, but to no avail.
    I would greatly appreciate any insight you could give me.
    Thank You
    Walter

Leave a Reply

Your email address will not be published. Required fields are marked *