Upgrade Hibernate from 5.6.15 to 6.x

We need to upgrade from Hibernate 5.6.15 to Hibernate 6.x to maintain framework currency, improve performance, and leverage new features. This is a significant architectural change that will
require careful planning and execution.

Background

Our codebase currently uses Hibernate 5.6.15 with Java 17. Hibernate 6 introduces breaking changes to the API and behavior that will require modifications throughout the codebase.

Tasks

• Research Hibernate 6.x migration guides and identify breaking changes

• Create POC branch to test basic configuration changes

• Update dependencies in master pom.xml

• Migrate from JPA 2.2 to Jakarta Persistence 3.0

• Update Ignite integration (currently using ignite-hibernate_5.3 version 2.16.0)

• Refactor entity mappings and HBM files where needed

• Revise Hibernate query language usage (HQL)

• Test with all supported databases (MySQL, Oracle)

• Update any Spring Data JPA configurations (current version 2.5.12)

• Review and update caching configuration

• Ensure OpenSearch integration continues to work

• Performance testing comparing 5.6 vs 6.x

Impacted Areas

• All modules using Hibernate (significant portion of the codebase)

• Spring integrations (5.3.39)

• Cache configuration with Ignite (2.16.0)

• Entity mappings and HBM files

• Query APIs

• DAO implementations

Acceptance Criteria

• All existing functionality works with Hibernate 6.x

• All tests pass

• No performance regression

• Documentation updated to reflect changes

References

• https://docs.jboss.org/hibernate/orm/6.0/migration-guide/migration-guide.html

• https://jakarta.ee/specifications/persistence/3.0/