We are using Apache Derby 10.5.3.0_1 and hbm2ddl with JPA 1.x, Hibernate 3.3.x (with the standard DerbyDialect)

I get the following constraints error while pre-loading the SQL on an embedded derby database. If I remove the primary key(id) from the create table sql, it's able to create the table. Not sure what the problem is over here.

create table user_flow (id integer not null generated always as identity unique, creation_date timestamp not null, name varchar(255), primary key (id));

[INFO] Constraints 'SQL100219175052781' and 'SQL100219175052780' have the same set of columns, which is not allowed.

Npte: hbm2ddl generates proper sql for h2, mysql ...