java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Atlassian JIRA by Der Lun Ooi, 1 year ago
ORA-01795: maximum number of expressions in a list is 1000
via Stack Overflow by maximegir
, 2 years ago
ORA-02289: la séquence n'existe pas (non existing sequence)
via Oracle Community by carflores, 1 year ago
ORA-00942: table or view does not exist
via Stack Overflow by Alex
, 2 months ago
ORA-00933: SQL command not properly ended
via Stack Overflow by GuruJi
, 2 years ago
ORA-00942: table or view does not exist
via GitHub by TimMoore
, 1 year ago
ORA-00922: missing or invalid option
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)	at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)	at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)	at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)	at net.sf.hibernate.loader.Loader.list(Loader.java:1048)	at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1570)	at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)	at com.atlassian.hibernate.HibernateObjectDao.lambda$findNamedQueryStringParams$5(HibernateObjectDao.java:432)	at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)