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

License:GNU General Public License

private static void checkProjectVersionAndUpdateIfNecessary(String pStrIdProject) {

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

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from  www . ja  v a 2  s. co m*/
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        String lStrBibiscoVersion = lProjectMapper.getProjectVersion(pStrIdProject);

        // update version if necessary
        if (VersionManager.compare(lStrBibiscoVersion, "1.1.0") == -1) {
            update_to_1_1_0(lSqlSession, lProjectMapper);
        }
        if (VersionManager.compare(lStrBibiscoVersion, "1.1.2") == -1) {
            update_to_1_1_2(lSqlSession, lProjectMapper);
        }
        if (VersionManager.compare(lStrBibiscoVersion, "1.2.0") == -1) {
            update_to_1_2_0(lSqlSession, lProjectMapper);
        }

        // update project version
        ProjectWithBLOBs lProjectWithBLOBs = new ProjectWithBLOBs();
        lProjectWithBLOBs.setIdProject(pStrIdProject);
        lProjectWithBLOBs.setBibiscoVersion(VersionManager.getInstance().getVersion());
        lProjectMapper.updateByPrimaryKeySelective(lProjectWithBLOBs);

        lSqlSession.commit();

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

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

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

License:GNU General Public License

private void initPropertiesMap() {

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

    mMapProperties = new HashMap<String, String>();

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {// ww w  . jav a  2 s  .  co  m
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        List<Properties> lListProperties = lPropertiesMapper.selectByExample(new PropertiesExample());
        for (Properties lProperties : lListProperties) {
            mMapProperties.put(lProperties.getProperty(), lProperties.getValue());
        }

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

    mLog.debug("End initPropertiesMap()");
}

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

License:GNU General Public License

public void updateProperties(Map<String, String> pMapProperties) {

    mLog.debug("Start updateProperties(Map<String, String>)");

    Validate.notEmpty(pMapProperties, "Properties map cannot be empty");

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

    try {/* w w w .j  ava2  s .c o m*/

        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        for (String lStrProperty : pMapProperties.keySet()) {
            Properties lProperties = new Properties();
            lProperties.setProperty(lStrProperty);
            lProperties.setValue(pMapProperties.get(lStrProperty));
            lPropertiesMapper.updateByPrimaryKey(lProperties);
            mMapProperties.put(lStrProperty, pMapProperties.get(lStrProperty));
        }

        lSqlSession.commit();

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

    mLog.debug("End updateProperties()");
}

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

License:GNU General Public License

public void updateProperty(String pStrProperty, String pStrValue) {

    mLog.debug("Start updateProperty(", pStrProperty, ",", pStrValue, ")");

    Validate.notEmpty(pStrProperty, "Property cannot be empty");
    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from w  w  w  .  j a va2 s .co m

        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        Properties lProperties = new Properties();
        lProperties.setProperty(pStrProperty);
        lProperties.setValue(pStrValue);
        lPropertiesMapper.updateByPrimaryKey(lProperties);
        mMapProperties.put(pStrProperty, pStrValue);

        lSqlSession.commit();

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

    mLog.debug("End updateProperty(", pStrProperty, ",", pStrValue, ")");
}

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

License:GNU General Public License

public static RichTextEditorSettings load() {

    RichTextEditorSettings lRichTextEditorSettings;

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

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from  w w w  . j a va 2s. c  om*/
        lRichTextEditorSettings = new RichTextEditorSettings();
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);

        // font
        Properties lProperties = lPropertiesMapper.selectByPrimaryKey("font");
        lRichTextEditorSettings.setFont(lProperties.getValue());

        // font size
        lProperties = lPropertiesMapper.selectByPrimaryKey("font-size");
        lRichTextEditorSettings.setSize(lProperties.getValue());

        // font size
        lProperties = lPropertiesMapper.selectByPrimaryKey("spellCheckEnabled");
        lRichTextEditorSettings.setSpellCheckEnabled(Boolean.valueOf(lProperties.getValue()));

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

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

    return lRichTextEditorSettings;
}

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

License:GNU General Public License

public static void save(RichTextEditorSettings pRichTextEditorSettings) {

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

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/* w  ww. j  a  va 2s.co m*/
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);

        // font
        Properties lProperties = new Properties();
        lProperties.setProperty("font");
        lProperties.setValue(pRichTextEditorSettings.getFont());
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        // font size
        lProperties = new Properties();
        lProperties.setProperty("font-size");
        lProperties.setValue(pRichTextEditorSettings.getSize());
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        // spell check enabled
        lProperties = new Properties();
        lProperties.setProperty("spellCheckEnabled");
        lProperties.setValue(String.valueOf(pRichTextEditorSettings.isSpellCheckEnabled()));
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lSqlSession.commit();

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

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

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

License:GNU General Public License

public static SceneRevisionDTO load(Integer pIntIdScene) {

    SceneRevisionDTO lSceneRevisionDTO = null;

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

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from w w w  . j  a  v  a2 s  .  c o  m*/
        lSceneRevisionDTO = load(lSqlSession, pIntIdScene);

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

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

    return lSceneRevisionDTO;
}

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

License:GNU General Public License

public static SceneRevisionDTO createRevisionFromScratch(Integer pIntIdScene) {

    SceneRevisionDTO lSceneRevisionDTO = null;

    mLog.debug("Start createRevisionFromScratch(" + pIntIdScene, ")");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//www  .j  a  v  a2s .c om

        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);

        // deselect all revisions
        deselectAllRevisions(lSqlSession, pIntIdScene);

        // get actual max revision number
        Integer lIntMaxRevisionNumber = lSceneRevisionsMapper.selectNextRevisionNumber(pIntIdScene)
                .getRevisionNumber();

        // insert new scene revision
        SceneRevisions lSceneRevisions = new SceneRevisions();
        lSceneRevisions.setIdScene(pIntIdScene);
        lSceneRevisions.setRevisionNumber(lIntMaxRevisionNumber + 1);
        lSceneRevisions.setSelected("Y");
        lSceneRevisions.setWords(0);
        lSceneRevisions.setCharacters(0);
        lSceneRevisionsMapper.insert(lSceneRevisions);

        // reload scene with new revision
        lSceneRevisionDTO = load(lSqlSession, pIntIdScene);

        lSqlSession.commit();

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

    mLog.debug("End createRevisionFromScratch(" + pIntIdScene, ")");

    return lSceneRevisionDTO;
}

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

License:GNU General Public License

public static SceneRevisionDTO createRevisionFromActual(Integer pIntIdScene) {

    SceneRevisionDTO lSceneRevisionDTO = null;

    mLog.debug("Start createRevisionFromActual(" + pIntIdScene, ")");

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

        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);

        // get actual revision
        SceneRevisions lSceneRevisionsActual = lSceneRevisionsMapper.getSelectedByIdScene(pIntIdScene);

        // deselect all revisions
        deselectAllRevisions(lSqlSession, pIntIdScene);

        // get actual max revision number
        Integer lIntMaxRevisionNumber = lSceneRevisionsMapper.selectNextRevisionNumber(pIntIdScene)
                .getRevisionNumber();

        // insert new scene revision
        lSceneRevisionsActual.setIdSceneRevision(null);
        lSceneRevisionsActual.setRevisionNumber(lIntMaxRevisionNumber + 1);
        lSceneRevisionsActual.setSelected("Y");
        lSceneRevisionsMapper.insert(lSceneRevisionsActual);

        // reload scene with new revision
        lSceneRevisionDTO = load(lSqlSession, pIntIdScene);

        lSqlSession.commit();

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

    mLog.debug("End createRevisionFromActual(" + pIntIdScene, ")");

    return lSceneRevisionDTO;
}

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

License:GNU General Public License

public static SceneRevisionDTO deleteActualRevision(Integer pIntIdScene) {

    SceneRevisionDTO lSceneRevisionDTO = null;

    mLog.debug("Start deleteActualRevision(" + pIntIdScene, ")");

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

        // load scene revision
        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);
        SceneRevisions lSceneRevisionsSelected = lSceneRevisionsMapper.getSelectedByIdScene(pIntIdScene);

        // get position of revision to delete
        Integer lIntPositionRevisionToDelete = lSceneRevisionsSelected.getRevisionNumber();

        // delete actual revision
        lSceneRevisionsMapper.deleteByPrimaryKey(lSceneRevisionsSelected.getIdSceneRevision());

        // shift down the revision number 
        lSceneRevisionsMapper.shiftDown(lIntPositionRevisionToDelete);

        // get actual max revision number
        Integer lIntMaxRevisionNumber = lSceneRevisionsMapper.selectNextRevisionNumber(pIntIdScene)
                .getRevisionNumber();

        // select revision with max revision number
        SceneRevisions lSceneRevisions = new SceneRevisions();
        lSceneRevisions.setSelected("Y");

        SceneRevisionsExample lSceneRevisionsExample = new SceneRevisionsExample();
        lSceneRevisionsExample.createCriteria().andIdSceneEqualTo(pIntIdScene)
                .andRevisionNumberEqualTo(lIntMaxRevisionNumber);

        lSceneRevisionsMapper.updateByExampleSelective(lSceneRevisions, lSceneRevisionsExample);

        // reload scene with new revision
        lSceneRevisionDTO = load(lSqlSession, pIntIdScene);

        lSqlSession.commit();

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

    mLog.debug("End deleteActualRevision(" + pIntIdScene, ")");

    return lSceneRevisionDTO;
}