Nrthugu

I use java API with mybatis for insert multiple data at a time in DB. It works
properly but service daily stop automatically on web logic
server.

My service code files are as follows -

(1) Action Method class -

public void insertListDetails(){





ObjectMapper jsonObjMapper = new ObjectMapper();



jsonObjMapper.disable(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES);









    SqlSession sqlSession = null;



    String responseStr = null;



    List<String> list_desc = new ArrayList<String>();

    List<String> list_status = new ArrayList<String>();

    List<String> list_remark = new ArrayList<String>();



    list_desc.add(description);

    list_status.add(status);

    list_remark.add(remark);





    String descSeprated = "";

    String statusSeprated = "";

    String remarkSeprated = "";



    response.setContentType("application/json");





try {







        ServerResponse<String> serverResponse = new ServerResponse<String>();

        boolean isError = false;







        if (!isError) {



            try {

                sqlSession = MyBatisUtil.getSqlSessionFactory().openSession();





                InsertListMappers apiMapper = 

                sqlSession.getMapper(InsertListMappers.class);



                InsertList apiDetail = new InsertList();





                for (String string_1 : list_desc) {

                    if (descSeprated.equals("")) {

                        descSeprated = string_1;

                    } else

                        descSeprated = descSeprated + "#" + string_1;

                }

                for (String string_2 : list_status) {

                    if (statusSeprated.equals("")) {

                        statusSeprated = string_2;

                    } else

                        statusSeprated = statusSeprated + "#" + string_2;

                }

                for (String string_3 : list_remark) {

                    if (remarkSeprated.equals("")) {

                        remarkSeprated = string_3;

                    } else

                        remarkSeprated = remarkSeprated + "#" + string_3;

                }







                String data_desc = descSeprated.split("#");

                String data_status = statusSeprated.split("#");

                String data_remark = remarkSeprated.split("#");







                for (int i=0; i<data_desc.length ; i++) {







                    apiDetail.setDocEntry(docEntry);

                    apiDetail.setDescription(data_desc[i]);

                    apiDetail.setStatus(data_status[i]);

                    apiDetail.setRemark(data_remark[i]);





                    apiMapper.insertListDetails(apiDetail);

                    sqlSession.commit();









                }







            } catch (Exception e1) {

                e1.printStackTrace();

            }





            serverResponse.setStatus(ServerResponse.STATUS.OK);

            serverResponse.setData("Record inserted sucessfully");









        }



        responseStr = jsonObjMapper.writeValueAsString(serverResponse);

        response.getWriter().write(responseStr);



    } catch (Exception e) {



        e.printStackTrace();



    } finally {

        if (sqlSession != null) {

            sqlSession.close();

        }

    }

}

(2) This is xml file for database query -

<?xml version="1.0" encoding="UTF-8"?>



<!DOCTYPE mapper PUBLIC '-//mybatis.org//DTD Mapper 3.0//EN'

'http://mybatis.org/dtd/mybatis-3-mapper.dtd'>



<mapper namespace='com.ti.mappers.InsertListMappers'>

<resultMap type='InsertList' id='InsertListResult'>



    <result property='docEntry' column='DOCENTRY' />

    <result property='description' column='U_DESC' />

    <result property='status' column='U_STATUS' />

    <result property='remark' column='U_REASON' />

    <result property='lineId' column='LINEID' />



  </resultMap>



  <insert id='insertListDetails' parameterType='InsertList'>



    INSERT INTO

    HKCHKREC_L(DOCENTRY, U_DESC, U_STATUS, U_REASON, LINEID)

    VALUES(#{docEntry},#{description},#{status},#{remark},#{lineId})

  </insert>



</mapper>