Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

cannot add non-XA Resource to global JTS transaction

 
Hastono Bayu
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanx for the info,

I hope mysql will support this XA datasource soon

Regards,


Bayu
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic