Re: JDBC Pool exhaustion

[Mikolaj Rydzewski]

DE VINZELLES, Guillaume (ext.) wrote:

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) {}
}

You use plain JDBC calls. Have you considered jakarta commons dbutils here? It simplifies a lot: no more need to do nasty finally{} calls.

--
Mikolaj Rydzewski <[EMAIL PROTECTED]>

smime.p7s
Description: S/MIME Cryptographic Signature