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.ProjectFromSceneManager.java

License:GNU General Public License

private static List<SceneRevisionDTO> loadScenesByIdChapter(Integer pIntIdChapter) {

    List<SceneRevisionDTO> lListSceneRevisionDTO = null;

    mLog.debug("Start loadScenesByIdChapter(" + pIntIdChapter + ")");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from w w w . j a  v  a  2 s.c  o  m
        VSelectedSceneRevisionsMapper lVSelectedSceneRevisionsMapper = lSqlSession
                .getMapper(VSelectedSceneRevisionsMapper.class);
        VSelectedSceneRevisionsExample lVSelectedSceneRevisionsExample = new VSelectedSceneRevisionsExample();
        lVSelectedSceneRevisionsExample.createCriteria().andIdChapterEqualTo(pIntIdChapter.longValue());
        lVSelectedSceneRevisionsExample.setOrderByClause("SCENE_POSITION");

        List<VSelectedSceneRevisions> lListVSelectedSceneRevisions = lVSelectedSceneRevisionsMapper
                .selectByExampleWithBLOBs(lVSelectedSceneRevisionsExample);
        lListSceneRevisionDTO = new ArrayList<SceneRevisionDTO>();
        for (VSelectedSceneRevisions lVSelectedSceneRevisions : lListVSelectedSceneRevisions) {
            SceneRevisionDTO lSceneRevisionDTO = new SceneRevisionDTO();
            lSceneRevisionDTO.setIdScene(lVSelectedSceneRevisions.getIdScene().intValue());
            lSceneRevisionDTO.setTitle(lVSelectedSceneRevisions.getSceneDescription());
            lSceneRevisionDTO.setText(lVSelectedSceneRevisions.getScene());
            lSceneRevisionDTO.setPosition(lVSelectedSceneRevisions.getScenePosition());
            lSceneRevisionDTO.setTaskStatus(
                    TaskStatus.getTaskStatusFromValue(lVSelectedSceneRevisions.getSceneTaskStatus()));
            lSceneRevisionDTO.setIdChapter(lVSelectedSceneRevisions.getIdChapter().intValue());
            lListSceneRevisionDTO.add(lSceneRevisionDTO);
        }

    } catch (Throwable t) {
        mLog.error(t);
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }
    mLog.debug("End loadScenesByIdChapter(" + pIntIdChapter + ")");

    return lListSceneRevisionDTO;
}

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

License:GNU General Public License

private static ProjectDTO load() {

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

    Project lProject;//from  www. j ava 2s .  c  o m
    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        lProject = lProjectMapper.selectByPrimaryKey(ContextManager.getInstance().getIdProject());

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

    ProjectDTO lProjectDTO = new ProjectDTO();
    lProjectDTO.setIdProject(lProject.getIdProject());
    lProjectDTO.setName(lProject.getName());
    lProjectDTO.setLanguage(lProject.getLanguage());
    lProjectDTO.setBibiscoVersion(lProject.getBibiscoVersion());

    ArchitectureDTO lArchitectureDTO = new ArchitectureDTO();
    lArchitectureDTO.setPremiseTaskStatus(TaskStatus.getTaskStatusFromValue(lProject.getPremiseTaskStatus()));
    lArchitectureDTO.setFabulaTaskStatus(TaskStatus.getTaskStatusFromValue(lProject.getFabulaTaskStatus()));
    lArchitectureDTO.setSettingTaskStatus(TaskStatus.getTaskStatusFromValue(lProject.getSettingTaskStatus()));
    lArchitectureDTO.setStrandList(StrandManager.loadAll());

    lProjectDTO.setArchitecture(lArchitectureDTO);
    lProjectDTO.setChapterList(ChapterManager.loadAll());
    lProjectDTO.setMainCharacterList(CharacterManager.loadMainCharacters());
    lProjectDTO.setSecondaryCharacterList(CharacterManager.loadSecondaryCharacters());
    lProjectDTO.setLocationList(LocationManager.loadAll());

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

    return lProjectDTO;
}

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

License:GNU General Public License

public static List<ProjectDTO> loadAll() {

    List<ProjectDTO> lListProjectDTO = null;

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

    // delete projects entries on bibisco db
    ProjectManager.deleteProjectsEntriesOnBibiscoDB();

    // import projects
    importProjectsFromProjectsDirectory();

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*  ww  w . j a v a  2 s.c o m*/
        ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
        ProjectsExample lProjectsExample = new ProjectsExample();
        lProjectsExample.setOrderByClause("UPPER(name) asc");
        List<Projects> lListProjects = lProjectsMapper.selectByExample(lProjectsExample);

        if (lListProjects != null && lListProjects.size() > 0) {
            lListProjectDTO = new ArrayList<ProjectDTO>();
            for (Projects lProjects : lListProjects) {

                if (projectExists(lProjects.getIdProject())) {
                    ProjectDTO lProjectDTO = new ProjectDTO();
                    lProjectDTO.setIdProject(lProjects.getIdProject());
                    lProjectDTO.setName(lProjects.getName());
                    lListProjectDTO.add(lProjectDTO);
                } else {
                    lProjectsMapper.deleteByPrimaryKey(lProjects.getIdProject());
                }
            }
        }

        lSqlSession.commit();

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

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

    return lListProjectDTO;
}

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

License:GNU General Public License

private static void insertIntoProjectDB(ProjectDTO pProjectDTO) {

    mLog.debug("Start insertIntoProjectDB(ProjectDTO)");

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

        // insert project
        ProjectWithBLOBs lProjectWithBLOBs = new ProjectWithBLOBs();
        lProjectWithBLOBs.setIdProject(pProjectDTO.getIdProject());
        lProjectWithBLOBs.setName(pProjectDTO.getName());
        lProjectWithBLOBs.setLanguage(pProjectDTO.getLanguage());
        lProjectWithBLOBs.setBibiscoVersion(pProjectDTO.getBibiscoVersion());

        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        lProjectMapper.insertSelective(lProjectWithBLOBs);

        lSqlSession.commit();

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

    mLog.debug("End insertIntoBibiscoDB(ProjectDTO)");
}

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

License:GNU General Public License

public static void delete(String pStrIdProject) {

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

    // validate preconditions
    Validate.notEmpty(pStrIdProject, "Id project cannot be empty");
    Validate.isTrue(ProjectManager.projectExists(pStrIdProject), "Project references non existent directory");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from   w  ww  .  ja  va2s .co m*/

        // delete entry on bibisco db
        ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lProjectsMapper.deleteByPrimaryKey(pStrIdProject);

        // delete file
        FileUtils.deleteDirectory(new File(getDBProjectDirectory(pStrIdProject)));

        lSqlSession.commit();

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

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

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

License:GNU General Public License

private static void insertIntoBibiscoDB(ProjectDTO pProjectDTO) {

    mLog.debug("Start insertIntoBibiscoDB(ProjectDTO)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*  www.  j  a va 2 s.c  om*/
        Projects lProjects = new Projects();
        lProjects.setIdProject(pProjectDTO.getIdProject());
        lProjects.setName(pProjectDTO.getName());

        ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lProjectsMapper.insertSelective(lProjects);

        lSqlSession.commit();

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

    mLog.debug("End insertIntoBibiscoDB(ProjectDTO)");
}

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

License:GNU General Public License

private static List<VSelectedSceneRevisions> getAllSelectedScenes() {

    List<VSelectedSceneRevisions> lListVSelectedSceneRevisions = null;

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

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

    try {/*from   w w w .  j  a  va2 s .  c o  m*/
        VSelectedSceneRevisionsMapper lVSelectedSceneRevisionsMapper = lSqlSession
                .getMapper(VSelectedSceneRevisionsMapper.class);
        VSelectedSceneRevisionsExample lVSelectedSceneRevisionsExample = new VSelectedSceneRevisionsExample();
        lVSelectedSceneRevisionsExample.setOrderByClause("chapter_position, scene_position");
        lListVSelectedSceneRevisions = lVSelectedSceneRevisionsMapper
                .selectByExampleWithBLOBs(lVSelectedSceneRevisionsExample);
    } catch (Throwable t) {
        mLog.error(t);
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

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

    return lListVSelectedSceneRevisions;
}

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

License:GNU General Public License

private static ImportProjectArchiveDTO checkImportProjectArchive() {

    ImportProjectArchiveDTO lImportProjectArchiveDTO = null;

    mLog.debug("Start checkIfProjectAlreadyExists(String)");

    String lStrIdProject = null;/*from   w w w  . ja  va 2  s. c  o m*/
    File[] lFiles = new File(ContextManager.getInstance().getTempDirectoryPath()).listFiles();

    // search file with extensions h2.db
    boolean lBlnIsProjectValid = false;
    if (lFiles != null) {
        for (File lFile : lFiles) {
            if (lFile.isDirectory()) {
                lStrIdProject = lFile.getName();
                lBlnIsProjectValid = lStrIdProject
                        .matches("[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}");
                if (lBlnIsProjectValid) {
                    break;
                }
            }
        }
    }

    // check if project exists
    Projects lProjects = null;
    if (lBlnIsProjectValid) {
        SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance()
                .getSqlSessionFactoryBibisco();
        SqlSession lSqlSession = lSqlSessionFactory.openSession();
        try {
            ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
            lProjects = lProjectsMapper.selectByPrimaryKey(lStrIdProject);

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

    // create ImportProjectArchiveDTO
    lImportProjectArchiveDTO = new ImportProjectArchiveDTO();
    if (lBlnIsProjectValid) {
        lImportProjectArchiveDTO.setArchiveFileValid(true);
        lImportProjectArchiveDTO.setIdProject(lStrIdProject);
        if (lProjects != null) {
            lImportProjectArchiveDTO.setAlreadyPresent(true);
            lImportProjectArchiveDTO.setProjectName(lProjects.getName());
        } else {
            lImportProjectArchiveDTO.setAlreadyPresent(false);
        }
    } else {
        lImportProjectArchiveDTO.setArchiveFileValid(false);
    }

    mLog.debug("End checkIfProjectAlreadyExists(String): alreadyPresent "
            + lImportProjectArchiveDTO.isAlreadyPresent());

    return lImportProjectArchiveDTO;
}

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

License:GNU General Public License

public static void save(ProjectDTO pProjectDTO) {

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

    // validate preconditions
    Validate.notNull(pProjectDTO, "argument ProjectDTO cannot be null");

    // open session in bibisco db
    SqlSessionFactory lSqlSessionFactoryBibisco = SqlSessionFactoryManager.getInstance()
            .getSqlSessionFactoryBibisco();
    SqlSession lSqlSessionBibisco = lSqlSessionFactoryBibisco.openSession();

    // open session in project db
    SqlSessionFactory lSqlSessionFactoryProject = SqlSessionFactoryManager.getInstance()
            .getSqlSessionFactoryProject();
    SqlSession lSqlSessionProject = lSqlSessionFactoryProject.openSession();

    try {/*from w  w  w .j  a va  2  s  .  co m*/

        Projects lProjects = new Projects();
        lProjects.setIdProject(ContextManager.getInstance().getIdProject());
        lProjects.setName(pProjectDTO.getName());

        ProjectsMapper lProjectsMapper = lSqlSessionBibisco.getMapper(ProjectsMapper.class);
        lProjectsMapper.updateByPrimaryKey(lProjects);

        ProjectWithBLOBs lProjectWithBLOBs = new ProjectWithBLOBs();
        lProjectWithBLOBs.setIdProject(ContextManager.getInstance().getIdProject());
        lProjectWithBLOBs.setName(pProjectDTO.getName());

        ProjectMapper lProjectMapper = lSqlSessionProject.getMapper(ProjectMapper.class);
        lProjectMapper.updateByPrimaryKeySelective(lProjectWithBLOBs);

        lSqlSessionBibisco.commit();
        lSqlSessionProject.commit();

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

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

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

License:GNU General Public License

public static int deleteProjectsEntriesOnBibiscoDB() {

    int lIntResult = 0;

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

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

        // delete entry on bibisco db
        ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lIntResult = lProjectsMapper.deleteByExample(new ProjectsExample());

        lSqlSession.commit();

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

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

    return lIntResult;
}