Re: jdbc and ARRAYs

O Dave Cramer έγραψε στις Dec 2, 2005 :

> You have to implement the java.sql.Array interface and pass that in.
> search the list, there's a few references to this question and some
> code.

I think the easiest way to do this
is to simply construct your array strings,
and then deal with them as Strings.

>
> Dave
> On 2-Dec-05, at 4:42 AM, NosyMan wrote:
>
> > Hi everyone,
> >
> > I have some problems trying to use a preparedStatement with an array
> > parameter. The problem is I don't know how to do it :-(
> >
> > CREATE OR REPLACE FUNCTION MyFunction( id INTEGER, anArray
> > VARCHAR[] )..........................
> >
> >
> > pstat = conn.prepareStatement("SELECT * FROM MyFunction(?,?)");
> > pstat.setInt(1, 30);
> > pstat.setArray(2, ??????????);
> >
> > Can you tell me how can I construct the array for parameter number 2?
> >
> > Thanks,
> > NosyMan
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 6: explain analyze is your friend
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>

--
-Achilleus