Auto-incremented primary key

Hibernate ORM
1

Using hibernate 5.4, postgres 10 with IntelIiJ Ultimate, impossible to get auto-incremented primary key
With this following code, the sequence “warehouses_id_seq” is created but the primary key is not incremented

@Entity
@Table(name = "warehouses")
@SequenceGenerator(name = "SEQUENCE_WAREHOUSE", sequenceName = "warehouses_id_seq", allocationSize = 1)
public class Warehouse implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "SEQUENCE_WAREHOUSE")
    @Column(name = "id")
    private Integer id;
2

What mean don’t increment?
In config set show_sql , and run application : do u see this " call next value for …"?
Maybe u don’t have transaction … in postgres go to schem and run nextval
maybe u wrap u code into try catch and don’t see this “No EntityManager with actual transaction available for current thread”

3

no, I don’t see " call next value for …"?

I think we should get
< alter table warehouses alter column id set default nextval(‘public.warehouses_id_seq’); >
in the sql log.

I have to insert this manualy after application has been run

4

No
create sequence warehouses_id_seq start with 1 increment by 1
Then hibernate do: next val
and set into id in u Object(Entity) then save object

5

Thank’s for your reply,

but I would like Hibernate does it automaticaly by running the appli !!

how do you create sequence warehouses_id_seq start with 1 increment by 1 with java?

I try with initialValue = 1

6

if you want do this:
U need delete generate sequence , than use migaration application like “flyway”
write code like this:

create table test(
id bigserial
)

in java

@Entity
class Test {

@Id
Long id;

}
7

In java its call - ddl create auto

8

Thanks!
That means I need to use an additional migration tool to achieve this! I’m a little bit desapointed

9

yes, it’s best idea, but if u work for example in h2 , use ddl.auto -

create-drop
10

my configuration is

update

“update” as I’m working on an existing data base.
Maybe it would work with “create-drop”

11

Try use validate schema , maybe u configuration doest’t work

12

even with ‘create-drop’ it doesn’t work

I give up !

13

Do u use spring? Spring boot? Or only hibernate?

14

No, I use only Hibernate

15

ok, i have more information about u code :wink:
what configuration file do u use ?
hibernate.cfm.xml or perstence.xml?
can u debug u code? AdapterJpaVender can u debug to see properties when SessionFactory is up

16

Sorry for the delay I was out of my office.
I use hibernate.cfm.xml
I will debug code

17

I don’t use AdapterJpa Vendor as I don’t use Spring.
I use Dialect instead in hibernate.cfm.xml :

    <property name="hibernate.dialect">
        org.hibernate.dialect.PostgreSQL10Dialect
    </property>
18

http://jpwh.org/examples/jpwh2/jpwh-2e-examples-20151103.zip
in this code u will see how work with hibernate.cfg ( but u need understand ) how work maven

19

I should get “alter table warehouses alter column id set default nextval(‘public.warehouses_id_seq’);”
into the sequence. But finaly the id column of the database has not get any default value.
Is there any hibernate expert able ti explain me why?
Thanks

20

In hibernete i don’t see default nextval…