0 Replies Latest reply on Dec 5, 2007 4:29 AM by Christian Ernstbrunner

    Problem with JMS in connection with an XA Datasource

    Christian Ernstbrunner Newbie

      I've set up an XA DataSource to a MySQL DB (replacing the DefaultDS).
      I use this XA DataSource for JMS as well (Made it correctly: replacing the jms-jdbc2-service.xml by mysql-jdbc2-service.xml file, ...)


      The problem is, that I get following error when starting the server:
      ...
      Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'mySchema.jms_transactions' doesn't exist
      ...

      So the error message is correct, not a single JMS_* table was generated.
      (When trying with a local-tx-datasource on the same MySQL Schema it all works correctly; It also works if a create the JMS_ tables by hand)

      Did anybody face a similar problem? How can i solve it?