hi, if u close the connections in finally block, then it will be closed successfully. there will be no connections opened. its advisable to close the connection after closing other things
thanks & regards vijayanand.R (),,,() ( (. .) .-''''''''''-. ( o ) ) ( 'o' ) =(,,)=(,,)=(,,)==(,,)= ----- Original Message ----- From: "Manoj Nahar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 14, 2002 11:38 AM 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 ---------------------------------------------------------------------------- ---- --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.361 / Virus Database: 199 - Release Date: 5/7/2002 =========================================================================== 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