日本综合一区二区|亚洲中文天堂综合|日韩欧美自拍一区|男女精品天堂一区|欧美自拍第6页亚洲成人精品一区|亚洲黄色天堂一区二区成人|超碰91偷拍第一页|日韩av夜夜嗨中文字幕|久久蜜综合视频官网|精美人妻一区二区三区

這篇文章主要介紹“mybaits緩存導致的內(nèi)存溢出java.lang.OutOfMemoryError: Java heap space怎么解決”，在日常操作中，相信很多人在mybaits緩存導致的內(nèi)存溢出java.lang.OutOfMemoryError: Java heap space怎么解決問題上存在疑惑，小編查閱了各式資料，整理出簡單好用的操作方法，希望對大家解答”mybaits緩存導致的內(nèi)存溢出java.lang.OutOfMemoryError: Java heap space怎么解決”的疑惑有所幫助！接下來，請跟著小編一起來學習吧！

青川網(wǎng)站建設(shè)公司成都創(chuàng)新互聯(lián)公司,青川網(wǎng)站設(shè)計制作，有大型網(wǎng)站制作公司豐富經(jīng)驗。已為青川近1000家提供企業(yè)網(wǎng)站建設(shè)服務。企業(yè)網(wǎng)站搭建\成都外貿(mào)網(wǎng)站建設(shè)公司要多少錢，請找那個售后服務好的青川做網(wǎng)站的公司定做！

先貼一下錯誤截圖

org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is java.lang.OutOfMemoryError: Java heap space
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1006)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:881)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:855)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.num.context.SessionFilter.toLogin(SessionFilter.java:164)
	at com.num.context.SessionFilter.doFilterInternal(SessionFilter.java:72)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:115)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:59)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:90)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:108)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:660)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.OutOfMemoryError: Java heap space
	at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:113)
	at org.apache.ibatis.reflection.MetaObject.metaObjectForProperty(MetaObject.java:145)
	at org.apache.ibatis.reflection.wrapper.MapWrapper.hasGetter(MapWrapper.java:122)
	at org.apache.ibatis.reflection.MetaObject.hasGetter(MetaObject.java:109)
	at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.buildParameterMapping(SqlSourceBuilder.java:75)
	at org.apache.ibatis.builder.SqlSourceBuilder$ParameterMappingTokenHandler.handleToken(SqlSourceBuilder.java:67)
	at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:78)
	at org.apache.ibatis.builder.SqlSourceBuilder.parse(SqlSourceBuilder.java:45)
	at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:44)
	at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:292)
	at org.apache.ibatis.executor.statement.BaseStatementHandler.(BaseStatementHandler.java:64)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.(PreparedStatementHandler.java:40)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.(RoutingStatementHandler.java:46)
	at org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:545)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy107.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	at com.sun.proxy.$Proxy75.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)

錯誤如上圖，發(fā)生原因是因為服務器內(nèi)存過下，而批量插入的數(shù)據(jù)量較大導致的。

主要代碼如下

@Override
    @Transactional
    public Map intoDatabases(InputStream inputStream, UserSession session) throws IOException {
        Map map = new HashMap();
        try {
            HSSFWorkbook workbook = new HSSFWorkbook(inputStream);//接收到的報表對象
            inputStream.close();
            HSSFSheet sheet = workbook.getSheetAt(0);
            workbook.cloneSheet(0);
            //獲得當前sheet的結(jié)束行
            int lastRowNum = sheet.getLastRowNum();
//			System.out.println(lastRowNum);
            String batch = DateUtils.getBatch();//批次

            Map cityNumber = new HashMap();
            Map areaMap = new HashMap();
            List numbers = new ArrayList();
            int nums = 0;
            for (int i = 1; i <= lastRowNum; i++) {
                HSSFRow row = sheet.getRow(i);
                Number number = new Number();
//                String city = getStringCellValue(row.getCell(1));//省份
                String city = getStringCellValue(row.getCell(2));//城市
//				System.out.println(city+"---------"+i);
                map.put("areaName", city);
                map.put("level", 2);
                String areaId = areaMapper.findByAreaName(map).getAreaId() + "";
                number.setCityId(areaId);//號碼歸屬地城市
                number.setCity(city);//號碼歸屬地城市
                //存儲城市id以及城市name
                areaMap.put(areaId, city);
//				System.out.println(getStringCellValue(row.getCell(1))+"------------------------"+i);
                number.setSource(getStringCellValue(row.getCell(0)));//號碼來源
                number.setNumber(getStringCellValue(row.getCell(3)));//號碼
                number.setAreaCode(getStringCellValue(row.getCell(4)));//區(qū)號
                number.setImsi(getStringCellValue(row.getCell(5)));//IMSI
                number.setSmsc(getStringCellValue(row.getCell(6)));//短信中心
//                number.setRemarks(getStringCellValue(row.getCell(5)));//備注
                number.setBatch(batch);//批次
                number.setIsSign("1");//標記
                number.setBalance("0");//余額
                number.setStatus("0");//狀態(tài)空閑
                numbers.add(number);
//				numberMapper.insert(number);

                //存儲城市號碼總數(shù)量
                if (cityNumber.containsKey(areaId)) {
                    cityNumber.put(areaId, cityNumber.get(areaId) + 1);
                } else {
                    cityNumber.put(areaId, 1);
                }
            }

            //存儲所有的號碼
            int batchCount = 3000; //每批插入數(shù)目
            int batchLastIndex = batchCount;
            List shareList = new ArrayList<>();
            for (int index = 0; index < numbers.size(); ) {
                if (batchLastIndex >= numbers.size()) {
                    batchLastIndex = numbers.size();
                    shareList = numbers.subList(index, batchLastIndex);
                    break;
                } else {
                    shareList = numbers.subList(index, batchLastIndex);
                    index = batchLastIndex;// 設(shè)置下一批下標
                    batchLastIndex = index + (batchCount - 1);
                }
                numberMapper.batchInsert(shareList);
            }
            numberMapper.batchInsert(shareList);

//            numberMapper.batchInsert(numbers);

            //插入記錄表
            List list = new ArrayList();

            for (String key : cityNumber.keySet()) {
                ImportRecord importRecord = new ImportRecord();
                importRecord.setBatch(batch);//批次
                importRecord.setCityId(key);//城市id
                importRecord.setCityName(areaMap.get(key));//城市名稱
                importRecord.setCount(cityNumber.get(key));//總數(shù)量
                importRecord.setAdminId(session.getAdminId());//導入人
                importRecord.setAdminName(session.getAdminName());//管理員名稱
                list.add(importRecord);
            }

            importRecordMapper.batchInsert(list);

            //插入申請記錄表type=5，員工導入號碼
            ApplyRecord applyRecord = new ApplyRecord();
            applyRecord.setApplicant(session.getAdminId());//申請人
            applyRecord.setCreateTime(new Date());//申請時間
            applyRecord.setNum(numbers.size());//退訂數(shù)量
            applyRecord.setStatus("1");//狀態(tài)
            applyRecord.setBatch(batch);//批次
            applyRecord.setType(5);
            applyRecordMapper.insert(applyRecord);

            map.clear();
            map.put("message", "操作成功");
            map.put("status", "success");
            map.put("icon", "6");
        } catch (Exception e) {
            map.put("message", "操作失敗");
            map.put("status", "error");
            map.put("icon", "5");
            e.printStackTrace();
            throw e;
        } finally {
            inputStream.close();
        }

        return map;
    }

        INSERT INTO num_number
        (number, segment, ascription, balance, status, begin_time, end_time,
        city_id,city, is_sign, area_code, business,imsi, smsc, batch, remarks)
        VALUES
        
            (#{number.number}, #{number.segment}, #{number.ascription}, #{number.balance},
            #{number.status}, #{number.beginTime}, #{number.endTime},#{number.cityId},
            #{number.city}, #{number.isSign}, #{number.areaCode},#{number.business},
            #{number.imsi}, #{number.smsc}, #{number.batch}, #{number.remarks})
        
    

數(shù)據(jù)量大概有八萬條多一點，本地測試正常，發(fā)布線上報錯內(nèi)存溢出。

解決方案

把list做拆分處理，分批執(zhí)行批量插入的操作

java拆分list代碼如下

public static void main(String[] args) {
    //list 為全量集合
    List list = new ArrayList<>();
    for (int i=0; i<96; i++){
        list.add(i+"");
    }
    int batchCount = 15; //每批插入數(shù)目
    int batchLastIndex = batchCount;
    List shareList = new ArrayList<>();
    for (int index = 0; index < list.size(); ) {
        if (batchLastIndex >= list.size()) {
            batchLastIndex = list.size();
            shareList = list.subList(index, batchLastIndex);
            break;
        } else {
            shareList = list.subList(index, batchLastIndex);
            index = batchLastIndex;// 設(shè)置下一批下標
            batchLastIndex = index + (batchCount - 1);
        }
        System.out.println("-------------------------"+index);
        for(int i=0; i
此處不討論其他問題，只討論當服務器性能不足時，mybaits批量帶來的內(nèi)存溢出問題。
到此，關(guān)于“mybaits緩存導致的內(nèi)存溢出java.lang.OutOfMemoryError: Java heap space怎么解決”的學習就結(jié)束了，希望能夠解決大家的疑惑。理論與實踐的搭配能更好的幫助大家學習，快去試試吧！若想繼續(xù)學習更多相關(guān)知識，請繼續(xù)關(guān)注創(chuàng)新互聯(lián)網(wǎng)站，小編會繼續(xù)努力為大家?guī)砀鄬嵱玫奈恼拢?/p>            
            
                                                            

                                                網(wǎng)站題目：mybaits緩存導致的內(nèi)存溢出java.lang.OutOfMemoryError:Javaheapspace怎么解決                                                

                                                鏈接分享：http://www.dlmjj.cn/article/psjicp.html