I try to configure an XA datasource with Oracle10g
but if I put
<transaction-isolation>TRANSACTION_SERIALIZABLE</transaction-isolation>
into the <xa-datasource>
then I get the following error on JBoss startup:
2006-03-15 13:17:49,938 WARN [org.jboss.tm.TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=egistir/2, BranchQual=, localId=2] errorCode=XAER_PROTO
oracle.jdbc.xa.OracleXAException
at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:938)
at oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:244)
at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.start(XAManagedConnection.java:131)
etc.
(if I comment out the transaction-isolation, then it starts up without problem)
how can I use serializable transactions with Oracle10g XA datasource?
I use the Oracle 10g thin driver with JBoss Application Server 4.0.3 SP1 + JBoss EJB3 RC5, JDK1.5
I read something about the OracleXAResource.ORATMSERIALIZABLE constant, I wonder if it has anything to do with this problem...
For the Oracle specific nonsense, there already is a feature request.
Vote for it.