• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

MySQL and XA Datasource

 
Ranch Hand
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 919
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
reply
    Bookmark Topic Watch Topic
  • New Topic