Re: Difference between thin & thin XA drivers?

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Fri, 11 Feb 2005 11:00:15 -0800
Message-ID: <420D00BF.5000503@bea.com>

harry wrote:

> Using Oracle 9
>
> Can anyone please explain (at thicky level!) the difference between these 2
> drivers - I can't find anything anywhere!
>
> I have to setup an Oracle 9 connection pool on a weblogic 8.1(sp3) web
> server. The only 9.x driver it give's me is a thin one but for other
> versions there are XA options also!
>
> cheers
>
> harry

It is the same driver, but in the non-XA case a java.sql.Driver is used to obtain connections, which never get knowingly involved in XA transactions. The XA-specified is tapped via it's implementation of DataSource for XA-aware connections, and this resource is enlisted in any ongoing XA transaction. You can make a pool with either config.

Because drivers tend to evolve faster than WebLogic releases service packs, it is best to download Oracle's very latest version of the driver you want, and install it in weblogic's server\lib.
Joe Weinstein at BEA Received on Fri Feb 11 2005 - 13:00:15 CST