Re: Data Source

From: Aaron Mulder <ammulder(at)alumni(dot)princeton(dot)edu>
To: Pgsql-Jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Data Source
Date: 2003-03-06 15:53:22
Message-ID: Pine.LNX.4.44.0303061049160.28475-100000@www.princetongames.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 6 Mar 2003, Dave Cramer wrote:
> Chris,
>
> The XADataSource is not supported by the driver because postgres doesn't
> support two phase commits.

That said, it's not unusual to see a "fake" XADataSource
impleemntation that wraps a non-XA DataSource and works fine as long as

1) It's the only non-real XADataSource AND it's invoked last in the
prepare phase of the transaction

- or -

2) No resource ever fails to prepare

That's pretty chancy, but it beats nothing at all. You can
implement one of these yourself with some research into the JDBC2 optional
package, or take it from one of the open-source app servers or something.

Aaron

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Aaron Mulder 2003-03-06 15:55:21 Re: Postgres PooledConnection...
Previous Message Aaron Mulder 2003-03-06 15:49:07 Re: Closing one connection closes all connections?