Does Spring's JdbcTemplate close the connection if an exception is thrown?

java spring exception-handling jdbctemplate
aakoch picture aakoch · Feb 23, 2011 · Viewed 25.3k times · Source

When Spring catches an SQLException, does it close the prepared statement, result set, and/or connection before throwing it's own DataAccessException (runtime) exception?

I have a developer who wants to create an AOP aspect to catch these exceptions and log and/or close the connection.

@AfterThrowing(pointcut="dataAccessOperation()", throwing="exception")
public void doRecoveryActions(JoinPoint thisJoinPoint, DataAccessException exception) {
     // log and/or close connection
}

Answer

axtavt picture axtavt · Feb 23, 2011

Yes.

That's the whole point of JdbcTemplate - it handles all kinds of boilerplate actions including release of all resources. See 12. Data access with JDBC.

Related questions

Spring Boot REST service exception handling

I am trying to set up a large-scale REST services server. We're using Spring Boot 1.2.1 Spring 4.1.5, and Java 8. Our controllers are implementing @RestController and the standard @RequestMapping annotations. My problem is that Spring Boot sets up a default redirect for …

Read More
Spring Async Uncaught Exception handler

@Override @Async public void asyncExceptionTest() { int i=1/0; } How can I log this using Spring Async framework without having to put try catch around every async method? It doesn't seem to pass to the DefaultUncaughtExceptionHandler like normal.

Read More
How to use @ExceptionHandler in Spring Interceptor？

I am using springmvc to create restful api for client， I have an interceptor for checking the accesstoken. public class AccessTokenInterceptor extends HandlerInterceptorAdapter { @Override public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception { if (handler instanceof HandlerMethod) { HandlerMethod …

Read More