Обсуждение: Two dimensional arrays in 7.2 JDBC driver

Поиск
Список
Период
Сортировка

Two dimensional arrays in 7.2 JDBC driver

От
"Van Auken, Douglas"
Дата:
Just tried out the Array functionality in the 7.2 JDBC driver.  It seams
like 1 dimensional arrays work, but not two dimmensional arrays.  I get
"This method is not yet implemented" returned to me in an exception block.

Are there any plans to implement two-dimensional arrays?

Thanks.

Doug Van Auken


Re: Two dimensional arrays in 7.2 JDBC driver

От
"Dave Cramer"
Дата:
Douglas,

Can you do me a favour and send me a short program which reproduces this
problem

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Van Auken, Douglas
Sent: Thursday, November 29, 2001 7:16 PM
To: 'pgsql-jdbc@postgresql.org'
Subject: [JDBC] Two dimensional arrays in 7.2 JDBC driver


Just tried out the Array functionality in the 7.2 JDBC driver.  It seams
like 1 dimensional arrays work, but not two dimmensional arrays.  I get
"This method is not yet implemented" returned to me in an exception
block.

Are there any plans to implement two-dimensional arrays?

Thanks.

Doug Van Auken


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Re: Two dimensional arrays in 7.2 JDBC driver

От
"Dave Cramer"
Дата:
Douglas,

I have read the code and now understand what is going on. The driver
currently only supports single dimension arrays of known types (ie SQL
types). When the driver stores it, it just does a toString on the array
and stores the resulting string. This part probably works ok. The
challenge is in retrieving it. It sees the object as an array of objects
(Arrays).

Can you help me understand how you are using this? Generally an array of
arrays would constitute another table?

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Van Auken, Douglas
Sent: Thursday, November 29, 2001 7:16 PM
To: 'pgsql-jdbc@postgresql.org'
Subject: [JDBC] Two dimensional arrays in 7.2 JDBC driver


Just tried out the Array functionality in the 7.2 JDBC driver.  It seams
like 1 dimensional arrays work, but not two dimmensional arrays.  I get
"This method is not yet implemented" returned to me in an exception
block.

Are there any plans to implement two-dimensional arrays?

Thanks.

Doug Van Auken


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster