Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Query parameters limit in postgres jdbc driver?
- From: Olaf Tomczak <olafoos(at)wp(dot)pl>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: pgsql-jdbc(at)postgresql(dot)org
- Subject: Re: Query parameters limit in postgres jdbc driver?
- Date: Wed, 23 Apr 2008 21:28:57 +0200
- Message-id: <480F8DF9(dot)2000008(at)wp(dot)pl>
Tom Lane writes:
olafos <olafoos(at)wp(dot)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
- References:
- Query parameters limit in postgres jdbc driver?
- From: olafos
- Re: Query parameters limit in postgres jdbc driver?
- From: Tom Lane
- Query parameters limit in postgres jdbc driver?
- Prev by Date: Login Roles
- Next by Date: Taking a date from the command line
- Previous by thread: Re: Query parameters limit in postgres jdbc driver?
- Next by thread: Creating a sequence
- Indexes: