Re: passing user defined data types to stored procedures

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.
>

getArray is implemented and should work.  Perhaps you're getting confused
because you're expecting to receive int[] and you're getting Integer[]
instead?  It's tough to say what's going wrong without some example code.

Kris Jurka