hsqldb woe

hsqldb “type not found or user lacks privilege serial”

 

meant I was loading a postgres DDL file that creates some tables postgres, trying to run that in my unit tests with an hsqldb.

Which uses different syntax for creating tables.

Fix’ish:

run this first:

statement.execute("SET DATABASE SQL SYNTAX PGS TRUE"); // allow postgres style table creation

Leave a Reply

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

Time limit is exhausted. Please reload the CAPTCHA.