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

From Tom Lane
Subject Re: Query parameters limit in postgres jdbc driver?
Date
Msg-id 10218.1208960238@sss.pgh.pa.us
Whole thread Raw
In response to Query parameters limit in postgres jdbc driver?  (olafos <olafoos@wp.pl>)
Responses Re: Query parameters limit in postgres jdbc driver?  (Olaf Tomczak <olafoos@wp.pl>)
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Creating a sequence
Next
From: Craig Ringer
Date:
Subject: Re: Creating a sequence