Hi all,

I'm using Hibernate 3.1rc2 on JBoss4.0.3sp1 (the version delivered with JBoss 4.0.3sp1) with a two node jboss cluster with Oracle 10g as database.
Using the MultipleHiLoPerTableGenerator, I found in some rare cases two lines with the same sequence_name in the hibernate_sequences table, and even worse, I ran into constraint violations of the primary key constraint of the table whose name occurred twice in the hibernate_sequences table.
Investigating the problem in more detail, I saw that this happenend because the same action was done on both cluster nodes nearly exactly at the same time.
Looking at the last example on page http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html, IMO this is a problem that can not be solved with Oracle.
A possible workaround of course would be to insert all required rows in the hibernate_sequences table before application startup, but the problem reamins IMO when the two cluster nodes accidentially increase their sequence number at the same time.

Is this a known issue, and if so, is there a solution for it?
Or is my understanding of the case not correct?

Regards,
Martin[/url]