Seems to be good except:
finally { try { if (result != null) { result.close(); result = null; } if (oCmd != null) { oCmd.close(); oCmd = null; } if (myConnection != null) { myConnection.close(); myConnection = null; } } catch (SQLException e) {} }
If there is an exception during result or oCmd closing, your connection is never closed ... -- Pascal Alberty http://pascal.albertyorban.be --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]