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?
