Oracle DS - JBoss-3.2.0beta2
kurt Nov 13, 2002 2:53 PMHi,
I've been reading the discussions about the oracle XA transaction problems - http://www.geocrawler.com/mail/msg.php3?msg_id=9807858&list=10766 - Thank you so much for addressing the oracle XA problems. We have the exact same problems and I'm following your advice to set the <track-connection-by-tx> to true. For that I need to have jboss-3.2 though. I've build jboss-3.2.0beta2 (from cvs) and it looks your deployment descriptors have been added to this. I guess I now just need to deploy the oracle-xa-ds.xml (no longer the oracle-xa-service.xml)? I did this and got:
13:33:42,921 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
Incompletely deployed packages:
MBeans waiting for classes:
MBeans waiting for other MBeans:
[ObjectName: jboss.jca:service=XATxCM,name=XAOracleDS
state: CONFIGURED
I Depend On: jboss.jca:service=XATxDS,name=XAOracleDS
jboss.jca:service=LocalTxPool,name=XAOracleDS
jboss.jca:service=CachedConnectionManager
jboss.security:service=JaasSecurityManager
jboss.jca:service=RARDeployer
Depends On Me: , ObjectName: jboss.jca:service=XATxDS,name=XAOracleDS
state: CONFIGURED
I Depend On: jboss.jca:service=RARDeployment,name=Minerva JDBC XATransaction ResourceAdapter
Depends On Me: jboss.jca:service=XATxCM,name=XAOracleDS
]
Is jboss-3.2.0beta2 the version I'm supposed to use? Any idea what I'm doing wrong? Our app depends heavily on XA's spanning JMS queues and oracle so I we really need to get a jboss version up in which this stuff works...
This is the code in my oracle-xa-ds.xml:
<xa-datasource>
<jndi-name>XAOracleDS</jndi-name>
<!-- The following optionally turns on the TrackConnectionByTx property
of XATxConnectionManager. This property creates a 1 to 1 mapping of
JDBC connections to transactions and prevents a connection from
participating in more than one transaction at the same time. Setting this
to true seems to fix quite a few Oracle XA bugs. -->
<track-connection-by-tx>true</track-connection-by-tx>
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:oracle:thin:@localhost:1521:TPS0</xa-datasource-property>
<!-- Not needed?
<xa-datasource-property name="DatabaseName">TPS0</xa-datasource-property>
-->
<user-name>scott</user-name>
tiger
</xa-datasource>
Any help is greatly appreciated!
Kurt