Re: Fix resultset results after updateBinaryStream - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Fix resultset results after updateBinaryStream
Date
Msg-id Pine.BSO.4.64.0707211135400.27979@leary.csoft.net
Whole thread Raw
In response to Fix resultset results after updateBinaryStream  (Mikko Tiihonen <mikko.tiihonen@iki.fi>)
Responses Re: Fix resultset results after updateBinaryStream  (Mikko Tiihonen <mikko.tiihonen@iki.fi>)
List pgsql-jdbc

On Sat, 21 Jul 2007, Mikko Tiihonen wrote:

> The current UpdateableResultSet tests did not properly test more complex
> binary data updating. The following patch makes the test a bit harder
> and fixes the driver to pass the test.

I think this works for the single row update and then retrieve test, but
if your ResultSet has two rows and you do update, next, and then getBytes,
won't it have the wrong fields[i].getFormat() value?  The problem is that
we need to keep the format on a per row basis.  Consider a scrollable
updatable resultset, any row can have either text or binary format.  The
safest thing to do at the moment would be to encode the byte[] into the
text format that the server returns, but this is clearly not an ideal
solution.

Kris Jurka

PS (Great to see you back in action!)

pgsql-jdbc by date:

Previous
From: Mikko Tiihonen
Date:
Subject: Clean up wasNullFlag usage
Next
From: Mikko Tiihonen
Date:
Subject: Re: Fix resultset results after updateBinaryStream