Hello everyone,
I use hibernate for persistent objects and Hsql as in-memory db.
When I run the hbm2ddl schema update,
It produces the table creation query from the mapping file but in incorrect syntax-)
"
create table TARGET (uid BIGINT not null, type VARCHAR(255),...., [size=12][size=18]primary key(uid))[/size][/size]

the HSQL Database Manager doesnt accept it, it returns "Wrong Data type KEY in statement"

While generating the create table SQL, it must be interpreted as
"create table TARGET(uid BIGINT not null [size=9]PRIMARY KEY[/size], type VARCHAR(255)....)" to be accepted by HSQL DB Manager.

how can I force the tool to generate the SQL like above (defining the primary key role with column definition) ??

Waiting for your suggestments
Thanks...

HSQL is used as the default database for the hibernates test suite and each test uses hbm2ddl to create the datanase tables for the test.

Have you tried the version of HSQL from the hibernate distribution?

It would be helpful as well to state the versions of each item you are using (hibernate, HSQL) and show the mapping document (simple one) that fails so the test can be replicated.