Skip site navigation (1) Skip section navigation (2)

Re: XA support

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: XA support
Date: 2005-06-30 18:15:54
Message-ID: Pine.OSF.4.61.0506302112310.45052@kosh.hut.fi (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Wed, 29 Jun 2005, Scott Marlowe wrote:

> On Wed, 2005-06-29 at 15:27, Dave Cramer wrote:
>> I see option A below as the lesser of three evils. Is it reasonable
>> to believe that people using XA would
>> know enough to allocate enough connections ?
>>
>> Optionally we could have two implementations and choose between A and B
>
> If they've used it before with jdbc, yes.  It's the way Oracle does it
> too.  Under Jboss you have a two to one ration of backend to frontend
> connections. I.e. every application connection going through an XA
> connector requires TWO backend connections.

Do you mean that Oracle opens extra connections behind the scenes? That's 
not what I saw happening. I ran ethereal while running the test case, and 
it showed just one TCP connection and all SQL statements flowing through 
that.

I'm no Oracle expert though. Maybe it opens multiple virtual connections 
that are multiplexed into one TCP connection, I don't know.

That JBoss thing is quite interesting too. I wonder why they do that.

> IT might be worth putting a note in the jdbc docs though.

Definitely.

- Heikki

In response to

Responses

pgsql-jdbc by date

Next:From: Heikki LinnakangasDate: 2005-06-30 18:37:16
Subject: Re: XA support
Previous:From: sarvesDate: 2005-06-30 04:46:21
Subject: Re: using postgresql-8.0-311.jdbc2.jar

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group