ibatis处理器异常（executor.ExecutorException）解决方法

org.apache.ibatis.exceptions.PersistenceException: 

### Error querying database.  Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed.

### Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed.

at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)

at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:124)

at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:90)

at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)

at com.sun.proxy.$Proxy3.getAgeRange(Unknown Source)

at com.lrq.service.impl.UserServiceImpl.getAgeRange(UserServiceImpl.java:49)

at com.lrq.test.Test.testQuery(Test.java:54)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)

at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)

at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)

at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)

at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)

at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)

at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)

at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)

at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)

at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)

at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)

at org.junit.runners.ParentRunner.run(ParentRunner.java:300)

at org.junit.runner.JUnitCore.run(JUnitCore.java:157)

at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:74)

at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:211)

at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:67)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)

Caused by: org.apache.ibatis.executor.ExecutorException: Executor was closed.

at org.apache.ibatis.executor.BaseExecutor.createCacheKey(BaseExecutor.java:168)

at org.apache.ibatis.executor.CachingExecutor.createCacheKey(CachingExecutor.java:140)

at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:80)

at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)

... 33 more

ibatis处理器处理器异常，上面显示原因是Executor was closed.则很有可能是ibatis的session被关闭了，

你这边如果使用全局变量的service进行操作，由于session每次得到dao接口都必须先提交然后关闭，

共享service对象导致下一个不可用

全局变量：
           

public class UserServiceImpl implements UserService {
    private static SqlSession session= MyBatisUtil.getSession();
    private static UserDao userDao=session.getMapper(UserDao.class);
           

所以解决方法是不使用全局变量或者把getSession全部封装到Util里面

不用全局变量

@Override
    public int add(User user) {
	SqlSession session= MyBatisUtil.getSession();
	UserDao userDao=session.getMapper(UserDao.class);
        int rs=userDao.add(user);
        session.commit();
        session.close();
        return rs;
    }
           

全部封装到Util里面

package com.lrq.util;
import com.lrq.dao.UserDao;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.Reader;
/**
 * Created by Administrator on 2017/3/24.
 */
public class MyBatisUtil {
    private static SqlSessionFactory sessionFactory;
    //类加载时执行静态块，静态块只执行一次，以后不再执行
    static{
        Reader reader=null;
        try {
            reader= Resources.getResourceAsReader("mybatis.xml");
        } catch (IOException e) {
            e.printStackTrace();
        }
        sessionFactory=new SqlSessionFactoryBuilder().build(reader);
    }
           

public static SqlSession getSession(){
        SqlSession session=sessionFactory.openSession();
        return  session;
    }
           

}