In a nutshell:
- I have an entity bean that has a basic property of the type int.
- hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

The SchemaGenerator generate the following SQL to create that field:
create table MyTable (id bigint not null, order integer not null, primary key (id)) ENGINE=InnoDB

This fails since "integer" is not a valid SQL type. Any idea how to fix this?

EDIT: I should also mention that I'm using annotations for my mappings, if that makes a difference!

EDIT 2: SOLVED!! I should have known... ORDER is an SQL keyword, not a good property name!!


Thanks,

Brian