Has anyone setup JBoss Messaging on MySQL 5 with an XAConnection? I am using the persistance service from the examples but am getting the following when starting the server:
2006-06-05 16:03:59,376 DEBUG (Thread: main) [server.plugin.JDBCChannelMapper] Failed to create users table: CREATE TABLE JMS_USER (USERID VARCHAR(32) NOT NULL, PASSWD VARCHAR(32) NOT NULL, CLIENTID VARCHAR(128), PRIMARY KEY(USERID)) | java.sql.SQLException: XAER_RMFAIL: The command cannot be executed when global transaction is in the ACTIVE state | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2822) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1626) | at com.mysql.jdbc.Connection.execSQL(Connection.java:3025) | at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1147) | at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1070) | at com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeUpdate(StatementWrapper.java:801) | at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:161) | at org.jboss.jms.server.plugin.JDBCChannelMapper.createSchema(JDBCChannelMapper.java:1091) | at org.jboss.jms.server.plugin.JDBCChannelMapper.startService(JDBCChannelMapper.java:205) | at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274) | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:181) | ... View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3949207#3949207 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3949207 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user