hello!

I have setup the below code for an Oracle sequence, when I insert rows,
the unique id seems to be random 41, 63, 69 out of sequence though they have been inserted in a sequence on after the other, why is hibernae doing this? I am able to insert directly using JDBC inserts and the sequence of unique ids gnerated by oracle are maintained

any ideas?

Any body has any ideas please?

As far as I know, Oracle fetches internally a set of sequence number per jdbc-connection (oracle session) and asigns for example id-numbers out of these sets (if all sequence numbers are assinged, another set will be fetched and so on.). So ids might have 'jumps' in their evolution with two or more database-sessions using a 'shared' sequence. I'm not sure, if Oracle assures that seq(t1)>seq(t2).

Once you get a sequence you cannot get the same one again.
Are you sure you are not getting the sequence from anywhere else?
If you encounter an exception while inserting and then do it all over again, you will get another sequence. So, you may skip sequence nos.

Please check that this isn't happening in ur case.