This discussion is archived
9 Replies Latest reply: Dec 3, 2012 2:00 PM by EJP RSS

java.sql.SQLException: ORA-01795: maximum number of expressions.

911511 Newbie
Currently Being Moderated
Hi,

i am trying to get some data from DB (Oracle -9) and displaying it in jsp. I am getting the below error.
" java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

at oracle.jdbc.driver.DatabaseError.throwSqlException(Ljava/lang/String;Ljava/lang/String;I)V(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(Z)V(Optimized Method)
at oracle.jdbc.driver.T4CTTIoer.processError()V(Optimized Method)
at oracle.jdbc.driver.T4C8Oall.receive()V(Optimized Method)
at oracle.jdbc.driver.T4CStatement.execute_for_describe()V(Optimized Method)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe()V(Optimized Method)
at oracle.jdbc.driver.T4CStatement.execute_maybe_describe()V(Optimized Method)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout()V(Optimized Method)
at oracle.jdbc.driver.OracleStatement.executeQuery(Ljava/lang/String;)Ljava/sql/ResultSet;(Optimized Method)
at weblogic.jdbc.wrapper.Statement.executeQuery(Ljava/lang/String;)Ljava/sql/ResultSet;(Optimized Method)
at com.bci.globalcapa.dataqueries.changehistory.AbstractChangeHistoryService.getChangeHistoryIds(Ljava/lang/String;)Ljava/util/ArrayList;(AbstractChangeHistoryService.java:47)
at com.bci.globalcapa.dataqueries.changehistory.CFDemographicsHistoryDAO.getChangeHistoryIds(Ljava/lang/Long;)Ljava/util/ArrayList;(CFDemographicsHistoryDAO.java:43)
at com.bci.globalcapa.dataqueries.changehistory.ChangeHistoryDAO.getChangeHistoryIds(Ljava/lang/String;Ljava/lang/String;)Ljava/util/ArrayList;(ChangeHistoryDAO.java:77)
at pageflows.common.changeHistory.ChangeHistoryController.begin()Lcom/bea/wlw/netui/pageflow/Forward;(ChangeHistoryController.jpf:127)
at jrockit.reflect.NativeMethodInvoker.invoke0(Ljava/lang/Object;ILjava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;(Unknown Source)
        at jrockit.reflect.NativeMethodInvoker.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;(Optimized Method)
        at jrockit.reflect.VirtualNativeMethodInvoker.invoke(Ljava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;(Optimized Method)
        at java.lang.reflect.Method.invoke(Ljava/lang/Object;[Ljava/lang/Object;I)Ljava/lang/Object;(Optimized Method)
        at  "

Earlier it was working fine. But suddenly i am getting this error. Can someone gives some ideas on this ? Please let me know if you require anything else.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points