Make sure you close the statement in your "finally" clause. We had that
problem solved after doing something like this
try{
//create statement
}catch( SQLException e ){
//do something
}
finally{
if( st != null ) //st is the statement
st.close();
}
make sure you do that wherever you are creating Statements.
You can also find out commercial tools to find out the queries made to
your database and whihc ones are leaving cursors open..
-Pradeep
Pradeep Paudyal
Developer, Bricsnet US
Ph: 603 559 2505
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
