SqlSessionTemplate bean is not valid for disposal by Spring container

[mr-serjey]

Spring can not dispose that bean gently because it uses close method of closable

public class SqlSessionTemplate implements SqlSession {
...
@Override
  public void close() {
    throw new UnsupportedOperationException("Manual close is not allowed over a Spring managed SqlSession");
  }
...

Bean definition:

<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
  <constructor-arg index="0" ref="sqlSessionFactory" />
</bean>

Exception appears:

08:22:09.665 [Thread-6] WARN  o.s.b.f.s.DisposableBeanAdapter - Invocation of destroy method 'close' failed on bean with name 'sqlSession'
java.lang.UnsupportedOperationException: Manual close is not allowed over a Spring managed SqlSession
    at org.mybatis.spring.SqlSessionTemplate.close(SqlSessionTemplate.java:306) ~[mybatis-spring-1.2.0.jar:1.2.0]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_67]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_67]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_67]
    at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_67]
    at org.springframework.beans.factory.support.DisposableBeanAdapter.invokeCustomDestroyMethod(DisposableBeanAdapter.java:327) [spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:253) [spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:510) [spring-beans-3.2.4.RELEASE.jar:3.2.4.RELEASE]

[mr-serjey]

Looking forward fix will appear in version 1.3.0

[kazuki43zoo]

👍
I hope quick release !

[eddumelendez]

Waiting the release of mybatis-spring in order to fix mybatis/spring-boot-starter#9

[lpearson05]

I noticed this issue (with mybatis-spring 1.2.3) after bumping the spring version from 4.2.3 to 4.2.4. I've bumped it back down for the time being.

+1: Hadn't realized the fix hadn't actually been released yet (since this issue's status is CLOSED). :?

[lakshmandev]

I'm too facing this problem whenever I stop the jetty server, it throws UnsupportedOperationException. My enviroment is using Spring framework 4.2.4.RELEASE and mybatis-spring version 1.2.3 and mybatis 3.3.0.

[oyvindstegard]

Seeing this issue here as well, on shutdown. Spring 4.2.4, mybatis 3.3.0 and mybatis-spring 1.2.3. Happens in JBoss as well as Jetty, so probably not dependent on server/container.

[mr-serjey]

Fixed in org.mybatis:mybatis-spring:1.2.4