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

two dimensional arrays supported?

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 (view raw or flat)
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

Responses

pgsql-jdbc by date

Next:From: Bjørn T JohansenDate: 2004-03-10 12:59:14
Subject: Backup of users and groups?
Previous:From: Kubilay Osman ErdemDate: 2004-03-10 11:21:53
Subject:

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