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

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

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. commit

Introduction

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

Prototype

void commit();

Source Link

Document

Flushes batch statements and commits database connection.

Usage

From source file:com.bibisco.manager.CharacterManager.java

License:GNU General Public License

private static boolean deleteCharacterByPosition(Integer pIntPosition, boolean pBlnMainCharacter) {

    boolean lBlnResult;

    mLog.debug("Start deleteCharacterByPosition(" + pIntPosition + "," + pBlnMainCharacter + ")");

    // get character by position
    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//  w w w . j  a v  a2  s .  c  om

        CharactersMapper lCharactersMapper = lSqlSession.getMapper(CharactersMapper.class);

        //get character by position and main flag
        CharactersExample lCharactersExample = new CharactersExample();
        lCharactersExample.createCriteria().andPositionEqualTo(pIntPosition)
                .andMainCharacterEqualTo(pBlnMainCharacter ? "Y" : "N");
        Characters lCharacters = lCharactersMapper.selectByExample(lCharactersExample).get(0);

        // check if character is referenced
        boolean lBlnIsReferenced = checkIfReferenced(lCharacters.getIdCharacter().intValue(), lSqlSession);

        // character is not referenced, go on
        if (!lBlnIsReferenced) {

            // delete character infos
            deleteCharacterInfosByIdCharacter(lCharacters.getIdCharacter().intValue(), lSqlSession);

            // delete character
            lCharactersMapper.deleteByPrimaryKey(lCharacters.getIdCharacter());

            // shift down other character
            lCharactersMapper.shiftDown(pIntPosition, Integer.MAX_VALUE, pBlnMainCharacter ? "Y" : "N");

            // delete images
            ImageManager.deleteImagesByElement(lSqlSession, lCharacters.getIdCharacter().intValue(),
                    ElementType.CHARACTERS);

            lBlnResult = true;
        }
        // character is referenced, stop
        else {
            lBlnResult = false;
        }

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End deleteCharacterByPosition(" + pIntPosition + "," + pBlnMainCharacter + ")");

    return lBlnResult;
}

From source file:com.bibisco.manager.CharacterManager.java

License:GNU General Public License

private static void move(Integer pIntSourcePosition, Integer pIntDestPosition, boolean pBlnMainCharacter) {

    mLog.debug("Start move(Integer, Integer, boolean)");

    if (!pIntSourcePosition.equals(pIntDestPosition)) {
        SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance()
                .getSqlSessionFactoryProject();
        SqlSession lSqlSession = lSqlSessionFactory.openSession();
        try {/*from  w  w  w .  ja v a2s .  co  m*/

            CharactersMapper lCharactersMapper = lSqlSession.getMapper(CharactersMapper.class);

            //get character by position and main flag
            CharactersExample lCharactersExample = new CharactersExample();
            lCharactersExample.createCriteria().andPositionEqualTo(pIntSourcePosition)
                    .andMainCharacterEqualTo(pBlnMainCharacter ? "Y" : "N");
            Characters lCharacters = lCharactersMapper.selectByExample(lCharactersExample).get(0);

            // update character position with fake position to preserve unique index before shift
            lCharacters.setPosition(-1);
            lCharactersMapper.updateByPrimaryKey(lCharacters);

            // update other Characters' position
            Integer lIntStartPosition;
            Integer lIntEndPosition;
            if (pIntSourcePosition > pIntDestPosition) {
                lIntStartPosition = pIntDestPosition;
                lIntEndPosition = pIntSourcePosition;
                lCharactersMapper.shiftUp(lIntStartPosition, lIntEndPosition, pBlnMainCharacter ? "Y" : "N");
            } else {
                lIntStartPosition = pIntSourcePosition;
                lIntEndPosition = pIntDestPosition;
                lCharactersMapper.shiftDown(lIntStartPosition, lIntEndPosition, pBlnMainCharacter ? "Y" : "N");
            }

            // update character position
            lCharacters.setPosition(pIntDestPosition);
            lCharactersMapper.updateByPrimaryKey(lCharacters);

            lSqlSession.commit();

        } catch (Throwable t) {
            mLog.error(t);
            lSqlSession.rollback();
            throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
        } finally {
            lSqlSession.close();
        }
    }

    mLog.debug("End move(Integer, Integer, boolean)");
}

From source file:com.bibisco.manager.CharacterManager.java

License:GNU General Public License

public static void saveCharacterInfoQuestions(CharacterInfoQuestionsDTO pCharacterInfoQuestionsDTO) {

    mLog.debug("Start saveCharacterInfoQuestions(CharacterInfoQuestionsDTO)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from  w ww. j  ava  2 s. com*/

        //update characters table

        CharactersWithBLOBs lCharacters = new CharactersWithBLOBs();
        lCharacters.setIdCharacter(pCharacterInfoQuestionsDTO.getId().longValue());

        switch (pCharacterInfoQuestionsDTO.getCharacterInfoQuestions()) {

        case BEHAVIORS:
            lCharacters.setBehaviorsFreeText(pCharacterInfoQuestionsDTO.getFreeText());
            lCharacters.setBehaviorsInterview(pCharacterInfoQuestionsDTO.getInterviewMode() ? "Y" : "N");
            lCharacters.setBehaviorsTaskStatus(pCharacterInfoQuestionsDTO.getTaskStatus().getValue());
            break;

        case IDEAS:
            lCharacters.setIdeasFreeText(pCharacterInfoQuestionsDTO.getFreeText());
            lCharacters.setIdeasInterview(pCharacterInfoQuestionsDTO.getInterviewMode() ? "Y" : "N");
            lCharacters.setIdeasTaskStatus(pCharacterInfoQuestionsDTO.getTaskStatus().getValue());
            break;

        case PERSONAL_DATA:
            lCharacters.setPersonalDataFreeText(pCharacterInfoQuestionsDTO.getFreeText());
            lCharacters.setPersonalDataInterview(pCharacterInfoQuestionsDTO.getInterviewMode() ? "Y" : "N");
            lCharacters.setPersonalDataTaskStatus(pCharacterInfoQuestionsDTO.getTaskStatus().getValue());
            break;

        case PHYSIONOMY:
            lCharacters.setPhysionomyFreeText(pCharacterInfoQuestionsDTO.getFreeText());
            lCharacters.setPhysionomyInterview(pCharacterInfoQuestionsDTO.getInterviewMode() ? "Y" : "N");
            lCharacters.setPhysionomyTaskStatus(pCharacterInfoQuestionsDTO.getTaskStatus().getValue());
            break;

        case PSYCHOLOGY:
            lCharacters.setPsychologyFreeText(pCharacterInfoQuestionsDTO.getFreeText());
            lCharacters.setPsychologyInterview(pCharacterInfoQuestionsDTO.getInterviewMode() ? "Y" : "N");
            lCharacters.setPsychologyTaskStatus(pCharacterInfoQuestionsDTO.getTaskStatus().getValue());
            break;

        case SOCIOLOGY:
            lCharacters.setSociologyFreeText(pCharacterInfoQuestionsDTO.getFreeText());
            lCharacters.setSociologyInterview(pCharacterInfoQuestionsDTO.getInterviewMode() ? "Y" : "N");
            lCharacters.setSociologyTaskStatus(pCharacterInfoQuestionsDTO.getTaskStatus().getValue());
            break;

        default:
            break;
        }

        CharactersMapper lCharactersMapper = lSqlSession.getMapper(CharactersMapper.class);
        lCharactersMapper.updateByPrimaryKeySelective(lCharacters);

        //update character info table
        CharacterInfosMapper lCharacterInfosMapper = lSqlSession.getMapper(CharacterInfosMapper.class);
        CharacterInfosExample lCharacterInfosExample = new CharacterInfosExample();
        lCharacterInfosExample.createCriteria()
                .andCharacterInfoTypeEqualTo(pCharacterInfoQuestionsDTO.getCharacterInfoQuestions().name())
                .andIdCharacterEqualTo(pCharacterInfoQuestionsDTO.getId());

        lCharacterInfosMapper.deleteByExample(lCharacterInfosExample);

        for (int i = 1; i <= pCharacterInfoQuestionsDTO.getAnswerList().size(); i++) {
            CharacterInfos lCharacterInfos = new CharacterInfos();
            lCharacterInfos.setCharacterInfoType(pCharacterInfoQuestionsDTO.getCharacterInfoQuestions().name());
            lCharacterInfos.setIdCharacter(pCharacterInfoQuestionsDTO.getId());
            lCharacterInfos.setQuestion(i);
            lCharacterInfos.setInfo(pCharacterInfoQuestionsDTO.getAnswerList().get(i - 1));
            lCharacterInfosMapper.insert(lCharacterInfos);
        }

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End saveCharacterInfoQuestions(CharacterInfoQuestionsDTO)");

}

From source file:com.bibisco.manager.CharacterManager.java

License:GNU General Public License

public static void saveCharacterInfoWithoutQuestions(
        CharacterInfoWithoutQuestionsDTO pCharacterInfoWithoutQuestionsDTO) {

    mLog.debug("Start saveCharacterInfoWithoutQuestions(CharacterInfoQuestionsDTO)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/* www .  j  av  a  2 s  .c  o  m*/

        //update characters table
        CharactersWithBLOBs lCharacters = new CharactersWithBLOBs();
        lCharacters.setIdCharacter(pCharacterInfoWithoutQuestionsDTO.getId().longValue());

        switch (pCharacterInfoWithoutQuestionsDTO.getCharacterInfoWithoutQuestions()) {

        case CONFLICT:
            lCharacters.setConflict(pCharacterInfoWithoutQuestionsDTO.getInfo());
            lCharacters.setConflictTaskStatus(pCharacterInfoWithoutQuestionsDTO.getTaskStatus().getValue());
            break;

        case EVOLUTION_DURING_THE_STORY:
            lCharacters.setEvolutionduringthestory(pCharacterInfoWithoutQuestionsDTO.getInfo());
            lCharacters.setEvolutionduringthestoryTaskStatus(
                    pCharacterInfoWithoutQuestionsDTO.getTaskStatus().getValue());
            break;

        case LIFE_BEFORE_STORY_BEGINNING:
            lCharacters.setLifebeforestorybeginning(pCharacterInfoWithoutQuestionsDTO.getInfo());
            lCharacters.setLifebeforestorybeginningTaskStatus(
                    pCharacterInfoWithoutQuestionsDTO.getTaskStatus().getValue());
            break;

        default:
            break;
        }

        CharactersMapper lCharactersMapper = lSqlSession.getMapper(CharactersMapper.class);
        lCharactersMapper.updateByPrimaryKeySelective(lCharacters);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End saveCharacterInfoWithoutQuestions(CharacterInfoQuestionsDTO)");

}

From source file:com.bibisco.manager.CharacterManager.java

License:GNU General Public License

public static void changeCharacterName(CharacterDTO pCharacterDTO) {

    mLog.debug("Start save(CharacterDTO)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from w ww .  ja v a 2 s .co m*/

        CharactersWithBLOBs lCharacters = new CharactersWithBLOBs();
        lCharacters.setIdCharacter(pCharacterDTO.getIdCharacter().longValue());
        lCharacters.setName(pCharacterDTO.getName());

        CharactersMapper lCharactersMapper = lSqlSession.getMapper(CharactersMapper.class);
        lCharactersMapper.updateByPrimaryKeySelective(lCharacters);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End save(CharacterDTO)");
}

From source file:com.bibisco.manager.CharacterManager.java

License:GNU General Public License

public static void saveSecondaryCharacter(SecondaryCharacterDTO pSecondaryCharacterDTO) {
    mLog.debug("Start saveSecondaryCharacter(SecondaryCharacterDTO)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//w  w  w  .j a va2 s .  c om

        CharactersWithBLOBs lCharacters = new CharactersWithBLOBs();
        lCharacters.setIdCharacter(pSecondaryCharacterDTO.getIdCharacter().longValue());
        lCharacters.setSecondaryCharacterDescription(pSecondaryCharacterDTO.getDescription());
        lCharacters
                .setSecondaryCharacterDescriptionTaskStatus(pSecondaryCharacterDTO.getTaskStatus().getValue());

        CharactersMapper lCharactersMapper = lSqlSession.getMapper(CharactersMapper.class);
        lCharactersMapper.updateByPrimaryKeySelective(lCharacters);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End saveSecondaryCharacter(SecondaryCharacterDTO)");

}

From source file:com.bibisco.manager.HttpManager.java

License:GNU General Public License

private static boolean showMessage(WebMessage pWebMessage) {

    boolean lBlnResult = false;

    mLog.debug("Start showMessage(WebMessage)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*  w w  w . java  2 s . c o m*/

        MessagesMapper lMessagesMapper = lSqlSession.getMapper(MessagesMapper.class);
        Messages lMessages = lMessagesMapper.selectByPrimaryKey(pWebMessage.getIdMessage());

        if (lMessages != null) {
            // message already read: check if i can show another time
            if (lMessages.getNumberOfViews() < pWebMessage.getNumberOfViewsAllowed()) {
                lMessages.setNumberOfViews(lMessages.getNumberOfViews() + 1);
                lMessagesMapper.updateByPrimaryKey(lMessages);
                lBlnResult = true;
            } else {
                lBlnResult = false;
            }
        } else {
            // message not read
            lMessages = new Messages();
            lMessages.setIdMessage(pWebMessage.getIdMessage());
            lMessages.setNumberOfViews(1);
            lMessagesMapper.insert(lMessages);
            lBlnResult = true;
        }

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End showMessage(WebMessage)");

    return lBlnResult;
}

From source file:com.bibisco.manager.ImageManager.java

License:GNU General Public License

public static ImageDTO insert(ImageDTO pImageDTO) {

    mLog.debug("Start insert(ImageDTO)");

    // validate preconditions
    Validate.notNull(pImageDTO, "argument ImageDTO cannot be null");
    Validate.notNull(pImageDTO.getIdElement(), "argument ImageDTO.idElement cannot be null");
    Validate.notNull(pImageDTO.getElementType(), "argument ImageDTO.elementType cannot be null");
    Validate.notNull(pImageDTO.getInputStream(), "argument ImageDTO.inputStream cannot be null");
    Validate.notEmpty(pImageDTO.getSourceFileName(), "argument ImageDTO.sourceFileName cannot be empty");
    Validate.notEmpty(pImageDTO.getDescription(), "argument ImageDTO.description cannot be empty");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//w  w w  .  j av a2s. c  o m
        // write file to file system
        String lStrFileName = writeFile(pImageDTO);

        Images lImages = new Images();
        lImages.setDescription(pImageDTO.getDescription());
        lImages.setIdElement(pImageDTO.getIdElement());
        lImages.setElementType(pImageDTO.getElementType().getValue());
        lImages.setFileName(lStrFileName);

        ImagesMapper lImagesMapper = lSqlSession.getMapper(ImagesMapper.class);
        lImagesMapper.insert(lImages);

        pImageDTO.setIdImage(lImages.getIdImage().intValue());
        pImageDTO.setTargetFileName(lStrFileName);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("Start insert(ImageDTO)");

    return pImageDTO;

}

From source file:com.bibisco.manager.ImageManager.java

License:GNU General Public License

public static void delete(Integer pIntIdImage) {

    mLog.debug("Start delete(Integer)");

    // validate preconditions
    Validate.notNull(pIntIdImage, "argument idImage cannot be null");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*  w w  w. j ava2 s  . co m*/
        ImagesMapper lImagesMapper = lSqlSession.getMapper(ImagesMapper.class);

        // load image to delete
        Images lImages = lImagesMapper.selectByPrimaryKey(pIntIdImage.longValue());

        if (lImages != null) {
            // delete image file on disk
            deleteFile(lImages.getFileName());

            // delete image on db
            lImagesMapper.deleteByPrimaryKey(pIntIdImage.longValue());

            lSqlSession.commit();
        }

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End delete(Integer)");
}

From source file:com.bibisco.manager.LocaleManager.java

License:GNU General Public License

private Locale initLocale() {

    Locale lLocale = null;/*from   w w  w .ja v  a  2 s.  c  o  m*/

    mLog.debug("Start initLocale()");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {

        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        Properties lProperties = lPropertiesMapper.selectByPrimaryKey("locale");

        if (lProperties != null) {
            String[] lStrLocaleSplit = lProperties.getValue().split("_");
            lLocale = new Locale(lStrLocaleSplit[0], lStrLocaleSplit[1]);

        } else {
            lLocale = Locale.getDefault();

            // save locale
            lProperties = new Properties();
            lProperties.setProperty("locale");
            lProperties.setValue(lLocale.toString());
            lPropertiesMapper.insert(lProperties);

            lSqlSession.commit();
        }

    } catch (Throwable t) {
        lSqlSession.rollback();
        mLog.error(t);
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End initLocale()");

    return lLocale;
}