Re: Query parameters limit in postgres jdbc driver?

Tom Lane writes:
> olafos  writes:
>   
>> Seems like the driver is trying to send the number 40,000 (which is actually
>> the number of query parameters) as a 2-byte integer. Is there any limit to
>> the number of jdbc query parameters in postgresql?
>>     
>
> Yeah, 2^16, as you already noticed.
>
> 40000 parameters is far beyond the bounds of sanity anyway.  Try sending
> them as a single array parameter, ie "foo = any (?::int[])"
>
> 			regards, tom lane
>
>
>   

Yeah, well that would be much more sensible I guess, although it won't 
be easy to convince Toplink to do so;). Anyway, thanks a lot for 
clearing this up for me.

regards, Olaf Tomczak