Re: Retrieving arrays - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Retrieving arrays
Date
Msg-id C3149482-53FB-42C2-A810-B82531276225@fastcrypt.com
Whole thread Raw
In response to Re: Retrieving arrays  (Bendik Rognlien Johansen <bensmailinglists@gmail.com>)
List pgsql-jdbc
Patches are welcome

I haven't looked at the spec, but I also think this is outside of the
spec, but we have discussed it and feel it is intuitive enough to
accept.

Dave
On 13-Oct-06, at 4:58 AM, Bendik Rognlien Johansen wrote:

> Hello,
>
> In PL/Java:
> String[] values = (String[]) rs.getObject(column);
>
> Regular driver:
> String[] values = (String[]) rs.getArray(column).getArray();
>
> Strange..
>
> On Oct 11, 2006, at 3:43 PM, Markus Schaber wrote:
>
>> Hi, Bendik,
>>
>> Bendik Rognlien Johansen wrote:
>>
>>> yes you are right, I don't really understand Generics that well.
>>> But it
>>> is a little clearer now :-)
>>>
>>> Anyway, I was hoping there would be a clean way to get arrays
>>> from the
>>> result set, Generics or not, using a single method. I would like
>>> to avoid:
>>> getStringArray, getIntegerArray etc.
>>
>> Usually, ResultSet.getArray() should do it.
>>
>>> The reason I need to do this is that I use two different drivers for
>>> PostgreSQL with the same code, and they handle arrays differently.
>>
>> So you say that the the other one (pljava, IIRC) maps a postgresql
>> integer[] to an java.lang.Integer[] in java, and not an int[] like
>> pgjdbc?
>>
>> Looks strange.
>>
>> Does the jdbc spec promote one or the other behaviour?
>>
>> However, I don't know a clean solution.
>>
>> Markus
>> --
>> Markus Schaber | Logical Tracking&Tracing International AG
>> Dipl. Inf.     | Software Development GIS
>>
>> Fight against software patents in Europe! www.ffii.org
>> www.nosoftwarepatents.org
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Retrieving arrays
Next
From: Markus Schaber
Date:
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)