Fix setArray() when using the v3 protocol (was Re: Postgres 8.0 + JDBC)

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Fix setArray() when using the v3 protocol (was Re: Postgres 8.0 + JDBC)
Date: 2004-10-08 02:13:06
Message-ID: 4165F7B2.70705@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Oliver Jowett wrote:
> Oliver Jowett wrote:
>
>> It seems possible to fix the driver to handle this case by making
>> setArray() derive a proper array type name i.e. ("_" +
>> Array.getBaseType()), and using that rather than 'text' as the
>> parameter type.
>
>
> I've done this (plus tests) and it seems to work OK. I can't generate a
> patch right now as gborg seems to be having some problems (I get 70%
> packet loss on the last hop, which pretty much hoses CVS access)

Here is the patch.

I made it fail if the array type can't be found, rather than risking the
backend interpreting the value in an unpredictable way.

-O

Attachment Content-Type Size
pgjdbc-setarray-v3-fixes.txt text/plain 8.9 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-08 02:35:10 Re: Index problem.... GIST (tsearch2)
Previous Message Samik Raychaudhuri 2004-10-08 02:12:31 CGI program cannot access database

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2004-10-08 03:04:41 Re: Fix setArray() when using the v3 protocol (was Re: Postgres 8.0 + JDBC)
Previous Message Kris Jurka 2004-10-08 01:02:56 Re: Using gettext (was Translation updates: errors_ru.properties)