Re: arrays as parameters in callableStatements

On Sun, 14 May 2006, J. wrote:

> I've got a PL/pgSQL stored function in my database and I'm trying to
> figure out how to call it from my admin script.  Some of the parameters
> are ArrayList objects of strings and it returns an array that I want to
> read to determine what the function actually did.  Here is the function
> header(?):
>
>              String[] results = stmt.getArray(1);
>
>  I'm getting a compiler error "Incompatible Types" on the second to last
> line.

getArray returns a java.sql.Array, not a String[].  Also the JDBC driver
does not know how to interpret array parameters that are not sent in via
setArray or setObject with a java.sql.Array.

Kris Jurka