primary keys with auto_increment?

karisegraves · **Joined:** Wed May 13, 2009 2:49 pm **Posts:** 1

Hello

Is there an annotation to tell the schema-update to create primary keys with auto_increment?

And another switch to tell mysql to use InnoDB-Tables instead of the default myIsam?

And if there is no annotation (probably to db-specific), is there a hibernate-property to switch that?

sanne.grinovero · **Posted:** Wed May 13, 2009 5:09 pm

Hi,
the dialects property is used to define the kind of tables on mysql:

Code:

hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

there are different kinds of dialects for all supported databases, for MySQL there are several: MyISAM, InnoDB and InnoDB on MySQL5. You can also create your own extending one and override the lowerlevel instructions you want.

for the primary keys use @GeneratedValue to generate autoincremental:

Code:

@Id
@GeneratedValue
public Long getId() {
   return id;
}

btw, this is the wrong forum for this questions;-)