Hibernate version:
2.1.6

Name and version of the database you are using:
HSQLDB 1.7.1

The generated SQL (show_sql=true):
create table hovel_member (member_id bigint generated by default as identity (start with 1), username varchar(255) not null, password varchar(255) not null, email varchar(255) not null, first_name varchar(255), last_name varchar(255), created timestamp not null, updated timestamp not null)


In SchemaExport on the following line:

if (export) statement.executeUpdate( createSQL[j] );

The following SQLException is being thrown:

java.sql.SQLException: Unexpected token: GENERATED in statement [create table hovel_member (member_id bigint generated by default as identity (start with 1), username varchar(255) not null, password varchar(255) not null, email varchar(255) not null, first_name varchar(255), last_name varchar(255), created timestamp not null, updated timestamp not null)]

I imagine there's some incompatibility with the HSQLDialect.getIdentityColumnString() method and the HSQLDB version I'm using. Could this be the case?

Thanks,
Jeff

My understanding is that HSQL has changed from identity to sequences at some point (maybe the otherway). I have not looked in detail but two Dialects for the various versions are required - if my memory is correct.

The difference between HSQLDB 1.7.1.x and 1.7.2.x is a couple years. I mistakenly downloaded the older version and the Dialect was off. Using the most current HSQLDB and Hibernate seems to work for me now, at least for table creation.