Help:Cursor limit exeeded

Hi ,

We are using Java to access the Oracle database.

We are getting the followin Error message

ErrorORA-01000: maximum open cursors exceeded

We close the result sets and the statements after each query. The database does not contain many records . Just 5-6 records. When we run a querty continuosly for about 50 times using

Statement stmt = conn.createStatement();

 rset = stmt.executeQuery("select * from Groups where Group_name" +"=" +"'" + xG
roup_name.getName() + "'");

we get the above error.
We do the following after executing the loop

rset.close();
stmt.close();

Can some one please help us ?

Thanks
Ravi Received on Thu Dec 04 1997 - 00:00:00 CST