File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JBoss/WildFly and the fly likes MySQL and XA Datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "MySQL and XA Datasource" Watch "MySQL and XA Datasource" New topic
Author

MySQL and XA Datasource

Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

MySql recently supports transactions, and the mm.mysql driver (which has now been taken over by the mysql people), also provides a DataSource factory object.

So has anyone attempted to make an XA-aware DataSource mysql-service.xml file?

I'm attempting something like that now with mixed results.
George Brown
Ranch Hand

Joined: Sep 26, 2000
Posts: 919
I took the example mysql-service.xml and changed the parts that needed changing for my setup, and that works fine for the non-invasive commands I've so far thrown at it, but I've not attempted to do any distributed transactions quite yet. Just the local transactions manager setup so far.
How are your experiments going? I'll be very interested in whether you can get an XA datasource working with it.
[ September 09, 2002: Message edited by: George Brown ]
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

For what it's worth, here's my file:

This is for a product called JIRA ( www.atlassian.com/software/jira ), which requires the XA-aware datasource. I think it's working, at least I can use the product. Is there any way to tell for sure if the driver is appropriately using db pools? Is there a nice admin tool to be used to find this info out? I've really never used JBoss at all before. I switched to it after several frustrating days trying to get XADatasources to work with Tomcat/Tyrex.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL and XA Datasource