• 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Tim Holloway
  • Carey Brown
  • salvin francis

MySQL and XA Datasource

 
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.
 
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.
 
Can you shoot lasers out of your eyes? Don't look at this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!