MySql [WARN] XAException

[mchuevo]

Hi, i have a problem, with a BMP entity bean, when i'm trying to do some transactions with mysql, with a ResourceException and XAException. The transactions (select, insert, etc), are done, but i'm getting a warning on Jboss console, and it's really large. So If someone can help me with this, I'll appreciate. Thank You.


I'm getting something like this:
23:23:20,728 WARN [TxCapsule] XAException: tx=XidImpl [FormatId=257, GlobalId=m
chuevo//22, BranchQual=] errorCode=XA_UNKNOWN(0)
javax.transaction.xa.XAException: Error trying to start local tx: javax.resource
.ResourceException: SQLException at org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalCo
nnectionEventListener.start(LocalTxConnectionManager.java:502)
at org.jboss.tm.TxCapsule.startResource(TxCapsule.java:1200)
at org.jboss.tm.TxCapsule.enlistResource(TxCapsule.java:694)
at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:102)

at org.jboss.resource.connectionmanager.LocalTxConnectionManager$LocalCo
nnectionEventListener.enlist(LocalTxConnectionManager.java:320)
at org.jboss.resource.connectionmanager.LocalTxConnectionManager.managed
ConnectionReconnected(LocalTxConnectionManager.java:255)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateC
onnection(BaseConnectionManager2.java:534)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$Connectio
nManagerProxy.allocateConnection(BaseConnectionManager2.java:812)
at org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(L
ocalDataSource.java:102)
at examples.AccountBean.getConnection(Unknown Source)

[schererjay]

Have you solved this issue? I've got exactly the same problem and from what I'm reading, the issues lie elsewhere within jboss's xa implementation. Can you shed any light on this issue?

Thanks,
Jay

[machinehoofd]

I'm very interested in the solution to this problem too. It weird: everything works but the system generates so many errorcode...

Ronald

[machinehoofd]

Hello!
I think I found a solution: I downloaded the new MySQL Connector from (new version of MM.MySQL) It's now the official JDBCdriver for MySQL and the problem was solved! Also my 'No Managed Connections Available' problem is gone now!

Hope it helps!

Ronald

[djaquay]

Hey, whaddya know, that worked. But not until I restarted JBoss, which surprised me. I removed the old MM.MySQL connector from ../server/default/deploy, and copied in the new one, and JBoss gave the [INFO] message saying that it was deployed, but until I restarted things, I was still getting the exception messages.

Anyway, thanks for the info. The driver was at www.mysql.com, (you said "from" but didn't provide the URL). Also for reference sake, I'm using JBoss 3.0.2 and MySQL 3.23.51.

Dave

[erik777]

When you say you installed the "new version", are you referring to the latest stable release (2.x) or beta (3.x)? It would be most helpful to know the exact version number. Thanks.