PROBLEM: maximum open cursors exceeded, HELP, please!

[Vitaly Yermolenko]

Hi!     Has anyone known what I must to do in case:   java.sql.SQLException: ORA-01000: maximum open cursors exceeded       In my servlets for access to Oracle database I use the next constructions, like:           try         {             stmtStmt = connConn.createStatement ();             rsResult = stmtStmt.executeQuery (strQuery);             while (rsResult.next ())             {             .    .    .             }         }         catch (SQLException e1)         {             try             {                 if (rsResult != null)                     rsResult.close ();                 if (stmtStmt != null)                     stmtStmt.close ();             }             catch (SQLException e2) { }         }         finally         {           rsResult = null;           stmtStmt = null;         }     but after some time I have this SQL Exception...       I use Kaffe VM  1.0b4 + Apache/1.3.4 + JServ 1.0b1 + Oracle JDBC Thin Driver 7.3.4 (classes111.zip) on the RH Linux 5.0 for connection to the Oracle7 Server (7.3.2.1.0).     If you can give me some help regarding this problem it will be nice...     Thanks!     Regards,     Vitaly Yermolenko     [EMAIL PROTECTED]