Re: Query parameters limit in postgres jdbc driver? - Mailing list pgsql-jdbc

Tom Lane writes:
> olafos <olafoos@wp.pl> 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