Re: passing user defined data types to stored procedures - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: passing user defined data types to stored procedures
Date
Msg-id Pine.BSO.4.64.0811151300420.10693@leary.csoft.net
Whole thread Raw
In response to Re: passing user defined data types to stored procedures  ("Jay Howard" <jhoward@alumni.utexas.net>)
Responses Re: passing user defined data types to stored procedures  ("Jay Howard" <jhoward@alumni.utexas.net>)
List pgsql-jdbc

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


pgsql-jdbc by date:

Previous
From: "Jay Howard"
Date:
Subject: Re: passing user defined data types to stored procedures
Next
From: "Jay Howard"
Date:
Subject: Re: passing user defined data types to stored procedures