Subject Too many parameters in a prepared statement
Author mapofe
I have a query with an 'in' clause that takes about 1500 parameters,
and I get the following error:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544343. invalid
request BLR at offset 10403
Implementation limit exceeded
block size exceeds implementation restriction

I suppose there is no other work around than performing the query more
times splitting the 'in' parameters in smaller groups and rebuilding
the result manually, right?

Is it a limitation of the 'in' clause or of the 'whole query' (I mean,
is there a maximum number of parameters I can bind to a query?).

Thank you