|
I'm running into a problem with Oracle XA in
3.2RC1. I'm asking here first because I know there are a bunch of frequent
problems with the Oracle XA driver and I know some of them are supposed to be
fixed in 3.2RC1 and I want to see if anyone has experience with this
problem.
I have a really simple test. I have a
client that starts up N threads. Each thread calls bean A. Bean
A calls bean B and bean B gets an Oracle connection (from an XA pool) and
inserts a record into the database and then closes the connection and
returns. This all works fine under lower load, but gets the stack trace
below occasionally under heavy load. In some cases I then start getting
"ORA-01591: lock held by
in-doubt distributed transaction" on Oracle calls
after the error.
I've tried with and without
TrackConnectionByTx. My oracle-xa-ds.xml is pasted below the stack
trace. Is this a bug or am I missing something?
2003-01-21 21:42:09,141 WARN
[org.jboss.tm.TransactionImpl] XAException: tx=Tra
nsactionImpl:XidImpl [FormatId=257, GlobalId=malt//1809, BranchQual=] errorCode= XAER_RMERR oracle.jdbc.xa.OracleXAException at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1157 ) at oracle.jdbc.xa.client.OracleXAResource.commit(OracleXAResource.java:5 90) at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.commit(XAManag edConnection.java:140) at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:142 0) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:349) at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCM T.java:361) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxIntercep torCMT.java:247) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:1 01) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor. java:130) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204) at org.jboss.ejb.plugins.CleanShutdownInterceptor.invoke(CleanShutdownIn terceptor.java:265) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFacto ryFinderInterceptor.java:154) at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContai ner.java:303) at org.jboss.ejb.Container.invoke(Container.java:680) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) at org.jboss.invocation.jrmp.server.JRMPInvokerHA.invoke(JRMPInvokerHA.j ava:163) at java.lang.reflect.Method.invoke(Native Method) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:236) at sun.rmi.transport.Transport$1.run(Transport.java:147) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:143) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:4 60) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport .java:701) at java.lang.Thread.run(Thread.java:479) oracle-xa-ds
------------------
<?xml version="1.0"
encoding="UTF-8"?>
<datasources>
<xa-datasource> <jndi-name>XaOracleDS</jndi-name> <track-connection-by-tx>true</track-connection-by-tx> <managedconnectionfactory-class>org.jboss.resource.adapter.jdbc.xa.oracle.XAOracleManagedConnectionFactory</managedconnectionfactory-class> <!--xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class--> <xa-datasource-property name="URL">jdbc:oracle:thin@server:port:sid</xa-datasource-property> <xa-datasource-property name="User">scott</xa-datasource-property> <xa-datasource-property name="Password">tiger</xa-datasource-property> <min-pool-size>0</min-pool-size> <max-pool-size>50</max-pool-size> <blocking-timeout-millis>20000</blocking-timeout-millis> <idle-timeout-minutes>15</idle-timeout-minutes> </xa-datasource> </datasources> Thanks,
Matt Cleveland
|
- Re: [JBoss-dev] 3.2RC1 Oracle XA Problem Matt Cleveland
- Re: [JBoss-dev] 3.2RC1 Oracle XA Problem Igor Fedorenko
- Re: [JBoss-dev] 3.2RC1 Oracle XA Problem Matt Cleveland
- Re: [JBoss-dev] 3.2RC1 Oracle XA Problem Matt Cleveland
- Re: [JBoss-dev] 3.2RC1 Oracle XA Problem Igor Fedorenko
- [JBoss-dev] HA Retrying a Transaction... Matt Cleveland
- RE: [JBoss-dev] HA Retrying a Tra... Bill Burke
- Re: [JBoss-dev] 3.2RC1 Oracle... Matt Cleveland
- Re: [JBoss-dev] 3.2RC1 Oracle XA Prob... Matt Cleveland
- Re: [JBoss-dev] 3.2RC1 Oracle XA ... Igor Fedorenko
- Re: [JBoss-dev] 3.2RC1 Oracle... Matt Cleveland
