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]

Reply via email to