5 Replies Latest reply on Jul 25, 2003 9:00 AM by mblei

    Oracle open cursors

    Carmen Bastiaans Newbie

      I have an application where the number of open cursors seems to increase over the day, and some times it does throw a "Too many open cursors" exception when it reaches the 300 limit. However, if it is left idle for 15 minutes the connections are closed.

      I have checked that my code closes all Statements, PreparedStatements, ResultSets and Connections so I am not sure why the cursors are left open.

      I am using JBoss 3.2.1 and finding it very difficult to find any documentation on how JBoss does Connection Pooling.

      Thankyou
      Carmen.