9 Replies Latest reply: Dec 3, 2012 4:00 PM by EJP RSS

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

    911511

      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.