🚀 go-pugleaf

Hi

> I get the " ORA-01000: maximum open cursors exceeded" SQLException error. My
> program executes queries. I think I am not closing either my STATEMENTS or
> my RESULTSETS...

You are right. If an exception is thrown the Statement or ResultSet will
not be closed. 
Try this:

    try{
      Statement s = ....;
      s.close();  //The normal way	
    }
    catch(SQLException e){
      try{
        s.close(); //Close the Statement if an Exception is thrown
      }
      catch(SQLException e2){
      }
      //Your error code here...		
    }

Michael
-- 
           //// 
          (o o) 
+-----ooO--(_)--Ooo---------------------------------------+ 
|                                                         | 
| Michael H�rtig                 Neumann & Partner        | 
|                                Informationssysteme GmbH | 
| Softwareentwicklung            An der Hohen Stra�e 1    | 
|                                08393 Meerane            | 
|                                                         | 
+------------Oooo-----------------------------------------+ 
        oooO (  ) 
        (  )  (_) 
         (_)