I don't know what your implementation looks like
, but I think you have to very
careful with the approach you have taken.
Create a separate UniqueID table instead, that keep track of the Ids.
Hi, thanks for the reply.
The reason I am confused is because when using Oracle 9i Application Server...when you create an EJB (supplying a unique ID), this is reflected immediately in the database.
However in JBOSS, (as described in the above scenario), this is not true.
I have solved my problem!
In case anyone has the same problem... it is to do with ejb-transactions.
I had to set the ejb transaction for my particular ejb to RequiresNew so that the transaction is commited immediately.