JSP finally clause

[vulcand4]

I have a JDBC connection pool set up and working, but if I get any kind of exception while processing my JSP, the connection can't be returned to the pool.

Is there a way to specify clean up code to occur in the finally clause in a JSP?

 

[sedj]

Connection conn = null;

try {
   conn = getConnection();
   // Do some SQL execution
} catch (SQLException sqle) {
    sqle.printStackTrace(System.err);
} finally {
   try {
      conn.close();
   } catch (SQLException sqle2) {
       sqle2.printStackTrace(System.err);
   }
}

 

[sedj]

polyGuy

Please do NOT cross-post questions with other related forums here (Tomcat forum) - it is considered bad form.

 

[vulcand4]

Sorry about the cross-post. I thought I was on the Java forum when I first posted it.

 

[sedj]

no worries.