From: dan@omegaconcepts.net   
      
   Deepali ,   
      
     I would select your results into a java object(i.e.hash table) in a   
   serverlet then close the cursor.   
      
      
   "Deepali Gupta"  wrote in message   
   news:c125a682.0309080012.58138bda@posting.google.com...   
   > We are encountering the problem of "maximum open cursors exceeded"   
   > exception.   
   >   
   > Our web based system uses jdk1.3 as frontend with Oracle 9i as backend   
   > and Oracle JDBC Driver version - 9.0.2.0.0 for connectivity.   
   >   
   > Connection pooling is being used and the resultset is fetched in the   
   > functions and returned to JSPs where the functions are being called.   
   >   
   > As per the articles on the net this exception occurs as a result of   
   > not closing the prepared statements/ statements/ resultSets.   
   >   
   > The problem is how do we close the statements as we are using the   
   > resultsets in the JSPs. We cannot close the prepared statements/   
   > statements/ resultSets in the JSPs as we cannot access them because   
   > they are local to the respective functions. Nor can we close them in   
   > the functions as we are retrieving the records from the resultsets in   
   > our JSPs.   
   >   
   > Kindly reply with a solution as soon as possible.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)