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

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

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

Introduction

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

Prototype

@Override
void close();

Source Link

Document

Closes the session.

Usage

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

License:GNU General Public License

public static CharacterInfoWithoutQuestionsDTO loadCharacterInfoWithoutQuestions(
        CharacterInfoWithoutQuestions pCharacterInfoWithoutQuestions, Integer lIntIdCharacter) {

    CharacterInfoWithoutQuestionsDTO lCharacterInfoWithoutQuestionsDTO;

    mLog.debug("Start loadCharacterInfoWithoutQuestions(CharacterInfoWithoutQuestions, Integer)");
    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from w w w  . j ava 2s  .c o  m

        CharactersMapper lCharactersMapper = lSqlSession.getMapper(CharactersMapper.class);
        CharactersWithBLOBs lCharacters = lCharactersMapper.selectByPrimaryKey(lIntIdCharacter.longValue());

        lCharacterInfoWithoutQuestionsDTO = new CharacterInfoWithoutQuestionsDTO();
        lCharacterInfoWithoutQuestionsDTO.setId(lIntIdCharacter);
        lCharacterInfoWithoutQuestionsDTO.setCharacterInfoWithoutQuestions(pCharacterInfoWithoutQuestions);

        switch (pCharacterInfoWithoutQuestions) {

        case CONFLICT:
            lCharacterInfoWithoutQuestionsDTO
                    .setTaskStatus(TaskStatus.getTaskStatusFromValue(lCharacters.getConflictTaskStatus()));
            lCharacterInfoWithoutQuestionsDTO.setInfo(lCharacters.getConflict());
            break;

        case EVOLUTION_DURING_THE_STORY:
            lCharacterInfoWithoutQuestionsDTO.setTaskStatus(
                    TaskStatus.getTaskStatusFromValue(lCharacters.getEvolutionduringthestoryTaskStatus()));
            lCharacterInfoWithoutQuestionsDTO.setInfo(lCharacters.getEvolutionduringthestory());
            break;

        case LIFE_BEFORE_STORY_BEGINNING:
            lCharacterInfoWithoutQuestionsDTO.setTaskStatus(
                    TaskStatus.getTaskStatusFromValue(lCharacters.getLifebeforestorybeginningTaskStatus()));
            lCharacterInfoWithoutQuestionsDTO.setInfo(lCharacters.getLifebeforestorybeginning());
            break;

        default:
            break;
        }

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

    mLog.debug("End loadCharacterInfoWithoutQuestions(CharacterInfoWithoutQuestions, Integer)");

    return lCharacterInfoWithoutQuestionsDTO;
}

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 {/*w  ww .jav a2s  .co  m*/

        //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 {/*from w ww .  ja va2 s.co  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 ww w .java2 s.c o 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 SecondaryCharacterDTO loadSecondaryCharacter(Integer lIntIdCharacter) {

    SecondaryCharacterDTO lSecondaryCharacterDTO = null;

    mLog.debug("Start loadSecondaryCharacter(Integer)");
    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from  w ww. j a va 2  s  .co m

        CharactersMapper lCharactersMapper = lSqlSession.getMapper(CharactersMapper.class);
        CharactersWithBLOBs lCharacters = lCharactersMapper.selectByPrimaryKey(lIntIdCharacter.longValue());
        lSecondaryCharacterDTO = createSecondaryCharacterDTOFromCharacters(lCharacters);
        lSecondaryCharacterDTO.setDescription(lCharacters.getSecondaryCharacterDescription());

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

    mLog.debug("End loadSecondaryCharacter(Integer)");

    return lSecondaryCharacterDTO;
}

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 {/*  www  . jav  a  2  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 {/*from   w ww.j a  va 2s. co 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 {/*from   w  ww. j  a  v  a  2s  .  com*/
        // 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 String load(Integer pIntIdImage) {

    String lStrFileName = null;//from w  w w. j  a  v a 2  s.c o  m

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

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

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

        ImagesMapper lImagesMapper = lSqlSession.getMapper(ImagesMapper.class);
        Images lImages = lImagesMapper.selectByPrimaryKey(pIntIdImage.longValue());
        if (lImages != null) {
            lStrFileName = lImages.getFileName();
        }

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

    mLog.debug("End load(ImageDTO)");

    return lStrFileName;

}

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

License:GNU General Public License

public static List<ImageDTO> loadImagesByElement(Integer pIntIdElement, ElementType pElementType) {

    List<ImageDTO> lListImageDTO = new ArrayList<ImageDTO>();

    mLog.debug("Start loadImagesByElement(Integer, ElementType");

    // validate preconditions
    Validate.notNull(pIntIdElement, "argument idElement cannot be null");
    Validate.notNull(pElementType, "argument ElementType cannot be null");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();

    try {/*from  w  ww . ja  va 2 s  .c o  m*/
        ImagesExample lImagesExample = new ImagesExample();
        lImagesExample.createCriteria().andIdElementEqualTo(pIntIdElement)
                .andElementTypeEqualTo(pElementType.getValue());
        lImagesExample.setOrderByClause("id_image");

        ImagesMapper lImagesMapper = lSqlSession.getMapper(ImagesMapper.class);
        List<Images> lListImages = lImagesMapper.selectByExample(lImagesExample);

        for (Images lImages : lListImages) {
            ImageDTO lImageDTO = new ImageDTO();
            lImageDTO.setIdImage(lImages.getIdImage().intValue());
            lImageDTO.setDescription(lImages.getDescription());
            lImageDTO.setElementType(pElementType);
            lImageDTO.setIdElement(pIntIdElement);
            lListImageDTO.add(lImageDTO);
        }

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

    mLog.debug("End loadImagesByElement(ImageDTO");

    return lListImageDTO;

}