Skip site navigation (1) Skip section navigation (2)

Re: Retrieving arrays

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Bendik Rognlien Johansen <bensmailinglists(at)gmail(dot)com>
Cc: Markus Schaber <schabi(at)logix-tt(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Retrieving arrays
Date: 2006-10-13 10:35:29
Message-ID: C3149482-53FB-42C2-A810-B82531276225@fastcrypt.com (view raw or flat)
Thread:
Lists: 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
>


In response to

pgsql-jdbc by date

Next:From: Markus SchaberDate: 2006-10-13 11:52:57
Subject: Re: "Hanging Connection" blocks access to table (JBossMQ)
Previous:From: Markus SchaberDate: 2006-10-13 09:29:14
Subject: Re: Retrieving arrays

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group