If you have a large number of values then including them in an IN clause is not a good solution - the JDBC driver doesn't have to support more than a hundred values and batch jobs typically exceed this. A better solution is to put the list of values in a table (value_list) and use that in your query -
The use case is to select entities using criteria that is based upon a configurable list of values.
basically where column equals an item in the configured list.
This way there is no limitation for the number of values and no need to use a variable parameter list for your SQL.
select * from my_table
where id in (select id from value_list)