How To Write Hsqldb In Binary Form?

I'm searching a good (JDBC-compatible) replacement for SQLite in java. I've found hsqldb and it's quite satisfying me, but there are some questions. First. How it operates when dat

Solution 1:

HSQLDB is flexible and allows you to choose how the data is stored. If you want the data to be stored in disk tables, use CACHED tables. The easiest way to do this is by adding a property to the connection URL:

jdbc:hsqldb:file:/tmp/mydatabase.hsql;hsqldb.default_table_type=cached

All CREATE TABLE and similar statements are stored in the .script file. If you don't want this file to be in text format, add another property:

jdbc:hsqldb:file:/tmp/mydatabase.hsql;hsqldb.default_table_type=cached;hsqldb.script_format=3

The Guide covers the different options:

http://hsqldb.org/doc/2.0/guide/management-chapt.html