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

MySQL and XA Datasource

 
Mike Curwen
Ranch Hand
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 919
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic