ORA-01795: maximum number of expressions in a list is 1000

XMLWordPrintable

      2013-10-04 01:11:57,400 WARN  [scheduler_Worker-6]  o.h.internal.AbstractQueryImpl HHH000443: Dialect [org.hibernate.dialect.Oracle10gDialect] limits the number of elements in an IN predicate to 1000 entries.  However, the given parameter list [usernames] contained 2000 entries, which will likely cause failures to execute the query in the database
      2013-10-04 01:11:57,408 WARN  [scheduler_Worker-6]  o.h.e.jdbc.spi.SqlExceptionHelper SQL Error: 1795, SQLState: 42000
      2013-10-04 01:11:57,409 ERROR [scheduler_Worker-6]  o.h.e.jdbc.spi.SqlExceptionHelper ORA-01795: maximum number of expressions in a list is 1000
      

              Assignee:
              CharlesA
              Reporter:
              Daniel R
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: