Hi all,

I want to set an auto generated value in a column when ever a record is created in a table. The logic of creation of this value is as such :

Value = base 36 converted value of primary key or the ID

Is it possible to do using the Hibernate API or extending the hibernate API. I am using auto increment feature to increase the id by 1 each time a record is created.

Regards,
Nitin

Use increment generator in ur mapping file. (.hbm.xml file)..

For eg.,

<id name="userId" type="java.lang.Long">
<column name="user_id" />
<generator class="increment" />
</id>


here user_id is autoincrement column of users table.

I guess you have to check your database for that kind of functionality. Hibernate doesn't generally generate values for you automatically. The only exception are some of the ID generators.

It might be possible to implement some kind of auto-generation with a custom UserType, but not if you depend on the auto-increment value that is generated by the database.

On the other hand, Hibernate has support for calculated properties. Eg. properties that are not stored in the database, but are calculated on the fly (using SQL) each time the data is read from the database. See <property formula=...> at http://www.hibernate.org/hib_docs/v3/re ... n-property