This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
 
subject: cannot add non-XA Resource to global JTS transaction
 
Similar Threads
getting org.jboss.resource.adapter.jdbc.WrapperDataSource cannot be cast to javax.sql.XADataSource
Problem setting up dukes bank application with Oracle
Usage of XA DataSource while working with single resource.
XA DataSource configuration Error/Exception in JBoss
Not Finding DataSource in JNDI Tree