I have a table lets say with following fields:

id (which is primary key and of identity type)
id2 (which is a normal column with lets say int data-type)

In the mapping xml for this table, I am using "identity" algorithm for automatic generation of "id" column.

Now the primary key "id" will be generated automatically whenever a new row is inserted into this table. Alongwith the generation of id, I also want id2 to get generated automatically through hibernate. Is that possible ? Can we use some pre-defined algorithm for the generation of a non-primary key column in xml or something like that ?

[/url][/list][/list][/code][/quote][/b]

Had a similiar prob...
I solved it for now with one of two simple hacks:

1) Generate a UID. There´s a class somewhere in the javax.rmi package that generates universal identifiers that are garanted to be unique in one JVM. I think its similiar to how the hibernate id is generated.

2) let your class implement the hibernate lifecycle interface and overload the onSave() Method (or add an Interceptor to your config...) and there set the id2 to the value of id ....

i guess there are more elegant solutions, but its better than nothing...