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

Re: jdbc xa support

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Michael Allman <msa(at)allman(dot)ms>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: jdbc xa support
Date: 2005-07-23 07:13:03
Message-ID: 42E1EDFF.7060206@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Heikki Linnakangas wrote:
> On Thu, 21 Jul 2005, Michael Allman wrote:
> 
>> On Thu, 21 Jul 2005, Heikki Linnakangas wrote:
>>
>>> 2. Using prepared statements like "PREPARE TRANSACTION ?" won't work.
>>> You can only use prepared statements for normal SELECT/UPDATE/DELETE
>>> commands.
>>
>> Doesn't the driver support client side prepared statements?
> 
> No, they're server side. I tried that too at first, but it didn't work.

Yeah, it boils down to: you can only put a ? placeholder where there's a
PARAM terminal in the server's SQL grammar, as the driver translates the
placeholders to '$n' strings on Parse and uses Bind to pass the actual
values on each execution. COMMIT PREPARED etc take a Sconst, not a
PARAM, for their argument.

-O

In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-07-23 07:15:50
Subject: Re: prepareStatement()
Previous:From: Oliver JowettDate: 2005-07-23 07:09:06
Subject: Re: jdbc xa support

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