How to generate non identifier column auto increment ?

Afsaneh · **Joined:** Tue Apr 03, 2007 6:37 am **Posts:** 2

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hello every body,
I'm new in hibernate and now I have a problem
I want to generate a non identifier column that hibernate increment it automatically and I use that incremented value later.

thanks lot,
Regards

Read this: http://hibernate.org/42.html

anandbn · **Posted:** Tue Apr 03, 2007 11:19 am

You could use custom SQL-INSERT for the persistent class something like below:

Code:

<class name="Person">
<id name="id">
<generator class="increment"/>
</id>
<property name="name" not-null="true"/>
<sql-insert>INSERT INTO PERSON (NAME, ID) VALUES ( UPPER(?), ? )</sql-insert>
<sql-update>UPDATE PERSON SET NAME=UPPER(?) WHERE ID=?</sql-update>
<sql-delete>DELETE FROM PERSON WHERE ID=?</sql-delete>
</class>

Afsaneh · **Joined:** Tue Apr 03, 2007 6:37 am **Posts:** 2

Hi,
thanks for your attention but I want hibernate to increment an integer column automatically every time new object inserted vio hibernate annotations and this column is not table identifier.

when we want to define an id auto generation:

@Id @GeneratedValue(sterategy=GenerationType.Auto)
private int id;

but what about a non identifier column ???