Mapping documents:

Hello,

I am trying to generate a custom Id using the oracle sequence.

This is what I want to do. I want to generate a custom Id which is like "S101", here I will get the value "101" from the sequence. I need to append a character "S" to that value, is there any way I can accomplish this? Can I write custom generator class and if so how? Thanks for your time

Thomas

I don't think you can do that. If you want the database to generate the id, well, the database generates it and you have no control over it. Also, a sequence is a number. By putting a letter in front of it you change its type. Maybe oracle let you tweak id generation, maybe you could perform the necessary select to get the next sequence from oracle and use it to form your final id. You would then use the "assigned" generator. However, I'm not sure you can ask Oracle to give you a new id, normally, you perform an insert and you get the generated id afterward.

fdelisle:

I solved the problem as described in http://forum.hibernate.org/viewtopic.php?t=929341

Thanks for you time. I created the custom class to generate the id by implementing net.sf.hibernate.id.Configurable and net.sf.hibernate.id.PersistentIdentifierGenerator

Thanks for your time