【在使用Mabatis向数据库插入百万数据时出现，出现插入数据大小的报错 _数据库】

在使用Mabatis向数据库插入百万数据时出现，出现插入数据大小的报错

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

数据库

详细描述

错误截图

源码

public class MybatisTest {
    private SqlSessionFactory sqlSessionFactory;

    @Before
    public void init() throws Exception {
        // 创建SqlSessionFactoryBuilder
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
        // 加载SqlMapConfig.xml配置文件
        InputStream inputStream = Resources.getResourceAsStream("MybatisConfig.xml");
        // 创建SqlsessionFactory
        this.sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);
    }

    @Test
    public void testAddStu(){
        SqlSession sqlSession = this.sqlSessionFactory.openSession(ExecutorType.BATCH,false);
        StudentMapper stuMapper = sqlSession.getMapper(StudentMapper.class);
        List<Student> emps = new ArrayList<Student>();
        long startTime = System.currentTimeMillis();
        sqlSession.clearCache();
        for (int i=1;i<=1000000;i++){
            Student student = new Student();
            student.setName("苦哈哈"+i);
            student.setAge(188);
            emps.add(student);

        }
        stuMapper.addStu(emps);
        sqlSession.commit();
        sqlSession.clearCache();
        long endTime = System.currentTimeMillis();
        long time = endTime-startTime;
        System.out.println("耗时========"+time+"毫秒==========");
        System.out.println("耗时========"+time/1000+"秒==========");
        sqlSession.close();
    }

编辑于2024-11-16