We've updated the JPA implementation Hibernate on they way to Axon Ivy 10 to Hibernate 5.4. The upgrade seems seamless for most of your projects, there is only change, which can be a potential pitfall. If you start with a new persistence unit in your Axon Ivy Project and connect to an already existing table. You are maybe not able to insert new elements with:
ivy.persistence.myPersistenceUnit.persist(myEntitiy);
And you end up in the following error 🤕:
Invalid object name 'hibernate_sequence'.
This is because, hibernate works by default now with sequences, which means, it generates a table in your database which is called hibernate_sequence, which is managing the primary keys of all of your tables. Before, hibernate has used the auto increment feature of the database management system. According to hibernate this switch was made because of performance reasons. So we recommend, to introduce such a table for your project, which can be done by Generate Schema in the persistence unit.
But if you like to have the auto increment approach, then you can set the property hibernate.id.new_generator_mappings to false in your persistence unit.
P.S: You won't face any migration pain, because we set this property in all your persistence units when migrating from older Axon Ivy versions 🤩.
P.S 2: This should be configurable per identity column in your entity class. If we get enough feedback from you, we could make the @javax.persistence.GeneratedValue configurable as part of your entity class.
