Answer by Reguel Wermelinger

Reguel Wermelinger — Mon, 15 Sep 2014 16:38:40 -0400

If you want to create a repacked version of HSQLDB by your own (may be to pack a newer version) proceed as follows:

Create a repack JAR as described on repackage.org. E.g. trough JarJar.
- Move all classes from org.hsqldb into a new Package like org.hsldb234
Adjust the java.sql.Driver service
- Extract the file META-INF/services/java.sql.Driver from the repacked JAR
- Open it in a Text-Editor and adjust the full qualified name of the JDBCDriver implementation so that it matches your new package structure. E.g. org.hslqdb234.jdbc.JDBCDriver
- Put the manipulated service file back into the JAR (e.g by Overwriting the content with 7-ZIP)
Change the JDBC URL to avoid conflicts with other versions that work with the same URL
- Extract the file org/hsqldb234/DatabaseURL.class from the repacked JAR
- Open this class in the Java Class File Editor
- Switch into class modification mode (upper right corner)
- Change the JDBC connection URL in the field S_URL_PREFIX to a similar URL as the repacked namespace. E.g. jdbc:hsqldb234
- Save the manipulated DatabaseURL.class file
- Put the manipulated class file back into the JAR (e.g by Overwriting the content with 7-ZIP)
Done! Use the manipulated JAR trough your own custom JDBC URL(e.g. jdbc:hsqldb234)

Reguel Wermelinger — Mon, 15 Sep 2014 16:24:17 -0400

9.1 and later

HSQLDB is upgraded to 2.5.0.

8.0 and prior

You can use a repacked JAR that contains a newer HSQLDB and put it on the system classpath.

I've already prepared such a repacked JAR. You can download it here: HSQLDB 2.3.2 Repack

Configure your database as follows to use this repacked version:

put the repack JAR into JRE/lib/ext folder of your designer
chose the driver "Others" > "Other" within the Database Connection Configuration
set the Driver Class to: org.hsqldb232.jdbc.JDBCDriver
set the Connection URL to: jdbc:hsqldb232:mem

Answers to: Use the latest HSQLDB within my Project