Example usage for org.apache.ibatis.session SqlSession 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.ehensin.paypal.infra.db.test.DBRepositoryTest.java

License:Apache License

@Test
public void testHash() {
    DBRepositoryBuilder builder = new DBRepositoryBuilder();
    DBRepository repository = builder.build(new String[] { "com.ehensin.paypal.account.service" });
    SplitFactor factor = new SplitFactor(SplitAlg.Hash, 1);
    SqlSessionFactory factory = repository.getSessionFactory("account", factor, true);
    SqlSession session = factory.openSession();

    session.close();

}

From source file:com.eincs.athens.olympus.service.AccessTokenService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {

    final String email = request.getParams().getParam("email", String.class);
    final String nickname = request.getParams().getParam("nickname", String.class);
    final String tag = request.getParams().getParam("tag", String.class);
    final String sessionUuid = UUID.randomUUID().toString();

    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();
    final JSONTokenFactory tokenFactory = new JSONTokenFactory();
    try {//from  w  w  w  . ja  v  a  2  s .  com

        JSONToken accessToken = Tokens.createAccessToken(email, sessionUuid);
        JSONToken registrationToken = Tokens.createRegistrationToken(email, nickname, sessionUuid, tag);

        GmailMailSender mailSender = GmailMailSender.getInstance();
        mailSender.sendMail("athens.team.2011@gmail.com", email, "Please Confirm Registration to Olympus",
                createMailContent(ChannelBuffers.copiedBuffer(tokenFactory.toBytes(registrationToken))
                        .toString(CharsetUtil.UTF_8)));

        String responseString = DataUtils.toResponseString(
                ChannelBuffers.copiedBuffer(tokenFactory.toBytes(accessToken)).toString(CharsetUtil.UTF_8));
        response.setContentType(PanteonContentType.TEXT_PLAIN);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
        return;

    } finally {
        session.close();
    }

}

From source file:com.eincs.athens.olympus.service.CheckService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {
    final String accessTokenString = request.getHeaders().get(HeaderNames.ACCESS_TOKEN);

    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();
    final JSONTokenFactory tokenFactory = new JSONTokenFactory();

    try {//from  w w  w .  j  a v  a  2 s  . c  o  m
        final OlympusMapper mapper = session.getMapper(OlympusMapper.class);
        final JSONToken accessToken = tokenFactory.fromBytes(accessTokenString.getBytes());

        if (!Tokens.verifyToken(accessToken)) {
            String responseString = DataUtils.toResponseString(false);
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        String email = accessToken.getContent().getString(TokenNames.EMAIL);
        String sessionUuid = accessToken.getContent().getString(TokenNames.SESSION_UUID);

        User user = mapper.getUserByEmail(User.createByEmail(email));
        if (user == null) {
            String responseString = DataUtils.toResponseString(false);
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        Session userSession = mapper.getSessionByUUID(Session.create(sessionUuid));
        if (userSession == null) {
            String responseString = DataUtils.toResponseString(false);
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }
        session.commit();

        String responseString = DataUtils.toResponseString(true);
        response.setContentType(PanteonContentType.TEXT_PLAIN);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));

    } finally {
        session.close();
    }
}

From source file:com.eincs.athens.olympus.service.ConfirmService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {

    final String tokenString = request.getParams().getParam("token", String.class);

    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();
    final JSONTokenFactory tokenFactory = new JSONTokenFactory();
    try {//from www .j a  v a  2 s . co m
        if (tokenString == null) {
            String responseString = DataUtils.toResponseStringError("invalid access");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        JSONToken registrationToken = tokenFactory.fromBytes(tokenString.getBytes());
        if (!Tokens.verifyToken(registrationToken)) {
            String responseString = DataUtils.toResponseStringError("invalid token");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        String email = registrationToken.getContent().getString(TokenNames.EMAIL);
        String nickname = registrationToken.getContent().getString(TokenNames.NICKNAME);
        String sessionUuid = registrationToken.getContent().getString(TokenNames.SESSION_UUID);
        String sessionTag = registrationToken.getContent().getString(TokenNames.SESSION_TAG);

        final OlympusMapper mapper = session.getMapper(OlympusMapper.class);
        User user = mapper.getUserByEmail(User.createByEmail(email));
        if (user == null) {
            mapper.insertUser(User.create(email, nickname));
            user = mapper.getUserByEmail(User.createByEmail(email));
        }
        mapper.insertSession(Session.create(user.getId(), sessionUuid, sessionTag));
        session.commit();

        String responseString = DataUtils.toResponseString(true);
        response.setContentType(PanteonContentType.TEXT_PLAIN);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
        return;

    } finally {
        session.close();
    }
}

From source file:com.eincs.athens.olympus.service.PostDeleteService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {
    final Integer postId = request.getParams().getParam("id", Integer.class);
    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();

    try {/*from ww w .jav  a2s . co  m*/
        final OlympusMapper mapper = session.getMapper(OlympusMapper.class);
        final int result = mapper.deletePost(Post.create(postId));
        session.commit();

        final String responseString = DataUtils.toResponseString(result > 0);
        response.setContentType(PanteonContentType.TEXT_PLAIN);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));

    } finally {
        session.close();
    }
}

From source file:com.eincs.athens.olympus.service.PostWriteService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {
    final String content = request.getParams().getParam("content", String.class);
    final String accessTokenString = request.getHeaders().get(HeaderNames.ACCESS_TOKEN);

    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();
    final JSONTokenFactory tokenFactory = new JSONTokenFactory();

    try {/*from   w ww  .  j  a  v  a  2 s  .  com*/
        final OlympusMapper mapper = session.getMapper(OlympusMapper.class);
        final JSONToken accessToken = tokenFactory.fromBytes(accessTokenString.getBytes());

        if (!Tokens.verifyToken(accessToken)) {
            String responseString = DataUtils.toResponseStringError("permission denied. invalid token.");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        String email = accessToken.getContent().getString(TokenNames.EMAIL);
        String sessionUuid = accessToken.getContent().getString(TokenNames.SESSION_UUID);

        User user = mapper.getUserByEmail(User.createByEmail(email));
        if (user == null) {
            String responseString = DataUtils.toResponseStringError("permission denied. no such user.");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }
        Session userSession = mapper.getSessionByUUID(Session.create(sessionUuid));
        if (userSession == null) {
            String responseString = DataUtils.toResponseStringError("permission denied. no such session.");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        final int result = mapper.insertPost(Post.create(user.getId(), content));
        session.commit();

        final String responseString = DataUtils.toResponseString(result > 0);
        response.setContentType(PanteonContentType.TEXT_PLAIN);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));

    } finally {
        session.close();
    }
}

From source file:com.eincs.athens.olympus.service.TimelineService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {

    final Integer after = request.getParams().getParam("after", Integer.class);
    final Integer before = request.getParams().getParam("before", Integer.class);
    final Range range = Range.createRange(after, before, 64);

    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();

    try {/*from w w  w  . j ava  2s.c o  m*/

        final OlympusMapper mapper = session.getMapper(OlympusMapper.class);
        final List<Post> result = mapper.getPosts(range);
        for (Post post : result) {
            Integer userId = post.getUserId();
            if (post.getUser() == null) {
                logger.info("new post!");
                post.setUser(mapper.getUser(User.createById(userId)));
            }
        }
        final String responseString = DataUtils.toResponseString(result);
        response.setContentType(PanteonContentType.TEXT_HTML);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));

    } finally {
        session.close();
    }
}

From source file:com.eldar.daos.mybatis.MyBatisContainerDao.java

License:Open Source License

/**
 * @see IContainerDao// www  .j  a  v a2s  . c  o m
 */
@Override
public ListPage<Container> list(long start, long size) {
    SqlSession session = sqlSessionFactory.openSession();
    try {
        ListPage<Container> page = new ListPage<>(start, size);
        page.setItems(containerMapper.list(page));
        return page;
    } finally {
        session.close();
    }
}

From source file:com.eldar.daos.mybatis.MyBatisContainerDao.java

License:Open Source License

@Override
public void save(Container container) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from w  ww.  ja va 2 s . c  o m
        DateTime current = DateTime.now(DateTimeZone.UTC);
        container.setModifiedDate(current);
        for (CssClass cssClass : container.getCssClassList()) {
            cssClassDao.save(cssClass);
        }
        if (container.getId() > 0) {
            containerMapper.update(container);
        } else {
            container.setCreatedDate(current);
            containerMapper.insert(container);
        }
        for (CssClass cssClass : container.getCssClassList()) {
            cssClassDao.saveContainerRel(cssClass, container);
        }

    } catch (Exception ex) {
        logger.error("Error saving container", ex);
    } finally {
        session.commit();
        session.close();
    }
}

From source file:com.eldar.daos.mybatis.MyBatisContainerDao.java

License:Open Source License

@Override
public Container get(long id) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//w  w w. ja  v  a2  s .c  om
        return containerMapper.select(id);
    } finally {
        session.close();
    }
}