GenerationType.AUTO vs GenerationType.IDENTITY in hibernate

java hibernate spring-mvc jpa database-migration
sethu palaniyappan picture sethu palaniyappan · Oct 13, 2015 · Viewed 42.2k times · Source

Currently we are using mysql as a database and we use

@Generated Value(strategy = GenerationType.IDENTITY)

It's working perfectly at certain situation we need to migrate our database to Oracle at that time it's not working properly.If any one knows what's actual difference present behind this and how it's working?

Answer

Neil Stockton picture Neil Stockton · Oct 13, 2015

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

Related questions

Error creating bean with name 'entityManagerFactory' defined in class path resource : Invocation of init method failed

When I compile my spring project, I got the following error. Error creating bean with name 'entityManagerFactory' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Invocation of init method failed I am using STS Eclipse …

Read More
Org.Hibernate.AnnotationException: No Identifier Specified For Entity I don't have a id in my table

I'm working with a table in a database and that table don't have a primary key or a proper column whith a unique value who can act as a primary key, I don't have permissions to alter that table. What …

Read More
Not supported for DML operations with JPA update query

This has been asked once before but the solution did not solve the issue. I am creating a JUnit test: @Test @Transactional @Modifying public void updateMaterialInventory() throws Exception{ // Initialize the database materialRepository.saveAndFlush(material); long id = material.getId(); materialRepository.updateMaterialInventory(…

Read More