5 Replies Latest reply: Oct 20, 2005 4:38 AM by Vaidyanathan B RSS

    XaConnectionFactory not bound...

    groo Newbie

       

      "groo" wrote:
      Hi

      I tried to install mySQL as my default datasource with JBoss. I followed the steps mentioned in the JBoss tutorial. JBoss tries again and again to reconnect to JMS provider and gets the following error :


      WARN [JMSContainerInvoker] JMS provider failure detected:
      javax.jms.JMSException: Error creating the dlq connection: XaConnectionFactory not bound


      Here is my config and code :

      -JBoss 3.2.3
      -Mysql 4.0.17

      -mysql-connector-java-3.0.10-stable-bin.jar placed in server/default/lib
      -hsqldb-ds.xml and hsqldb-jdbc2-service.xml removed

      here is my mysql-ds.xml :
      <?xml version="1.0" encoding="UTF-8"?>
      
      <-datasources>
       <local-tx-datasource>
       <jndi-name>DefaultDS</jndi-name>
       <connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
       <driver-class>com.mysql.jdbc.Driver</driver-class>
       <!--<driver-class>org.gjt.mm.mysql.Driver</driver-class>-->
      <user-name>jboss</user-name>
      <-password>password</-password>
      
       </local-tx-datasource>
      </-datasources>
      


      note : I had to put a "-" before datasource and password in this post because these tags weren't printing

      I also modified the depends in my mysql-jdbc2-service.xml.xml :


      jboss.jca:service=LocalTxCM,name=DefaultDS


      and the standardjbosscmp-jdbc.xml :


      datasource set to : java:/DefaultDS
      datasource mapping set to : mySQL

      I searched in the other topics and I find that some people had similar problems but I found no solutions in the replies.

      Anyone have ideas or tips to help me solve this problem ?

      Thanks


        • 1. Re: XaConnectionFactory not bound...
          DRAI William Newbie

           

          "wdrai" wrote:
          I had the same problem.

          I solved it by changing QueueFactoryRef and TopicFactoryRef to java:/ConnectionFactory instead of java:/XAConnectionFactory in jms-ds.xml.

          I don't understand why the XAConnectionFactory is not bound with MySQL, perhaps someone could explain how it is supposed to work.


          • 2. Re: XaConnectionFactory not bound...
            groo Newbie

             

            "groo" wrote:
            I changed it as you told me wdrai but unfortunately, I got a ConnectionFactory not bound error instead of a XaConnectionFactory not bound...


            • 3. Re: XaConnectionFactory not bound...
              Martin Husted Hartvig Newbie

              I know this is an old topic, but I think I found what the problem was.

              I'm using Postgres and have till now used jboss 3.2.3, I tryed to move to 3.2.4 and 3.2.5 (wrote on a topic, but Adrian came with the faq message), but got the same error as written about here. Now I have tryed on 3.2.6 and ofcourse got the same error. I looked around the on the site, without success, and then I took a look... there was a new file in the deploy/jms folder "hsqldb-jdbc-state-service.xml". I renamed it to "postgres-jdbc-state-service.xml" and all my problems went away.

              I'm writing this so other with the same problem can get some help, maybe someone will write a little hint in the faq?

              Regards,
              Martin

              • 4. Re: XaConnectionFactory not bound...
                Martin Husted Hartvig Newbie

                Sorry, I didn't notice that "groo" was using 3.2.3. That makes my post as being placed in the wrong topic.

                Martin

                • 5. Re: XaConnectionFactory not bound...
                  Vaidyanathan B Newbie

                  Hello,

                  We had the same problem too while moving from Firebird to MySql.

                  This is the jms-ds.xml file we used for Firebird :

                  <connection-factories>
                   <tx-connection-factory>
                   <jndi-name>FirebirdDS</jndi-name>
                   <xa-transaction/>
                   <adapter-display-name>Firebird Database Connector</adapter-display-name>
                   <config-property name="Database" type="java.lang.String">${streetwise.url}</config-property>
                   <user-name>${streetwise.username}</user-name>
                   <password>${streetwise.password}</password>
                   <track-connection-by-tx>true</track-connection-by-tx>
                   <min-pool-size>0</min-pool-size>
                   </tx-connection-factory>
                  </connection-factories>
                  


                  But MySql seems to need local data sources. So please use the ds version that ships with Jboss in the examples folder. (http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAMysqlDatasource)

                  As for the DLQ error, remember to change the name of the ConnectionManager attribute to LocalTxCM instead of TxCM in the *-jdbc2-service.xml and *-jdbc-state-service.xml files.