Re: ANY subquery and PreparedStatements

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: awc <awc(at)drytel(dot)net>
Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: ANY subquery and PreparedStatements
Date: 2003-02-20 14:40:13
Message-ID: 1045752014.2976.25.camel@desenv1.ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I don't think I can understand what you mean... You pass the values to
what method/constructor?
Anyway, I know the parameter types (Integer), but I have no idea of
the maximum number of parameters... that's my biggest problem.

On Thu, 2003-02-20 at 11:15, awc wrote:
>
> Hi Felipe,
>
> Do you know the number of parameters and types, just before you set the query?
> I do kind of same thing with xml files, digester. I pass name, value array to
> the method to
> construct the prepared statement.
>
> .anil
>
>
> Felipe Schnack wrote:
>
> > yes... I understood your idea... my problem is that I don't know the
> > maximum number of parameters I'll have
> >
> > On Wed, 2003-02-19 at 13:54, Csaba Nagy wrote:
> > > Hi Felipe,
> > >
> > > What we are doing in our code is to prepare a statement with a lot of
> > > parameter placeholders, something like:
> > >
> > > select * from <table> where <field> in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
> > >
> > > and then set some of the parameters with the available values, and set
> > > the rest to nulls. The nulls should be disregarded by the backend
> > > anyway... this works well with Oracle, I'm not sure how efficient is
> > > with Postgres.
> > > The only reason to use this is to have a prepared statement instead of
> > > building dynamic queries all the time. You only must make sure the nr.
> > > of ? signs is at least as much as many parameters you can have at
> > > maximum.
> > >
> > > HTH,
> > > Csaba.
> > >
> > > On Wed, 2003-02-19 at 13:24, Felipe Schnack wrote:
> > > > I'm afraid it kind of impossible to use PreparedStatements with the
> > > > "ANY" subquery keyword... For example, if I take this query and prepare
> > > > it:
> > > > "select * from <table> where <field> any (?)"
> > > > How can I set my parameter as a list of values, so my query searches
> > > > for for different values of the specified field?
> > > >
> > > > --
> > > >
> > > > Felipe Schnack
> > > > Analista de Sistemas
> > > > felipes(at)ritterdosreis(dot)br
> > > > Cel.: (51)91287530
> > > > Linux Counter #281893
> > > >
> > > > Centro Universitário Ritter dos Reis
> > > > http://www.ritterdosreis.br
> > > > ritter(at)ritterdosreis(dot)br
> > > > Fone/Fax.: (51)32303341
> > > >
> > > >
> > > > ---------------------------(end of broadcast)---------------------------
> > > > TIP 6: Have you searched our list archives?
> > > >
> > > > http://archives.postgresql.org
> > > >
> > >
> > >
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> > --
> >
> > Felipe Schnack
> > Analista de Sistemas
> > felipes(at)ritterdosreis(dot)br
> > Cel.: (51)91287530
> > Linux Counter #281893
> >
> > Centro Universitário Ritter dos Reis
> > http://www.ritterdosreis.br
> > ritter(at)ritterdosreis(dot)br
> > Fone/Fax.: (51)32303341
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
--

Felipe Schnack
Analista de Sistemas
felipes(at)ritterdosreis(dot)br
Cel.: (51)91287530
Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter(at)ritterdosreis(dot)br
Fone/Fax.: (51)32303341

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Robert Echlin 2003-02-20 14:43:42 Re: 7.3.2 psql error!
Previous Message first last 2003-02-20 14:33:38 Re: Problems with getLastOID