Hibernate3 MySQL best id generator

albert_gorski · **Posted:** Wed Apr 09, 2008 5:11 am

Hi,
I develop application with MySQL DB (5.x).
My question is what is the best method to auto generate ID?

Now I use GenerationType.AUTO but I think also about GenerationType.TABLE. Can you give me some hints, please?
Do you know any drawbacks of GenerationType.AUTO and GenerationType.TABLE ?

Thanks in advance
Albert

illya77 · **Joined:** Wed Apr 09, 2008 4:19 am **Posts:** 3

Hello

GenerationType.AUTO will use AUTO_INCREMENT feature for MySQL

GenerationType.TABLE will create special table and will store current id generators values in rows here

I suggest to use GenerationType.AUTO.

More info
http://edocs.bea.com/kodo/docs41/full/html/ejb3_overview_mapping_sequence.html
http://java.sun.com/javaee/5/docs/api/javax/persistence/GenerationType.html

Thanks,
illya