3 Replies Latest reply on Feb 27, 2004 10:44 AM by luigifonti

    Transaction Warnings

    luigifonti

      I have developed my first, simple, Bean managed Entity bean.
      I am using Jboss-3.0.4 and mySql-3.2
      Everyting works, but every time I access the database using the bean, i get some warnings, like:

      1) javax.transaction.xa.XAException: wrong id in commit:
      expeced: null, got: XidImpl

      2) javax.transaction.xa.XAException: Error trying to start local tx:
      javax.resource.ResourceException: SQLException

      May be there is something wrong in my code or in some xml file.
      Where can I find a full, working example of Bean managed Entity bean for Jboss-3 to compare with mine ?
      Luigi Fonti

        • 1. Re: Transaction Warnings
          milowe

          Dont think your setup supports two phase commit (unless you are using a custom XA wrapper). Change to use local datasource for your mySQL instead of xa.

          • 2. Re: Transaction Warnings
            luigifonti

            For what I can understand, my jboss installation is already configured for local datasource: mysql-service.xml has the following tags in it:



            <module-option name = "managedConnectionFactoryName">
            jboss.jca:service=LocalTxCM,name=MySqlDS
            </module-option>

            Is that what you mean ? Where else should I intervent ?
            Luigi Fonti

            • 3. Re: Transaction Warnings
              luigifonti

              Found the solution: substituted mysql.jar wih a more recent version taken from mysql-connector-java-3.0.11 and everithing went to place.
              Formerly I was using a very old mmjdbc version.
              Luigi Fonti