Controlling the column order when EclipseLink creates tables

Question

I'm using EclipseLink with the "eclipselink.ddl-generation" property set to "create-tables". The order of the columns in the created tables seems random. I want the columns in a particular order - the order in which the fields appear in the Entity class definition.

Is there a way to tell EclipseLink to create the columns in the order in the Entity class definition or some other way to specify column order?

Thanks.

Answer 1

I'm having the same problem with Hibernate and hsqldb, and I think its causing: org.hibernate.exception.SQLGrammarException: could not initialize a collection Caused by: java.sql.SQLSyntaxErrorException: incompatible data type in operation