Re: passing user defined data types to stored procedures

From: Kris Jurka <books(at)ejurka(dot)com>
To: Jay Howard <jhoward(at)alumni(dot)utexas(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: passing user defined data types to stored procedures
Date: 2008-11-15 18:02:21
Message-ID: Pine.BSO.4.64.0811151300420.10693@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jay Howard 2008-11-15 18:20:41 Re: passing user defined data types to stored procedures
Previous Message Kris Jurka 2008-11-15 17:51:51 Generated keys support