Create table with ID as Auto increment

[janinmobia]

Hi All,

I'm trying to create an entity bean with an ID that auto increments on MySQL.

My ID lookes like this

@Id(generate = GeneratorType.AUTO)
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}



And everything goes fine until I deploy it and it tries to create the table

create table binary_data (id integer generated by default as identity (start with 1), data varbinary(255)......

MySQL is not to happy about generated by default as identity (start with 1)
....


Any one that can see what I'm doing wrong?

Cheers
Jan

[mdeterman]

You need to set the correct hibernate dialect in your persistence.xml file

<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>

is what you need. by default it is not MySQL.

[mrhightech]

On a side note, you might want to update your annotations. @Id(generatorType...) is not used anymore

@Id and @GeneratedValue are the new annotations.

have a look at http://wiki.jboss.org/wiki/Wiki.jsp?page=FromJBossEJB3.0RC3ToRC4PFD