Turns out I was returning an array of composites after all. Everything works as expected when the array elements are simple types.
That begs the question, though- is supporting arrays of composite types on the list of "things to do"?
Here's what I get when I call java.sql.Array.getArray() and the array contains composites:
Method org.postgresql.jdbc4.Jdbc4Array.getArrayImpl(long,int,Map) is not yet implemented.
On Sat, Nov 15, 2008 at 12:20 PM, Jay Howard
<jhoward@alumni.utexas.net> wrote:
Actually it may not have been an array of integers. I was doing stuff with composite types, so that may be the problem. The message I got from getArray() indicated that the "full" version of that method, which it must call internally, wasn't implemented. I'll verify tonight and respond with some sample code.On Sat, Nov 15, 2008 at 12:02 PM, Kris Jurka
<books@ejurka.com> wrote:
On Sat, 15 Nov 2008, Jay Howard wrote:
Is it possible to return (and pass) arrays using java.sql.Array?
I wrote a test proc that returns an array of integers. I can retrieve it on
the java side as a Jdbc3Array, which implements java.sql.Array.
Unfortunately, getArray() (and its variants) seem not to have been
implemented yet by Jdbc3Array.
Kris Jurka