Re: Prepared Statement limit ?

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: ygloriau(at)siliage(dot)fr
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Prepared Statement limit ?
Date: 2002-10-29 16:13:05
Message-ID: 1035907986.1716.65.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)siliage(dot)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
>
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message ygloriau 2002-10-29 16:23:03 Re: Prepared Statement limit ?
Previous Message ygloriau 2002-10-29 15:35:42 Prepared Statement limit ?