java - Spring named "IN" query producing error when given more than one entry -

i'm using spring's named queries access data , came upon issue. have rather long named query in spring data repo:

list<landscapelocationentity> findbyidcustomeridandidproductgroupandidproductidandidlocationidinandactiveflag(string customerid, string productgroup, string productid, list<integer> locationid, boolean activeflag); 

the query works fine long provide list<integer> 1 entry. there entry throw java.sql.sqlexception: borrow preparestatement pool failed.

as can see in screenshot, call different actual query (locationid(?,?) vs. locationid(?)). have workaround executes queries separately that's not way want have in long term.

if need further information please tell me.

update: prove point removed other attributes , still same error:

query now: list<landscapelocationentity> findbyidlocationidin(list<integer> locations);