Re: Prepared Statement limit ? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Prepared Statement limit ?
Date
Msg-id 1035907986.1716.65.camel@inspiron.cramers
Whole thread Raw
In response to Prepared Statement limit ?  (ygloriau@siliage.fr)
Responses Re: Prepared Statement limit ?
List pgsql-jdbc
Yann

Which version of the driver are you using.

Looking at the latest code, the statement is parsed and the number of
parameters are set based on the number of ? marks in the statement. Are
you sure it is the number of parameters or actually the 51 st parameter
that is causing the problem.

Dave
On Tue, 2002-10-29 at 10:35, ygloriau@siliage.fr wrote:
>
>
> Hi all,
> I'm dealing with the hugest query i've ever seen : 93 parameters !
>
> The problem is that i got an exception when i try to add the 51th parameter.
> No way to have mor ethan 50 parameters.
> Is there a solution to fix up this problem ?
> (I won't rewrite the query !)
>
> thanks
>
> Yann
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>




pgsql-jdbc by date:

Previous
From: Barry Lind
Date:
Subject: Re: DatabaseMetaData.getTables() problem
Next
From: Barry Lind
Date:
Subject: Re: notification support