aspose file tools*
The moose likes JDBC and the fly likes Oracle XA Datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle XA Datasource" Watch "Oracle XA Datasource" New topic
Author

Oracle XA Datasource

sudha swami
Ranch Hand

Joined: Apr 24, 2007
Posts: 179
Hi
I want to know when to use Oracle XA Datasource in the web application over Oracle Datasource?
regards
sudha
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30516
    
150

Sudha,
XA is for two phase commit. If you are using two different databases, you need to use an XA Datasource.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
sudha swami
Ranch Hand

Joined: Apr 24, 2007
Posts: 179
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

Joined: Aug 15, 2002
Posts: 126
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


Sun Certified Enterprise Architect
Java Technology Blog
sudha swami
Ranch Hand

Joined: Apr 24, 2007
Posts: 179
Thanks for the info
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle XA Datasource