Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • 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
Marshal
Posts: 34973
379
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic