Oracle Sequence in hibernate

Hibernate ORM
1

Hi,

Is there an option to Omit/skip identity column in hibernate mappings?
Because i have created a trigger which uses the identity column and generates at the back end while inserting records into the db.

I need it only when i edit and delete the records.
Currently what its doing is creating a new sequence value for edit and save option

Title :BezKoders Tut#35 Desc :Tuts#35 Levels :6 Published :0 [2m2025-06-21 21:28:05.346[0;39m [32mDEBUG[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-3][0;39m [36mo.s.orm.jpa.JpaTransactionManager [0;39m [2m:[0;39m Found thread-bound EntityManager [SessionImpl(642883809<open>)] for JPA transaction [2m2025-06-21 21:28:05.346[0;39m [32mDEBUG[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-3][0;39m [36mo.s.orm.jpa.JpaTransactionManager [0;39m [2m:[0;39m Creating new transaction with name [org.springframework.data.jpa.repository.support.SimpleJpaRepository.save]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT [2m2025-06-21 21:28:05.349[0;39m [32mDEBUG[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-3][0;39m [36mo.s.orm.jpa.JpaTransactionManager [0;39m [2m:[0;39m Exposing JPA transaction as JDBC [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@55b1f3d3] ***Hibernate: call next value for tutorial_id_seq --> while edit and save*** [2m2025-06-21 21:28:05.353[0;39m [33m WARN[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-3][0;39m [36mo.h.engine.jdbc.spi.SqlExceptionHelper [0;39m [2m:[0;39m SQL Error: 6576, SQLState: 65000 [2m2025-06-21 21:28:05.354[0;39m [31mERROR[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-3][0;39m [36mo.h.engine.jdbc.spi.SqlExceptionHelper [0;39m [2m:[0;39m ORA-06576: not a valid function or procedure name `` Its doing this for the insert stmt. 
Title :BezKoder Tut#35 Desc :Tut#35 Levels :2 Published :0 [2m2025-06-21 21:39:15.947[0;39m [32mDEBUG[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-1][0;39m [36mo.s.orm.jpa.JpaTransactionManager [0;39m [2m:[0;39m Found thread-bound EntityManager [SessionImpl(1471771415<open>)] for JPA transaction [2m2025-06-21 21:39:15.947[0;39m [32mDEBUG[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-1][0;39m [36mo.s.orm.jpa.JpaTransactionManager [0;39m [2m:[0;39m Creating new transaction with name [org.springframework.data.jpa.repository.support.SimpleJpaRepository.save]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT [2m2025-06-21 21:39:15.949[0;39m [32mDEBUG[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-1][0;39m [36mo.s.orm.jpa.JpaTransactionManager [0;39m [2m:[0;39m Exposing JPA transaction as JDBC [org.springframework.orm.jpa.vendor.HibernateJpaDialect$HibernateConnectionHandle@1a759357] **Hibernate: call next value for tutorial_id_seq --> while inserting** [2m2025-06-21 21:39:15.956[0;39m [33m WARN[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-1][0;39m [36mo.h.engine.jdbc.spi.SqlExceptionHelper [0;39m [2m:[0;39m SQL Error: 6576, SQLState: 65000 [2m2025-06-21 21:39:15.956[0;39m [31mERROR[0;39m [35m15600[0;39m [2m---[0;39m [2m[nio-8080-exec-1][0;39m [36mo.h.engine.jdbc.spi.SqlExceptionHelper [0;39m [2m:[0;39m ORA-06576: not a valid function or procedure name
2

I don’t know what your code is doing, but if Hibernate ORM acquires a new sequence value, then it must assume that the entity does not exist in the database.
Please post the code that you’re executing.

3

I found the solution in another site.

Given below is the suggestion if you use in a oracle db with a trigger for inserting the sequence automatically.

@Id @GeneratedValue(generator = "incrementor") @GenericGenerator(name = incrementor", strategy = "increment")

and it solved the problem.