Skip to content

XAware Community

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
XAware 5.6
Need Help
Webinars and Events
Advanced Tutorials
Webinars and Events

You are here: Home arrow Forums
XAware Community Forums
Welcome, Guest
Please Login or Register.    Lost Password?
XA compliant distributed transactions and MySQL (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 10
TOPIC: XA compliant distributed transactions and MySQL
#126
billm (User)
XAware user
Posts: 83
User Offline Click here to see the profile of this user
XA compliant distributed transactions and MySQL 11 Years, 10 Months ago Karma: 2  
This is an email thread that I thought should be posted in this forum, so here it is:
------------------------
QUOTE:
The official WebLogic Server documentation claims that MySQL is not fully XA compliant (this from http://edocs.bea.com/wlp/docs100/db/mySQL.html)

WARNING: The MySQL JDBC driver is not fully XA compatible, therefore WebLogic Portal does not support using the com.mysql.jdbc.jdbc2.optional.MysqlXADataSource



The management console for WebLogic Server v10 does not even allow the user to configure MysqlXADataSource (the supposedly XA compliant driver provided by MySQL) as the driver to use for a DataSource it is not available in the list of valid choices.

I therefore did not even test distributed transactions with MySQL and WLS. Other distributed transactions tests with MySQL and JBoss failed in places where the exact same test using Oracle instead of MySQL succeeded.



From: Kirstan Vandersluis
Sent: Thursday, November 29, 2007 5:36 PM
To: Ronald Trask; Sean Dwyer; Darin G. Black; Tim Uttormark
Cc: Melissa Burkett; Bill Miller
Subject: RE: MySQL - XAware Issues

Tim, I believe you mentioned early this week that you discovered MySQL is not XA compliant. Is that correct? Ron seems to be finding this to be the case.

Thanks,

-Kirstan



From: Ronald Trask
Sent: Thursday, November 29, 2007 4:59 PM
To: Sean Dwyer; Kirstan Vandersluis; Darin G. Black
Cc: Melissa Burkett; Bill Miller; 'Chris Falsone'
Subject: RE: MySQL - XAware Issues
Sure,

The problems that I have been having with MySQL in the workflow application for APT are not with XAware per se, but have to do with JBoss and MySQL not playing well together. XAware is impacted, because it is using the server managed datasource.

When using MySQL as the default data source I have been getting a number of errors. I believe that given the time the issues could ultimately be traces to a lack of support in MySQL for XA transactions. MySQL 5.0 which is what I have been using at APT is the first generation to support XA transactions. I have attempted to configure JBoss to use the new MySQL XA support, but was ultimately not able to make it work. The lack of information on the web on this topic, and the fact that JBoss provides examples of how to configure other XA datasources, but does not provide information on a MySQL datasource raised a concern that this configuration could not be made stable.

The problems are made manifest in the following ways:
1.) While processing a long standing transaction in JMS operation, a lock timeout on the MySQL connection occurs when the system attempts to write to the audit log.
2.) An attempt to start a Timer causes an exception because it can not start a new transaction. In tracking down the error message the recommended fix is to use a XA datasource.
3.) Overnight the JMS connection becomes stale when the JDBC connection times out. The connection can be recovered, but then JBoss gets in to a corrupted state. Looking through the logs, this appears to be related to transaction state. This seems strange, since there should be no active transaction as no work is being done, so there should be no transaction but that is what I gather by researching the exceptions that are being raised.
There are other one of a kind occurrences that have happened during testing which while less researched still point to this conclusion.

All in all I was happy with the way that MySQL was working in the system. We could run the application end to end, but I could not make it stable enough to put into a production environment. From a previous conversation APT had requested to know what would be required to switch to SQL Server. Since SQL Server has supported XA for a longer time and is more stable. Since there is real urgency to get the product deployed I felt it prudent to make the suggestion which APT agreed to.


-- Ron
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
XA compliant distributed transactions and MySQL Favorite
billm 2007/11/30 19:44
    thread link
thread linkthread link Re:XA compliant distributed transactions and MySQL
billm 2007/12/02 21:52
    thread link
thread linkthread linkthread link Re:XA
inetryconydot 2013/07/25 22:50
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/09/18 09:53
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/09/22 09:24
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/09/27 04:40
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/09/28 07:26
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/09/29 08:56
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/09/30 10:33
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/10/01 13:12
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/10/02 19:48
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/10/04 02:00
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2013/10/05 07:51
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2014/02/07 05:48
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2014/03/13 02:14
    thread link
thread linkthread linkthread linkthread linkthread link Re:XA
XRumerTest 2017/09/09 16:24
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2014/06/18 00:31
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2015/02/05 14:21
    thread link
thread linkthread linkthread linkthread link Re:XA
inetryconydot 2015/02/09 10:02
    thread link
thread linkthread link Re:XA compliant distributed transactions and MySQL
billm 2007/12/03 03:27
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Community Login

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
Commercial
Free Training
QuickStart Packages
Image 4 Title
Image 5 Title

Visit XAware.com