Migrating hibernate-core from version 5.6.10 to 6.1.7

Hibernate ORM
1

Hello,

I am currently migrating hibernate-core from version 5.6.10 to 6.1.7 and hibernate-validator to 8.0.0-Final. During this process, I am encountering missing table errors related to auto-increment IDs on my entities, even though the tables exist.

For some entities, I have resolved this issue by using @GeneratedValue(strategy = GenerationType.IDENTITY) on the ID. However, I am facing difficulties with entities that inherit from a superclass and cannot be modified.

Here is the error message I am receiving:
Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing table [user_rev_entity_seq]
at org.hibernate.tool.schema.internal.AbstractSchemaValidator.validateTable(AbstractSchemaValidator.java:133)
at org.hibernate.tool.schema.internal.GroupedSchemaValidatorImpl.validateTables(GroupedSchemaValidatorImpl.java:46)
at org.hibernate.tool.schema.internal.AbstractSchemaValidator.performValidation(AbstractSchemaValidator.java:96)
at org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:74)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:293)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.lambda$process$5(SchemaManagementToolCoordinator.java:143)
at java.base/java.util.HashMap.forEach(HashMap.java:1421)
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:140)
at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:336)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:415)
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1423)
at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:75)
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.CostcoESS createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:376)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409)

How should I address this issue?

Thank you in advance for your assistance.

2

If you are not in control of your base classes that define the identifier generator, then you’re out of luck. The only way to force the use of auto_increment is by specifying @GeneratedValue(strategy = GenerationType.IDENTITY)