File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 Java 8 in Action this week in the Java 8 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
 
Similar Threads
XA DataSource configuration Error/Exception in JBoss
getting org.jboss.resource.adapter.jdbc.WrapperDataSource cannot be cast to javax.sql.XADataSource
Usage of XA DataSource while working with single resource.
Problem setting up dukes bank application with Oracle
Not Finding DataSource in JNDI Tree