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

Introduction

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

Prototype

void rollback();

Source Link

Document

Discards pending batch statements and rolls database connection back.

Usage

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static List<AnimeNameLookup> getLookupNames(int animeId) {
    SqlSession session = null;

    try {//from   w  w w. j  a  v  a  2  s .c om
        session = AnimeDataManager.getInstance().openSession();
        AnimeNameLookupMapper mapper = session.getMapper(AnimeNameLookupMapper.class);

        return mapper.selectAnimeNames(animeId);
    } catch (Exception e) {
        session.rollback();
        log.error("Error getting anime.", e);
        return null;
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static void saveEpisode(AnimeEpisode episode) {
    SqlSession session = null;

    try {//w ww.  j a  va2  s  . c  o m
        session = AnimeDataManager.getInstance().openSession();
        AnimeMapper mapper = session.getMapper(AnimeMapper.class);

        int rows = mapper.updateEpisode(episode);
        if (rows == 0) {
            mapper.insertEpisode(episode);
        }

        session.commit();
    } catch (Exception e) {
        session.rollback();
        log.error("Error saving anime.", e);
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static AnimeEpisode getAnimeEpisode(int episodeId) {
    SqlSession session = null;

    try {/* w  ww  . ja v a  2 s.c o  m*/
        session = AnimeDataManager.getInstance().openSession();
        AnimeMapper mapper = session.getMapper(AnimeMapper.class);

        return mapper.selectEpisode(episodeId);
    } catch (Exception e) {
        session.rollback();
        log.error("Error getting anime.", e);
        return null;
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static AnimeEpisode findAnimeEpisode(int animeId, int episodeNumber) {
    SqlSession session = null;

    try {//w ww  .ja  v a  2 s .  com
        session = AnimeDataManager.getInstance().openSession();
        AnimeMapper mapper = session.getMapper(AnimeMapper.class);

        return mapper.findEpisode(animeId, episodeNumber);
    } catch (Exception e) {
        session.rollback();
        log.error("Error getting anime.", e);
        return null;
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static AnimeEpisode findAnimeEpisode(int animeId, String episodeNumber) {
    SqlSession session = null;

    try {/*from w  ww . ja  va2s. c o m*/
        session = AnimeDataManager.getInstance().openSession();
        AnimeMapper mapper = session.getMapper(AnimeMapper.class);

        return mapper.findEpisodeFullEpisodeNumber(animeId, episodeNumber);
    } catch (Exception e) {
        session.rollback();
        log.error("Error getting anime.", e);
        return null;
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static void saveGroup(AnimeGroup group) {
    SqlSession session = null;

    try {//from ww  w  .  j av  a 2s  .  c  o m
        session = AnimeDataManager.getInstance().openSession();
        AnimeMapper mapper = session.getMapper(AnimeMapper.class);

        int rows = mapper.updateGroup(group);
        if (rows == 0) {
            mapper.insertGroup(group);
        }

        session.commit();
    } catch (Exception e) {
        session.rollback();
        log.error("Error saving group.", e);
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static AnimeGroup getAnimeGroup(int groupId) {
    SqlSession session = null;

    try {/* www .  j  av a  2  s.  c om*/
        session = AnimeDataManager.getInstance().openSession();
        AnimeMapper mapper = session.getMapper(AnimeMapper.class);

        return mapper.selectGroup(groupId);
    } catch (Exception e) {
        session.rollback();
        log.error("Error getting anime.", e);
        return null;
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static void saveFile(AnimeFile file) {
    SqlSession session = null;

    try {//from   w ww . j a v a  2 s  .  c o  m
        session = AnimeDataManager.getInstance().openSession();
        AnimeMapper mapper = session.getMapper(AnimeMapper.class);

        file.setCurrentSaveRevision(AnimeFile.SAVE_REVISION);

        int rows = mapper.updateFile(file);
        if (rows == 0) {
            mapper.insertFile(file);
        }

        session.commit();

        addToAnimeFileCache(file);

    } catch (Exception e) {
        session.rollback();
        log.error("Error saving file.", e);
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static AnimeFile getAnimeFile(int fileId) {
    AnimeFile file = fileCache.get(fileId);
    if (file != null) {
        return file;
    }/*from w w  w .j a  v a  2s  .c om*/

    SqlSession session = null;

    try {
        session = AnimeDataManager.getInstance().openSession();
        AnimeMapper mapper = session.getMapper(AnimeMapper.class);

        file = mapper.selectFile(fileId);
        if (file != null) {
            addToAnimeFileCache(file);
        }
        return file;
    } catch (Exception e) {
        log.error("Error getting file.", e);
        session.rollback();
        return null;
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:net.landora.animeinfo.data.AnimeDBA.java

License:Open Source License

public static AnimeFile getAnimeFile(String ed2k, long size) {
    Touple<String, Long> info = new Touple<String, Long>(ed2k, size);

    AnimeFile file = fileED2KCache.get(info);
    if (file != null) {
        return file;
    }/*from  w  w  w  . ja  va 2  s .  c  om*/

    SqlSession session = null;

    try {
        session = AnimeDataManager.getInstance().openSession();
        AnimeMapper mapper = session.getMapper(AnimeMapper.class);

        file = mapper.selectFileByED2K(ed2k, size);
        if (file != null) {
            addToAnimeFileCache(file);
        }
        return file;
    } catch (Exception e) {
        session.rollback();
        log.error("Error getting file.", e);
        return null;
    } finally {
        if (session != null) {
            session.close();
        }
    }
}