Concise way of closing DB resources code sample

[anjan bacchu <an...@gmail.com>]

Hi All,

  I was looking at the   DataSource HOWTO
page<http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html>and
noticed that the recommended way of closing (BELOW)

finally {
    // Always make sure result sets and statements are closed,
    // and the connection is returned to the pool
    if (rs != null) {
      try { rs.close(); } catch (SQLException e) { ; }
      rs = null;
    }
    if (stmt != null) {
      try { stmt.close(); } catch (SQLException e) { ; }
      stmt = null;
    }
    if (conn != null) {
      try { conn.close(); } catch (SQLException e) { ; }
      conn = null;
    }
 }

can be condensed to

        finally {
            try {
                if (null != rs) {
                    rs.close();
                }
            }
            finally {
                try {
                    if (null != stmt) {
                        stmt.close();
                    }
                }
                finally {
                    if (null != conn) {
                        conn.close();
                    }
                }
            }
        }

This is one (among other) places where it makes sense to use the try/finally
block rather than
the try/catch block.

Just wanted to share this -- if the developers think it makes sense, then
the updated sample would be
useful to all the tomcat users, especially noobs.

Thank you,
<http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html>--

BR,
Anjan Bacchu
Summit Information Systems