Re: Two dimensional arrays in 7.2 JDBC driver

From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
To: "'Van Auken, Douglas'" <DVanAuken(at)coral-energy(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Two dimensional arrays in 7.2 JDBC driver
Date: 2001-12-03 19:52:46
Message-ID: 00a101c17c34$1497a270$8201a8c0@inspiron
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Van Auken, Douglas
Sent: Thursday, November 29, 2001 7:16 PM
To: 'pgsql-jdbc(at)postgresql(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2001-12-03 20:40:05 Re: java stored procedures
Previous Message Dave Cramer 2001-12-03 19:10:57 Re: Exception?