Retrieving arrays - Mailing list pgsql-jdbc

From Bendik Rognlien Johansen
Subject Retrieving arrays
Date
Msg-id 533747B3-BC3C-4D07-A2B8-A3C86B85C718@gmail.com
Whole thread Raw
Responses Re: Retrieving arrays  (Mark Lewis <mark.lewis@mir3.com>)
Re: Retrieving arrays  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: "Per Jensen"
Date:
Subject: Re: Test of 8.2beta1 fails
Next
From: Heikki Linnakangas
Date:
Subject: Re: Postgres XA support