Dear All, I tried to use HIbernate with the lovely in memory database of H2. My try was disturbed though, because the auto incrementation of the @Id annontated id field did not happen right. My entity class is @Entity(name = "RepoTestClass") @Table(name = "RepoTestClass") public class RepoTestCl…

Tr with Flyway . It’s a much better alternative than hbm2ddl. For the 2nd approach, try with hibernate.hbm2ddl.auto=create. I’m already using this approach. Just fork the repository, uncomment this line , and run this test . You’ll see it working. Your problem is because EmbeddedDatabase does not wor…

The problem is that you are mixing manually assigning with automatic ones. When you create records via a scripts, you should use the sequence as well to assign identifiers. Or, you can use negative numbers if you don’t want to have conflicts.

Thank you Vlad to your reply. Can you please provide an example using sequence via SQL?

INSERT INTO my_table(id, name) VALUES (hibernate_sequence.NEXTVAL, 'Vlad');

Thank you for the detailed instructions, but it did not worked for me. I initialize the Spring bean of the entity manager factory as follows: @Bean public LocalContainerEntityManagerFactoryBean entityManagerFactory() { LocalContainerEntityManagerFactoryBean em = new LocalContainerEn…

INSERT INTO RepoTestClass VALUES (‘abc_1234’, ‘Init-app’, ‘RUNNING’, 1234567, hibernate_sequence.NEXT_VAL); Try adding the column names to the INSERT statement. Maybe the id is not the last one. And, try to debug it and see why it fails on H2.

I mean that the issue is that H2 gets initialized before Hibernate, and by default it does not contain the table hibernate_sequence nor its columns - so it cannot read them.

You have two options: You create the schema yourself: create the DB schema with tables and sequences using the init-db-test.sql script switch to hibernate.hbm2ddl.auto=validate You create the schema with hibernate.hbm2ddl.auto=update, but use the hibernate.hbm2ddl.import_files configuration…

It is all OK to use the init script with the given hibernate.hbm2ddl.import_files option. My question is though: can use @GeneratedValue(strategy = GenerationType.AUTO) for this or shall I use GenerationType.SEQUENCE? If I have to use GenerationType.SEQUENCE, with what configuration - regarding th…

Use GenerationType.SEQUENCE if that’s what you want to use in production and don’t care about portability.

Dear Vlad, I tried to use the second variation you provided, but it did not worked. At first I used GenerationType.AUTO with hibernate.hbm2ddl.auto=update, but then the init script is not executed. When I a changed it to hibernate.hbm2ddl.auto=create, then it read up the file, but again the indic…

Auto incrementation not working for @Id tagged field

Hibernate ORM

Topic		Replies	Views
Auto-incremented primary key Hibernate ORM	21	2363	September 17, 2020
Generating identifier with H2 2.0.x Hibernate ORM	1	2144	December 28, 2021
Generated ID always zero Hibernate ORM	2	1003	September 20, 2022
Problem auto increment primary key with postgres Hibernate ORM	0	1017	July 31, 2020
Using a SQL Server sequence with Hibernate Hibernate ORM	4	12114	July 18, 2024

Auto incrementation not working for @Id tagged field

Related topics