Oracle XA Datasource

sudha swami

Ranch Hand

Posts: 186

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 42056

926

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

sudha swami

Ranch Hand

Posts: 186

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 186

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks for the info

The glass is neither half full or half empty. It is too big. But this tiny ad is just right:

Smokeless wood heat with a rocket mass heater

https://woodheat.net