Hi Ravi, jOOQ is aware of these limits and splits such conditions to appropriate OR-connected IN conditions, e.g.
ID in (1, 2, 3, ... , 1000) or ID in (1001, 1002, 1003, ..., 2000) or ID in (2001, 2002) This applies for Ingres, Oracle, SQL Server. Beware, there is also a maximum number of bind variables, which is different from dialect to dialect. If you plan to create huge IN predicates, you better inline your bind variables using the StatementType.STATIC_STATEMENT property Cheers Lukas 2012/4/12 Ravindra Wankar <[email protected]>: > Oracle has a limit for how many items one can include in an "IN" clause > (1000 I think). If I call the IN with a collection, will JOOQ automatically > handle this by splitting the query into mulitple SQL requests and then merge > the data back? > > Thanks, > - Ravi
