Identity columns and sequences in Hibernate

By: Dorris  


For databases that support identity columns (DB2, MySQL, Sybase, MS SQL), you can use identity key generation. For databases that support sequences (DB2, Oracle, PostgreSQL, Interbase, McKoi, SAP DB) you can use sequence style key generation. Both of these strategies require two SQL queries to insert a new object. For example:

<id name="id" type="long" column="person_id">

<generator class="sequence">

<param name="sequence">person_id_sequence</param>



<id name="id" type="long" column="person_id" unsaved-value="0">

<generator class="identity"/>


For cross-platform development, the native strategy will, depending on the capabilities of the underlying database, choose from the identity, sequence and hilo strategies.

Archived Comments

1. Brettkip
View Tutorial          By: Brettkip at 2017-07-29 03:53:33

2. Brettkip
View Tutorial          By: Brettkip at 2017-06-11 19:36:37

3. This was the first clear and straight-forward example I have seen, thank you
View Tutorial          By: Steve at 2013-01-02 22:58:32

Most Viewed Articles (in Hibernate )

Latest Articles (in Hibernate)

Comment on this tutorial