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

License:GNU General Public License

public static void disableTip(String pStrTipCode) {

    mLog.debug("Start disableTip(" + pStrTipCode + ")");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from   w  w w  . java  2s.  c o m
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);

        Properties lProperties = new Properties();
        lProperties.setProperty(pStrTipCode);
        lProperties.setValue("false");
        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 disableTip(" + pStrTipCode + ")");
}

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

License:GNU General Public License

private String initVersion() {

    String lStrVersion = null;//from w  w w . j a  v  a  2  s.  com

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

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

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

        if (lProperties != null) {
            lStrVersion = lProperties.getValue();
        }

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

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

    return lStrVersion;
}

From source file:com.bibisco.rcp.Application.java

License:GNU General Public License

private boolean anotherBibiscoInstanceIsRunning() {

    boolean lBlnResult = false;

    try {/*from w w  w  . j a va 2 s  . c o m*/
        SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance()
                .getSqlSessionFactoryBibisco();
        SqlSession lSqlSession = lSqlSessionFactory.openSession();
        lSqlSession.close();
    } catch (Throwable t) {
        mLog.error(t);
        lBlnResult = true;
    }

    return lBlnResult;
}

From source file:com.bibisco.test.ImageManagerTest.java

License:GNU General Public License

@Before
@After//from  www.java2  s . c  o m
public void init() throws ConfigurationException, IOException {

    SqlSessionFactory lSqlSessionFactory = AllTests.getBibiscoSqlSessionFactory();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);
        Properties lProperties = new Properties();
        lProperties.setProperty("projectsDirectory");
        lProperties.setValue("C:/temp/bibisco/projects");
        lPropertiesMapper.updateByPrimaryKey(lProperties);
        lSqlSession.commit();
    } catch (Throwable t) {
        lSqlSession.rollback();
    } finally {
        lSqlSession.close();
    }

    PropertiesManager.getInstance().reload();
}

From source file:com.bibisco.test.ImageManagerTest.java

License:GNU General Public License

@Test
public void testInsertImage() throws IOException {

    ContextManager.getInstance().setIdProject(AllTests.TEST_PROJECT_ID);

    File lFile = new File(AllTests.getImage1FilePath());
    ImageDTO lImageDTO = new ImageDTO();
    lImageDTO.setInputStream(new FileInputStream(lFile));
    lImageDTO.setSourceFileName(lFile.getName());
    lImageDTO.setDescription("description");
    lImageDTO.setElementType(ElementType.CHARACTERS);
    lImageDTO.setIdElement(67);/* w  w  w .  ja v  a2 s .c o m*/
    lImageDTO = ImageManager.insert(lImageDTO);

    File lFileInserted = new File(AllTests.BIBISCO_INTERNAL_PROJECTS_DIR + AllTests.getPathSeparator()
            + AllTests.TEST_PROJECT_ID + AllTests.getPathSeparator() + lImageDTO.getTargetFileName());
    Assert.assertTrue(lFileInserted.exists());

    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {
        ImagesMapper lImagesMapper = lSqlSession.getMapper(ImagesMapper.class);
        Images lImages = lImagesMapper.selectByPrimaryKey(new Long(lImageDTO.getIdImage()));
        Assert.assertEquals("description", lImages.getDescription());
        Assert.assertEquals(ElementType.CHARACTERS.getValue(), lImages.getElementType());
        Assert.assertEquals(lImageDTO.getTargetFileName(), lImages.getFileName());
        Assert.assertEquals(new Integer(67), lImages.getIdElement());
        Assert.assertEquals(lImageDTO.getIdImage(), new Integer(lImages.getIdImage().intValue()));

    } finally {
        lSqlSession.close();
    }

    AllTests.cleanTestProjectDB();
    FileUtils.forceDelete(lFileInserted);
}

From source file:com.bibisco.test.ImageManagerTest.java

License:GNU General Public License

@Test
public void testDeleteWithInexistentIdImage() {
    ContextManager.getInstance().setIdProject(AllTests.TEST_PROJECT_ID);
    ImageManager.delete(10);/* w ww .  ja  v a  2  s .co  m*/

    List<Images> lListImages;
    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {
        ImagesMapper lImagesMapper = lSqlSession.getMapper(ImagesMapper.class);
        lListImages = lImagesMapper.selectByExample(new ImagesExample());
    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(9, lListImages.size());
}

From source file:com.bibisco.test.ImageManagerTest.java

License:GNU General Public License

@Test
public void testDelete() throws IOException {

    ContextManager.getInstance().setIdProject(AllTests.TEST_PROJECT_ID);

    ImageManager.delete(2);/*from w  w w. j  ava2s  .  c  om*/

    List<Images> lListImages;

    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {
        ImagesMapper lImagesMapper = lSqlSession.getMapper(ImagesMapper.class);
        ImagesExample lImagesExample = new ImagesExample();
        lImagesExample.createCriteria().andIdElementEqualTo(new Integer(67))
                .andElementTypeEqualTo(ElementType.CHARACTERS.getValue());
        lListImages = lImagesMapper.selectByExample(lImagesExample);
    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(2, lListImages.size());
    Assert.assertEquals("Image1", lListImages.get(0).getDescription());
    Assert.assertEquals(ElementType.CHARACTERS.getValue(), lListImages.get(0).getElementType());
    Assert.assertEquals(AllTests.TEST_PROJECT_IMAGE_1, lListImages.get(0).getFileName());
    Assert.assertEquals(new Integer(67), lListImages.get(0).getIdElement());
    Assert.assertEquals(new Long(1), lListImages.get(0).getIdImage());
    Assert.assertEquals("Image3", lListImages.get(1).getDescription());
    Assert.assertEquals(ElementType.CHARACTERS.getValue(), lListImages.get(1).getElementType());
    Assert.assertEquals(AllTests.TEST_PROJECT_IMAGE_3, lListImages.get(1).getFileName());
    Assert.assertEquals(new Integer(67), lListImages.get(1).getIdElement());
    Assert.assertEquals(new Long(3), lListImages.get(1).getIdImage());

    AllTests.cleanTestProjectDB();
}

From source file:com.bibisco.test.ImageManagerTest.java

License:GNU General Public License

@Test(expected = IllegalArgumentException.class)
@edu.umd.cs.findbugs.annotations.SuppressWarnings("NP_NULL_PARAM_DEREF_NONVIRTUAL")
public void testDeleteImagesByElementLocationWithNullIdElement() {
    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    ImageManager.deleteImagesByElement(lSqlSession, null, ElementType.LOCATIONS);
    lSqlSession.close();
}

From source file:com.bibisco.test.ImageManagerTest.java

License:GNU General Public License

@Test(expected = IllegalArgumentException.class)
@edu.umd.cs.findbugs.annotations.SuppressWarnings("NP_NULL_PARAM_DEREF_NONVIRTUAL")
public void testDeleteImagesByElementLocationWithNullElementType() {
    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    ImageManager.deleteImagesByElement(lSqlSession, new Integer(71), null);
    lSqlSession.close();
}

From source file:com.bibisco.test.ImageManagerTest.java

License:GNU General Public License

@Test
public void testDeleteImagesByElementLocation() throws IOException {
    ContextManager.getInstance().setIdProject(AllTests.TEST_PROJECT_ID);
    SqlSessionFactory lSqlSessionFactory = AllTests.getProjectSqlSessionFactoryById(AllTests.TEST_PROJECT_ID);
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    ImageManager.deleteImagesByElement(lSqlSession, new Integer(71), ElementType.LOCATIONS);
    lSqlSession.commit();/* w  w w  .  ja v  a  2  s  .co  m*/
    lSqlSession.close();

    List<Images> lListImages;
    lSqlSession = lSqlSessionFactory.openSession();
    try {
        ImagesMapper lImagesMapper = lSqlSession.getMapper(ImagesMapper.class);
        ImagesExample lImagesExample = new ImagesExample();
        lImagesExample.createCriteria().andIdElementEqualTo(new Integer(71))
                .andElementTypeEqualTo(ElementType.LOCATIONS.getValue());
        lListImages = lImagesMapper.selectByExample(lImagesExample);
    } finally {
        lSqlSession.close();
    }

    Assert.assertEquals(0, lListImages.size());
    String lStrImagesFolder = AllTests.BIBISCO_INTERNAL_PROJECTS_DIR + AllTests.getPathSeparator()
            + AllTests.TEST_PROJECT_ID + AllTests.getPathSeparator();

    Assert.assertTrue((new File(lStrImagesFolder + AllTests.TEST_PROJECT_IMAGE_1)).exists());
    Assert.assertTrue((new File(lStrImagesFolder + AllTests.TEST_PROJECT_IMAGE_2)).exists());
    Assert.assertTrue((new File(lStrImagesFolder + AllTests.TEST_PROJECT_IMAGE_3)).exists());
    Assert.assertTrue((new File(lStrImagesFolder + AllTests.TEST_PROJECT_IMAGE_4)).exists());
    Assert.assertTrue((new File(lStrImagesFolder + AllTests.TEST_PROJECT_IMAGE_5)).exists());
    Assert.assertTrue((new File(lStrImagesFolder + AllTests.TEST_PROJECT_IMAGE_6)).exists());
    Assert.assertFalse((new File(lStrImagesFolder + AllTests.TEST_PROJECT_IMAGE_7)).exists());
    Assert.assertFalse((new File(lStrImagesFolder + AllTests.TEST_PROJECT_IMAGE_8)).exists());
    Assert.assertFalse((new File(lStrImagesFolder + AllTests.TEST_PROJECT_IMAGE_9)).exists());

    AllTests.cleanTestProjectDB();
}