Technically speaking, its enough to close the connection object. To be a good practice close the associated objects like recordset
Imagination is More Important than Knowledge Cheers !!! MSM -----Original Message----- From: Manoj Nahar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 11:38 AM To: [EMAIL PROTECTED] Subject: JDBC Connection close Hi there, Does it make aby difference if i close the JDBC connection without closing all the resultsets and statements. I am closing connections is try catch finally. Is it possible that connections are left open even after closing them in finally Manoj Nahar http://www.naharonline.com ************************************************************************** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ************************************************************************** =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
