|
I have some persistents, that work fine under MySQL. For testing
locally, I was using a HsqlDB instance. However, I am running into
problems creating tables when the integer column(s) have a length
specified: Unable to create database tables:Unable to build/execute create statement 'CREATE TABLE category (active INTEGER not null, categoryid INTEGER not null, categorytypeid INTEGER(12) not null, name VARCHAR(132) not null, parentcategoryid INTEGER(12) not null, PRIMARY KEY (categoryid,categorytypeid,parentcategoryid))' for table 'category'Unexpected token in statement [CREATE TABLE category (active INTEGER not null, categoryid INTEGER not null, categorytypeid INTEGER(12) not] I was initially having problems with INTEGER(1) on column "active". I took the length out, and now the problem shifted to column "categorytypeid". I have modified the code to generate a space before the length, i.e "INTEGER (12)" instead of "INTEGER(12)", but that does not help. Is this not correct syntax? The big integers don't bother me, it is the INTEGER(1)s that I care about. Any ideas? Thanks, Shash PS: Using 1.7.3.0 of Hsqldb. |
