今天用mybatis循环插入数据的时候,插到一百条左右的时候,突然报错,意思就是mysql连接数已经达到最大数。
我看到就想应该是插入一条数据的时候没有释放连接,就百度怎么释放连接,回答说是mybatis能自动释放连接,但是在高并发也会出现这种结果,但是明显这种问题不是高并发。
后来发现我在SqlSessionFactory实例化太多了,导致报错,改成只实例化一个就好了,这个问题我感觉可能初学者会犯,记录一下
之前的错误代码
private SqlSessionFactory factory;
public static void setUp() throws Exception{
String resource = "SqlMapConfig.xml";
//通过流将核心配置文件读取进来
InputStream inputStream = Resources.getResourceAsStream(resource);
//通过核心配置文件输入流来创建会话工厂
factory = new SqlSessionFactoryBuilder().build(inputStream);
}
public void testFindUserById() throws Exception{
setUp();
SqlSession openSession = factory.openSession();
///通过getMapper方法来实例化接口
UserMapper mapper = openSession.getMapper(UserMapper.class);
User user = mapper.findUserById(1);
System.out.println(user);
}
改正之后
private SqlSessionFactory factory;
static {
String resource = "SqlMapConfig.xml";
//通过流将核心配置文件读取进来
InputStream inputStream;
try {
inputStream = Resources.getResourceAsStream(resource);
//通过核心配置文件输入流来创建会话工厂
factory = new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void findUserById(int id) throws Exception{
SqlSession openSession = factory.openSession();
///通过getMapper方法来实例化接口
UserMapper mapper = openSession.getMapper(UserMapper.class);
User user = mapper.findUserById(id);
openSession.commit();
openSession.close();
System.out.println(user);
}