Re: Possible bug / regression from generated keys - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Possible bug / regression from generated keys
Date
Msg-id alpine.BSO.2.00.1211081338240.29600@leary.csoft.net
Whole thread Raw
In response to Re: Possible bug / regression from generated keys  (Peter Cooner <petriborg@gmail.com>)
Responses Re: Possible bug / regression from generated keys  (Peter Cooner <petriborg@gmail.com>)
JDBC Source Builds  (dmp <danap@ttc-cmc.net>)
List pgsql-jdbc

On Thu, 8 Nov 2012, Peter Cooner wrote:

> I tried to write a test case for a few days before I mailed the list
> and was unable to produce the problem :(

Based on this description, I created a self contained test which is
attached.

The problem is that the driver is splicing together a single
generated keys ResultSet from each individual batch execution, but
some results come back in text format and some come back in binary.
 The combined result has a single per column format flag and it gets
confused when trying to parse a text result that it thinks is in binary
format.

The driver needs to be taught not to change the requested format mid batch
execution, but this is a tricky area.

Kris Jurka

Attachment

pgsql-jdbc by date:

Previous
From: Peter Cooner
Date:
Subject: Re: Possible bug / regression from generated keys
Next
From: Peter Cooner
Date:
Subject: Re: Possible bug / regression from generated keys