Tom Lane writes:
> olafos <olafoos@[EMAIL PROTECTED]
> 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
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
|
