associateConnection not supported Error with XATxConnectio

[cwright1]

Using :
Jboss 3.0
Mysql 3.23.51-max-nt
Mysql Connector/J 2.14
Castor 0.9.4

I am trying to get the jboss Xa connection manager configured/to work with the above configuration.

And, to a certain extent, it does.

Accessing the DB via jsp (no ejb involved) works fine.

What am I missing?

The first ejb connection works fine.

The second ejb to access the DB gets the following:

at org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:715)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.lang.reflect.UndeclaredThrowableException
at $Proxy27.listAuthServices(Unknown Source)
... 26 more
Caused by: javax.resource.ResourceException: associateConnection not supported
at org.jboss.resource.adapter.jdbc.BaseManagedConnection.associateConnection(BaseManagedConnection.java:91)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.reconnect(BaseConnectionManager2.java:594)
at org.jboss.resource.connectionmanager.CachedConnectionManager.reconnect(CachedConnectionManager.java:331)
at org.jboss.resource.connectionmanager.CachedConnectionManager.pushMetaAwareObject(CachedConnectionManager.java
:131)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:183)

at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)

The third ejb invocation produces:

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:287)
at org.mortbay.util.ThreadPool$JobRunner.run(ThreadPool.java:715)
at java.lang.Thread.run(Thread.java:536)
Caused by: java.rmi.ServerException: disconnect(ManagedConnection mc: null, Object c: XAConnection: Connection closed) c
alled with unknown managed connection; nested exception is:
java.lang.IllegalArgumentException: disconnect(ManagedConnection mc: null, Object c: XAConnection: Connection cl
osed) called with unknown managed connection
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:119)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:167)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:61)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:129)

The config is:

<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--embedded mbean-->


MySqlDS



<config-property name="XADataSourceProperties" type="java.lang.String">ServerName=localhost;DatabaseName=lqmi;Port=3306</config-property>

<config-property name="XADataSourceClass" type="java.lang.String">com.mysql.jdbc.jdbc2.optional.MysqlXaDataSource</config-property>
<!-- Non XA config properties
<config-property name="ConnectionURL" type="java.lang.String">jdbc:mysql://localhost:3306/lqmi</config-property>
<config-property name="DriverClass" type="java.lang.String">com.mysql.jdbc.Driver</config-property>
set these only if you want only default logins, not through JAAS
<config-property name="UserName" type="java.lang.String"></config-property>
<config-property name="Password" type="java.lang.String"></config-property>
-->






Any suggestions, pointers or hints greatly appreciated.

- clark.