Hi, I have configured master-datasources.xml and used transaction mediator similar to [1] with MYSQL. In a scenario , where we restart MYSQL server while executing a transaction following error is displayed and we cannot perform any more transactions without a EI server restart.
Caused by: com.atomikos.datasource.ResourceException: XA resource 'TXDB1': resume for XID '3132372E302E302E312E746D30303030383030303639:3132372E302E302E312E746D38' raised -7: the XA resource has become unavailable at com.atomikos.datasource.xa.XAResourceTransaction.resume(XAResourceTransaction.java:505) According to [2] it seems to be a known issue with MYSQL XA transactions ,which occurs when we try to access the same database multiple times using the same transaction. It also suggests a workaround of setting some properties, however this does not solve the issue.(Tried with mysql-connector-java-6.0.6.jar) Appreciate any feedback on this. [1] https://docs.wso2.com/display/EI611/Transaction+Mediator+Example [2] https://www.atomikos.com/Documentation/KnownProblems#JTDS_XA_Driver_Problems Thanks, Himasha Guruge Senior Software Engineer WS*O2* *Inc.* Mobile: +94 777459299 [email protected]
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
