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
>> 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.
In response to
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2005-07-23 07:15:50|
|Subject: Re: prepareStatement()|
|Previous:||From: Oliver Jowett||Date: 2005-07-23 07:09:06|
|Subject: Re: jdbc xa support|