| From: | Guido Fiala <guido(dot)fiala(at)dka-gmbh(dot)de> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | two dimensional arrays supported? |
| Date: | 2004-03-10 12:48:06 |
| Message-ID: | 200403101348.06320.guido.fiala@dka-gmbh.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bjørn T Johansen | 2004-03-10 12:59:14 | Backup of users and groups? |
| Previous Message | Kubilay Osman Erdem | 2004-03-10 11:21:53 |