[jboss-user] [EJB 3.0] - Re: The database returned no natively generated identity val

[Wolfgang Knauf]

Hmmm, after doing a bit of google I found that MySQL 5 does not support sequences at all. There are Auto Increment columns possible, but no sequence which updates it's value on each "select nextval from sequencename".

Leave the strategy to "AUTO", remove the "@SequenceGenerator" annotation and hope that Hibernate uses an appropriate default.

And activate SQL statement logging in your persistence.xml and take a look at the statements which are fired against your MySQL. Maybe they provide more info.

Hops this helps

Wolfgang

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4209878#4209878

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4209878