Re: Possible bug / regression from generated keys

From: Kris Jurka <books(at)ejurka(dot)com>
To: Peter Cooner <petriborg(at)gmail(dot)com>
Cc: dmp <danap(at)ttc-cmc(dot)net>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Possible bug / regression from generated keys
Date: 2012-11-08 18:45:36
Message-ID: alpine.BSO.2.00.1211081338240.29600@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
BinBatchPS.java text/plain 951 bytes

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter Cooner 2012-11-08 19:47:17 Re: Possible bug / regression from generated keys
Previous Message Peter Cooner 2012-11-08 18:05:10 Re: Possible bug / regression from generated keys