[jboss-user] [Datasource Configuration] - Re: mysql-xa-ds.xml and mysql-ds.xml file
Wolf-Dieter Fink
do-not-reply at jboss.com
Fri Jun 8 04:38:58 EDT 2012
Wolf-Dieter Fink [https://community.jboss.org/people/wdfink] created the discussion
"Re: mysql-xa-ds.xml and mysql-ds.xml file"
To view the discussion, visit: https://community.jboss.org/message/740631#740631
--------------------------------------------------------------
1)
The difference is the datasource type:
* local transactions
There is no two-phase-commit protocol to ensure consistency of distributed transactions
If you have only one datasource (mean also no JMS or other JCA involved) you can use this save
* XA transactions
Protocol to ensure consistency in distributed systems (search for XATransaction i.e. wikipedia)
If you have more than one database involved you should use this because of consistency
2)
You can have more than one datasource definition in one *-ds.xml file if you need
3)
I don't understand it exactly, but if you mean the difference of having one (with both definitions) or two ds.xml files the only difference is that you can not (un)deploy it separate.
The pools and connections are separate anyway.
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/740631#740631]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120608/33efa6de/attachment.html
More information about the jboss-user
mailing list