GenerationType.AUTO vs GenerationType.IDENTITY in hibernate

How could it “work properly” (you don’t define basic info like what you mean by that) with Oracle ? I don’t see the relevance of AUTO to your question – that simply lets an implementation choose what it wants to use.

IDENTITY” (as per JPA javadocs and spec – what you should be referring to) means autoincrement. There is no such concept in Oracle, yet there is in MySQL, SQLServer and a few others. I would expect any decent JPA implementation to flag an error when even trying such a thing.

Oracle would allow “SEQUENCE“, or “TABLE” strategies to be used however

Leave a Comment