Example usage for org.apache.ibatis.session SqlSession rollback

List of usage examples for org.apache.ibatis.session SqlSession rollback

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession rollback.

Prototype

void rollback();

Source Link

Document

Discards pending batch statements and rolls database connection back.

Usage

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentNewuserServiceImpl.java

License:Apache License

public int deleteComponentNewuserDayByDate(String year, String month, String day) throws Exception {

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentNewuserDao dao = session.getMapper(ComponentNewuserDao.class);

    boolean has_error = false;

    try {/*from  w w w  . j  a  v a  2  s .c o m*/
        dao.deleteCompoNewuserDayByKey(year, month, day, "", "");
        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentNewuserServiceImpl.java

License:Apache License

public int insertBatchComponentNewuserWeek(List<CompoNewuserAll> in_volist) throws Exception {

    if (in_volist == null) {
        return 0;
    }//from   ww  w .  j  a va2s.c o  m

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentNewuserDao dao = session.getMapper(ComponentNewuserDao.class);

    boolean has_error = false;

    try {

        if (in_volist != null) {

            Iterator<CompoNewuserAll> it = in_volist.iterator();

            while (it.hasNext()) {
                CompoNewuserAll insert = it.next();
                dao.insertCompoNewuserWeek(insert);
            }
        }

        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentNewuserServiceImpl.java

License:Apache License

public int deleteComponentNewuserWeekByDate(String year, String week) throws Exception {

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentNewuserDao dao = session.getMapper(ComponentNewuserDao.class);

    boolean has_error = false;

    try {/*from  w w w  .  ja va  2  s .c  o  m*/
        dao.deleteCompoNewuserWeekByKey(year, week, "", "");
        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentNewuserServiceImpl.java

License:Apache License

public int insertBatchComponentNewuserMonth(List<CompoNewuserAll> in_volist) throws Exception {

    if (in_volist == null) {
        return 0;
    }/*from w  w w. j  av a2  s.  c  om*/

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentNewuserDao dao = session.getMapper(ComponentNewuserDao.class);

    boolean has_error = false;

    try {

        if (in_volist != null) {

            Iterator<CompoNewuserAll> it = in_volist.iterator();

            while (it.hasNext()) {
                CompoNewuserAll insert = it.next();
                dao.insertCompoNewuserMonth(insert);
            }
        }

        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentNewuserServiceImpl.java

License:Apache License

public int deleteComponentNewuserMonthByDate(String year, String month) throws Exception {

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentNewuserDao dao = session.getMapper(ComponentNewuserDao.class);

    boolean has_error = false;

    try {/*from   w  ww.  j a  v  a  2s  .c  o m*/
        dao.deleteCompoNewuserMonthByKey(year, month, "", "");
        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentOsversionServiceImpl.java

License:Apache License

public int insertBatchComponentOsversionDay(List<CompoOsversionAll> in_volist) throws Exception {

    if (in_volist == null) {
        return 0;
    }// w w  w .java  2s . c  o m

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentOsversionDao dao = session.getMapper(ComponentOsversionDao.class);

    boolean has_error = false;

    try {

        if (in_volist != null) {

            Iterator<CompoOsversionAll> it = in_volist.iterator();

            while (it.hasNext()) {
                CompoOsversionAll insert = it.next();
                dao.insertCompoOsversionDay(insert);
            }
        }

        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentOsversionServiceImpl.java

License:Apache License

public int deleteComponentOsversionDayByDate(String year, String month, String day) throws Exception {

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentOsversionDao dao = session.getMapper(ComponentOsversionDao.class);

    boolean has_error = false;

    try {//from  w  w w. ja  v  a2 s .c o m
        dao.deleteCompoOsversionDayByKey(year, month, day, "", "", "");
        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentOsversionServiceImpl.java

License:Apache License

public int insertBatchComponentOsversionWeek(List<CompoOsversionAll> in_volist) throws Exception {

    if (in_volist == null) {
        return 0;
    }/*w  w  w.j  av  a  2  s.c  o m*/

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentOsversionDao dao = session.getMapper(ComponentOsversionDao.class);

    boolean has_error = false;

    try {

        if (in_volist != null) {

            Iterator<CompoOsversionAll> it = in_volist.iterator();

            while (it.hasNext()) {
                CompoOsversionAll insert = it.next();
                dao.insertCompoOsversionWeek(insert);
            }
        }

        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentOsversionServiceImpl.java

License:Apache License

public int deleteComponentOsversionWeekByDate(String year, String week) throws Exception {

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentOsversionDao dao = session.getMapper(ComponentOsversionDao.class);

    boolean has_error = false;

    try {//  w w  w.  j a v  a 2s. com
        dao.deleteCompoOsversionWeekByKey(year, week, "", "", "");
        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}

From source file:ph.fingra.hadoop.dbms.parts.component.service.ComponentOsversionServiceImpl.java

License:Apache License

public int insertBatchComponentOsversionMonth(List<CompoOsversionAll> in_volist) throws Exception {

    if (in_volist == null) {
        return 0;
    }/*from   ww  w  .  j  a  v a  2 s .  c  o m*/

    SqlSession session = ConnectionFactory.getSession().openSession(ExecutorType.BATCH, false);
    ComponentOsversionDao dao = session.getMapper(ComponentOsversionDao.class);

    boolean has_error = false;

    try {

        if (in_volist != null) {

            Iterator<CompoOsversionAll> it = in_volist.iterator();

            while (it.hasNext()) {
                CompoOsversionAll insert = it.next();
                dao.insertCompoOsversionMonth(insert);
            }
        }

        List<BatchResult> results = session.flushStatements();
        results.clear();
    } catch (Exception e) {
        has_error = true;
        session.rollback();
        session.close();
        throw e;
    } finally {
        if (has_error == false)
            session.commit();
        session.close();
    }

    return (has_error == false) ? 1 : 0;
}