Optimistic transactions fail

[stitzl]

Hi *,

while running ECperf against JBoss 2.4.4 or 2.4.6 I get lots of Exceptions in the Manufacturing domain. Funny enough, all of these are of the same kind:




L1:0: Error occured in scheduleWorkOrder
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
javax.transaction.TransactionRolledbackException: null
Embedded Exception
null
Embedded Exception
null
Embedded Exception
Optimistic concurrency control failed ; nested exception is:
javax.ejb.EJBException: null
Embedded Exception
Optimistic concurrency control failed ; nested exception is:
javax.ejb.EJBException: null
Embedded Exception
null
Embedded Exception
Optimistic concurrency control failed ; nested exception is:
javax.ejb.EJBException: null
Embedded Exception
Optimistic concurrency control failed ; nested exception is:
javax.ejb.EJBException: null
Embedded Exception
null
(... this is repeated some more times for a given Exception ...)




From this I gather that there have been conflicting updates, so that the transaction has to be rolled back.

Has anyone encountered the same problem yet? I am using CMP, ECperf 1.1, Oracle 8.1.7, JDK 1.4, J2EE 1.3.1

There are no exceptions in the orders domain.

I'm looking for suggestions where and how to fix this problem.

Thanks in advance,
Lars

[stitzl]

Ok, update: this also seems to happen with Oracle 9i. The thing I'd like to know now is whether this is JBoss's problem or Oracle's. I gather that JBoss should use pessimistic locking per default, so it seems like something hidden in the JDBC layer.

Any ideas, anyone?

Cheers,
Lars