aspose file tools*
The moose likes Other Java Products and Servers and the fly likes cannot add non-XA Resource to global JTS transaction Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "cannot add non-XA Resource to global JTS transaction" Watch "cannot add non-XA Resource to global JTS transaction" New topic
Author

cannot add non-XA Resource to global JTS transaction

Hastono Bayu
Greenhorn

Joined: Oct 13, 2003
Posts: 8
I got the error message
"cannot add non-XA Resource to global JTS transaction" inside the server log
when i try to create a conection to
MySQL pool from a message driven bean in the onMessage() method. I used SUn ONE App Server 8 as the application server for my bean.
here's my connection pool setting for mysql
Name : MySQLConnPool
DataSource Class Name :com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource
Property
user : user
password : pass
port : 3306
the ping test was successful, and when i created a connection inside a servlet this error wasnt show up.
Can anyone help me please??
Do i need an XA DataSource ?? i try to find it in MySQL Connector/J but there's no such a class inside the package
Thanx in advance...

Regards,
Bayu
Rune Larsen
Greenhorn

Joined: May 14, 2004
Posts: 1
Your MySQL JDBC driver doens't support XA Transaction proticol.

If it's necesary for you to have MySQL participate in global transactions, you need an XA driver. Read more here: http://bugs.mysql.com/bug.php?id=1737

If not, you can probably use an XA wrapper to "fake" XA-support.
Hastono Bayu
Greenhorn

Joined: Oct 13, 2003
Posts: 8
Thanx for the info,

I hope mysql will support this XA datasource soon

Regards,


Bayu
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: cannot add non-XA Resource to global JTS transaction