Styjun

What does "Puller Prush Person" mean?

What's the output of a record needle playing an out-of-speed record

Horror movie about a virus at the prom; beginning and end are stylized as a cartoon

What does the "remote control" for a QF-4 look like?

Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?

Has there ever been an airliner design involving reducing generator load by installing solar panels?

Unable to deploy metadata from Partner Developer scratch org because of extra fields

Why do I get two different answers for this counting problem?

Convert two switches to a dual stack, and add outlet - possible here?

Arrow those variables!

Is it unprofessional to ask if a job posting on GlassDoor is real?

How much RAM could one put in a typical 80386 setup?

Do other languages have an "irreversible aspect"?

How to determine what difficulty is right for the game?

Accidentally leaked the solution to an assignment, what to do now? (I'm the prof)

Perform and show arithmetic with LuaLaTeX

Which country benefited the most from UN Security Council vetoes?

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

Theorems that impeded progress

Why can't we play rap on piano?

Maximum likelihood parameters deviate from posterior distributions

Was any UN Security Council vote triple-vetoed?

Can I ask the recruiters in my resume to put the reason why I am rejected?

Replacing matching entries in one column of a file by another column from a different file

Spring data jpa with hibernate can't find column in sequence

Hibernate use of PostgreSQL sequence does not affect sequence tableWhat's the difference between JPA and Hibernate?How can a I create an field on my class thats autoIncremented from zero to 255Hibernate unable to delete parent/child self-join entityUsing hibernate3-maven-plugin to generate Sequence Scriptsusing projections on multiple columns - joined tablesJava Spring Hibernate : Model class primary key auto increment field : set automatic and manually on a fieldIm getting "com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505Hibernate Id Sequence Resulting nullGeting back autogenerated value from a saved record in JpaRepository

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

So I'm using PostgreSQL database in my Spring MVC project and I created table with sequence for primary key generating. And I have a problem with hibernate getting next value for inserting rows. This is how my entity looks like:

@Id 
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "employee_s")
@SequenceGenerator(name = "employee_s", sequenceName = "employee_s", initialValue = 1, allocationSize = 1)
@Column(name = "id_pk")
private Long id;

And Im getting error while inserting data like this:

org.postgresql.util.PSQLException: ERROR: Column "next_val" does not exist

Well this column does not exist in sequence but why even hibernate is looking for this column?

But when I changed generation stragety it worked:

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id_pk")
private Long id;

How can I fix it to use sequence stragety or should I just stick to IDENTITY, because it works? PostgreSQL uses strategies so I wanted to try them out

java spring hibernate sequence

share|improve this question

asked Mar 21 at 22:47

Paveli TripoPaveli Tripo

194

add a comment | 

1

So I'm using PostgreSQL database in my Spring MVC project and I created table with sequence for primary key generating. And I have a problem with hibernate getting next value for inserting rows. This is how my entity looks like:

@Id 
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "employee_s")
@SequenceGenerator(name = "employee_s", sequenceName = "employee_s", initialValue = 1, allocationSize = 1)
@Column(name = "id_pk")
private Long id;

And Im getting error while inserting data like this:

org.postgresql.util.PSQLException: ERROR: Column "next_val" does not exist

Well this column does not exist in sequence but why even hibernate is looking for this column?

But when I changed generation stragety it worked:

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id_pk")
private Long id;

How can I fix it to use sequence stragety or should I just stick to IDENTITY, because it works? PostgreSQL uses strategies so I wanted to try them out

java spring hibernate sequence

share|improve this question

asked Mar 21 at 22:47

Paveli TripoPaveli Tripo

194

add a comment | 

So I'm using PostgreSQL database in my Spring MVC project and I created table with sequence for primary key generating. And I have a problem with hibernate getting next value for inserting rows. This is how my entity looks like:

@Id 
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "employee_s")
@SequenceGenerator(name = "employee_s", sequenceName = "employee_s", initialValue = 1, allocationSize = 1)
@Column(name = "id_pk")
private Long id;

And Im getting error while inserting data like this:

org.postgresql.util.PSQLException: ERROR: Column "next_val" does not exist

Well this column does not exist in sequence but why even hibernate is looking for this column?

But when I changed generation stragety it worked:

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id_pk")
private Long id;

How can I fix it to use sequence stragety or should I just stick to IDENTITY, because it works? PostgreSQL uses strategies so I wanted to try them out

java spring hibernate sequence

share|improve this question

asked Mar 21 at 22:47

Paveli TripoPaveli Tripo

194

@Id 
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "employee_s")
@SequenceGenerator(name = "employee_s", sequenceName = "employee_s", initialValue = 1, allocationSize = 1)
@Column(name = "id_pk")
private Long id;

org.postgresql.util.PSQLException: ERROR: Column "next_val" does not exist

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id_pk")
private Long id;

share|improve this question

asked Mar 21 at 22:47

Paveli TripoPaveli Tripo

194

share|improve this question

asked Mar 21 at 22:47

Paveli TripoPaveli Tripo

194

asked Mar 21 at 22:47

Paveli TripoPaveli Tripo

194

asked Mar 21 at 22:47

Paveli TripoPaveli Tripo

194