Обсуждение: jdbc and ARRAYs

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

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.

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
>

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