<snip rs.close() and stmt.close() should be in the finally block. Agreed. I put them in both places; once after my work with the ResultSet has finished and in the finally block like: if (rs!=null) rs.close(); if(stmt!=null) stmt.close();
Pranav =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
