Hi,

Often in Oracle mimic Identity column using a DB Trigger On Insert with a Sequence. Is it possible to use the generator identity in Hibernate or it requires to write your own identifier generator?

Thank you.

Yes, for sure. Just edit the <id>-tag of your mapping file for the specific table:

where: PAR_SQ is the name of sequence.[/code]

Thank you for your reply.

I asked if we can use generator name "identity".
Besides I doubt that generator name "sequence" will work at all because in this case we will have two accesses to the same sequence - one from Hibernate, another from trigger on insert which also increases sequence leaving value in Java code less than in DB.

I was assuming you want to replace the trigger functionality. If you don't then use "assigned". However, you have to code the access to the sequence yourself. Afaik there is no hibernate built-in command for retrieving the next value from a sequence.

If this is the existing DB with such functionality and with another applications relying on it we can not replace this trigger. From the Hibernate point of view it should look as identity column and I hoped that Hibernate accepts this as identity column.

I am not saying its the right thing to do but ..... If you
customise the Oracle dialect you should be able to get it to happen.

Thank you.

Perhaps it is so common for Oracle database applications consider it as feature request?

hi,
if you don't use oracle Identity column using a DB Trigger, you msut define this column as normal int column, then you can create your own identifier generator to write it.

What about the "select" id generator ? It looks like it's made for such cases.

And in case you don't have a natural primary key to use with the select id generator, see also this thread: http://forum.hibernate.org/viewtopic.php?t=973262