Re: PostgreSQL XAResource & GlassFish 3.1.2.2 - Mailing list pgsql-jdbc

From Kevin Grittner
Subject Re: PostgreSQL XAResource & GlassFish 3.1.2.2
Date
Msg-id 1360793146.49585.YahooMailNeo@web162902.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: PostgreSQL XAResource & GlassFish 3.1.2.2  (Bryan Varner <bvarner@polarislabs.com>)
List pgsql-jdbc
Bryan Varner <bvarner@polarislabs.com> wrote:

> Why would each XAConnection need it's own pool?

Because one PostgreSQL connection can't interleave transactions,
and you can't commit or roll back a prepared transaction in a
connection which has a transaction open.  I thought you wanted to
be able to do such things.  They could be done if one XAConnection
could map to more than one PostgreSQL connection.

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-jdbc by date:

Previous
From: Bryan Varner
Date:
Subject: Re: PostgreSQL XAResource & GlassFish 3.1.2.2
Next
From: Ladislav DANKO
Date:
Subject: Re: rounded brackets in prepared statement