two dimensional arrays supported? - Mailing list pgsql-jdbc

From Guido Fiala
Subject two dimensional arrays supported?
Date
Msg-id 200403101348.06320.guido.fiala@dka-gmbh.de
Whole thread Raw
Responses Re: two dimensional arrays supported?  (Oliver Jowett <oliver@opencloud.com>)
Re: two dimensional arrays supported?  (Richard Bottoms <rbottoms@computerplanet.com>)
List pgsql-jdbc
Hallo,

i just tested to access a 2-dimensional array of varchar via jdbc and the
driver gives the exception "not implemented" - did i something wrong, or is
it not yet supported?

Any alternative available?

My table is defined as following:

CREATE TABLE tst_2dimarray
(
   twodim varchar[][]  NULL,
   onedim varchar[]  NULL
);

my code snippet:

Array a=rs.getArray("twodim");
String aa[][]=(String[][])a.getArray();//this line throws exception below

org.postgresql.util.PSQLException: Diese Methode ist noch nicht implementiert.
    at org.postgresql.Driver.notImplemented(Driver.java:413)
    at org.postgresql.jdbc2.Array.getArray(Array.java:106)
    at org.postgresql.jdbc2.Array.getArray(Array.java:63)
    at twodimarray.main(twodimarray.java:38)

localized message means "not yet implemented"...
Above code works fine with "onedim".

Guido

pgsql-jdbc by date:

Previous
From: "Kubilay Osman Erdem"
Date:
Subject:
Next
From: Bjørn T Johansen
Date:
Subject: Backup of users and groups?