Re: Max size for bytea type - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Max size for bytea type
Date
Msg-id Pine.BSO.4.64.0702181834270.21234@leary.csoft.net
Whole thread Raw
In response to Re: Max size for bytea type  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

On Thu, 1 Feb 2007, Kris Jurka wrote:

> On Mon, 22 Jan 2007, Do, Leon (Leon) wrote:
>
>> Sorry, it is my mistake.   It is wrong data type.
>>
>
> Still there is a TODO item here.  The driver shouldn't bail out with an
> ArrayIndexOutOfBoundsException.  It might be best to fail immediately for a
> getBytes call on something that isn't bytea data.  It's conceivable that you
> there is bytea escaped data in a text field, but really, what are the odds
> (and use cases) of that?
>

Checking the code behind this, I see:

AbstractJdbc2ResultSet.java:2150

     if (fields[columnIndex - 1].getOID() == Oid.BYTEA)
     {
         return trimBytes(columnIndex,PGbytea.toBytes(this_row[columnIndex - 1]));
     }
     else
     {
         return trimBytes(columnIndex, this_row[columnIndex - 1]);
     }

So the check I suggested already exists and I don't understand how you got
this error.  Do you still have your test case handy?

Kris Jurka

pgsql-jdbc by date:

Previous
From: "Mark De Souza"
Date:
Subject: ResultSetMetaData performance
Next
From: Kris Jurka
Date:
Subject: Re: Memory leaks using refcursors