Hsqldb create db problem with integer lengths

Shash Chatterjee <[email protected]>
Newsgroups gmane.comp.java.keel.devel
Message-ID <[email protected]>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.