• Post Reply Bookmark Topic Watch Topic
  • New Topic

Oracle XA Datasource

 
sudha swami
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I want to know when to use Oracle XA Datasource in the web application over Oracle Datasource?
regards
sudha
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36032
432
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sudha,
XA is for two phase commit. If you are using two different databases, you need to use an XA Datasource.
 
sudha swami
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
We are using only one database i.e Oracle 9i. We have webservices too. I dont know why they need Oracle XA Datasource.
regards
sudha
 
Raees Uzhunnan
Ranch Hand
Posts: 126
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you want to do 2 different things in one unit of work ; you will need to use XA. In your case it may be invoking a webservice and updating a database.

If all your operations in a unit of work is going to a single database ; you do not need a XA driver
 
sudha swami
Ranch Hand
Posts: 186
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the info
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!