1 Reply Latest reply on Feb 27, 2004 10:43 AM by luigifonti

    Warnings with mySql - XA


      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 ?

      Somebody already game me a suggestion on this regard:
      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.

      But I don't know which type of change I should do and where.
      Please help me.

      Luigi Fonti

        • 1. Re: Warnings with mySql - XA

          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