Path: news.f.de.plusline.net!news-fra1.dfn.de!news-stu1.dfn.de!news.germany.com!postnews.google.com!i39g2000hsf.googlegroups.com!not-for-mail
From: "Valentin Minzatu" <valentinminzatu@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Difference between OracleDataSource and OracleXADataSource
Date: 10 Jan 2007 07:03:11 -0800
Organization: http://groups.google.com
Lines: 19
Message-ID: <1168441391.026342.49440@i39g2000hsf.googlegroups.com>
References: <1168263809.414147.67710@51g2000cwl.googlegroups.com>
   <1168267839.750291.133860@s34g2000cwa.googlegroups.com>
   <1168346615.691363.248620@v33g2000cwv.googlegroups.com>
NNTP-Posting-Host: 205.189.93.240
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1168441392 28272 127.0.0.1 (10 Jan 2007 15:03:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 10 Jan 2007 15:03:12 +0000 (UTC)
In-Reply-To: <1168346615.691363.248620@v33g2000cwv.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: i39g2000hsf.googlegroups.com; posting-host=205.189.93.240;
   posting-account=fFMh9AwAAADc9-o_9lpjYaP-XzKecp04
Xref: news.f.de.plusline.net comp.databases.oracle.server:192100


brian wrote:
> Valentin Minzatu wrote:
> > As far as I know - I hope this is right, if not somebody please correct
> > me - for distributed transactions between the middle tier and the
> > database (i.e. MDB or such) you'd need XA driver.
>
> With this you imply that the standard datasource would not provide the
> ACID attributes in the context of MDB. I assume the OracleDataSource to
> have a better performance but is this the only justification to use it?
> Other than in this point I wouldn't see any advantage in
> OracleDataSource over the XA version and thus always use the latter.

Yes, my understanding is that using XA is the only way for ensuring
transaction integrity once it runs across middle tier and database.
I am not aware of any performance improvement or decrease by using XA.
I usually try to stay away of using distributed transactions between
database and application.