Hi,

I'm currently using generator class as Sequence for my hbm files.




Now, the project db team has decided to come up with a generic stored proc which wud return an unique index. In a nutshell, everytime I need an insert, I've to call this proc, get the sequence value and use it as a primary key.

Just wondering if there's any way to fit in this requirement in my current scenario. Any pointers will be highly appreciated.

Regards

you might have to write your own id generator but it's not that hard. Take a look at org.hibernate.id.GUIDGenerator and I would say just copy is and put your stored procedure call in it.

Nonetheless, I am not sure if there is an easier way for this.



Farzad-

Thanks for the input, I was taking a look at using primary key assigned by a trigger. The trigger wud internally call the proc to get the id. Not sure if it works, but I wud definitely look into ur recommendation and post my findings here...

Thanks