Hello again. I have been away for a while.
Column "stringarray" is VARCHAR[]
Column "integerarray" is INTEGER[]
System.out.println("getObject: " + rs.getObject
("integerarray").getClass());
System.out.println("getObject: " + rs.getObject
("stringarray").getClass());
System.out.println("getArray: " + rs.getArray("integerarray").getClass
());
System.out.println("getArray: " + rs.getArray("stringarray").getClass
());
Regular driver:
getObject: class org.postgresql.jdbc3.Jdbc3Array
getObject: class org.postgresql.jdbc3.Jdbc3Array
getArray: class org.postgresql.jdbc3.Jdbc3Array
getArray: class org.postgresql.jdbc3.Jdbc3Array
PL/Java
getObject: class [Ljava.lang.Integer;
getObject: class [Ljava.lang.String;
ERROR: java.sql.SQLException: Cannot derive a value of class
java.sql.Array from an object of class [Ljava.lang.Integer;
ERROR: java.sql.SQLException: Cannot derive a value of class
java.sql.Array from an object of class [Ljava.lang.String;
Thanks!
On Oct 13, 2006, at 11:29 AM, Markus Schaber wrote:
> Hi, Bendik,
>
> Bendik Rognlien Johansen wrote:
>
>> In PL/Java:
>> String[] values = (String[]) rs.getObject(column);
>
> What does getArray() return here?
>
>> Regular driver:
>> String[] values = (String[]) rs.getArray(column).getArray();
>
> And what does getObject return here?
>
> Thanks,
> 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