0 Replies Latest reply on Oct 24, 2002 5:23 PM by Clark Wright

      associateConnection not supported Error with XATxConnectio

    Clark Wright Newbie


      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.