ERROR: missing FROM-clause entry for table "jv_commit_pk_seq"

[dvbeato]

I'm getting this error using @JaversAuditable in my update method.

INSERT INTO jv_commit(author, commit_date, commit_id, commit_pk) VALUES(:author, :commit_date, :commit_id, :commit_pk)] with root cause
org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "jv_commit_pk_seq"
Position: 8

[bartoszwalacik]

did you set proper sql dialect? (to PostgreSQL)

[bartoszwalacik]

answered on gitter

[dvbeato]

It works if you explicit set the database on your application.properties/yml spring.jpa.database=POSTGRESQL

[bartoszwalacik]

setting spring.jpa.database=POSTGRESQL
it is ok as a quick workaround, but we can think out sth smarter...

[bartoszwalacik]

fixed in JaVers 1.5.1 (no additional properties needed)