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

Re: Retrieving arrays

From: Bendik Rognlien Johansen <bensmailinglists(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Retrieving arrays
Date: 2006-10-11 11:54:10
Message-ID: FE77BF07-00B0-4F11-82C4-243C5299FC8B@gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Ok, thanks! So, that probably means I can not do this sort of thing  
with Generics?

Is there any way the driver could get the same behavior as the driver  
used in PL/Java? In PL/Java i can do:
return (String[]) rs.getObject(column);

On Oct 10, 2006, at 7:59 PM, Mark Lewis wrote:

> Java 5 doesn't support auto-boxing an int[] as an Integer[].
>
> -- Mark Lewis
>
> On Tue, 2006-10-10 at 15:15 +0200, Bendik Rognlien Johansen wrote:
>> Hello,
>> I wrote this method to read arrays from my result set.
>>
>>
>> public class MyClass {
>>    public <T> T[] getArray(ResultSet rs, String column) throws
>> Exception {
>>      if(rs.getArray(column) != null) {
>>        return (T[]) rs.getArray(column).getArray();
>>      }
>>      return null;
>>    }
>> }
>>
>>
>>
>> I call i like this:
>>
>> String[] values = MyClass.<String>getArray(rs,  
>> "myStringArrayColumn"));
>>
>>   This works fine. ( "myStringArrayColumn" is of type character
>> varying(64)[])
>>
>>
>> But, when I call:
>>
>> Integer[] values = MyClass.<Integer>getArray(rs,
>> "myIntegerArrayColumn"));
>> ( "myIntegerArrayColumn" is of type integer[])
>>
>>
>> I get a:
>> java.lang.ClassCastException: [I
>>
>>
>> Any ideas?
>>
>> Thanks
>>
>> ---------------------------(end of  
>> broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>>                http://archives.postgresql.org
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq


In response to

pgsql-jdbc by date

Next:From: Markus SchaberDate: 2006-10-11 12:42:24
Subject: Re: Retrieving arrays
Previous:From: Mark LewisDate: 2006-10-10 17:59:38
Subject: Re: Retrieving arrays

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