Possibly something to add to the HSQLDB howto page [1], or (even better) fixing the code to provide sizes for VARCHAR when creating the table in HSQLDB:
HSQLDB requires VARCHAR size declarations by default. When using the TableFormatter to create the table, HSQLDB will complain with the error message "length must be specified in type definition: VARCHAR". You can force HSQLDB to use a default length by setting the sql.enforce_size property to false in the JDBC URL [2]. For example, if you're using the in-memory mode of HSQLDB, you can set the JDBC URL to: jdbc:hsqldb:mem:test;sql.enforce_size=false Just wanted to share since this would have saved me some time. By the way, using SDB with HSQLDB makes a great way to write unit tests. - Mark [1] http://jena.sourceforge.net/DB/hsql-howto.html [2] http://hsqldb.org/doc/2.0/guide/dbproperties-chapt.html#N14CCB
