Matt Cleveland wrote:
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
-- Igor Fedorenko Think smart. Think automated. Think Dynamics. www.thinkdynamics.com
------------------------------------------------------- This SF.net email is sponsored by: Scholarships for Techies! Can't afford IT training? All 2003 ictp students receive scholarships. Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more. www.ictp.com/training/sourceforge.asp _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
