Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group