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.
run this first:
statement.execute("SET DATABASE SQL SYNTAX PGS TRUE"); // allow postgres style table creation