Package javax.persistence

Examples of javax.persistence.EntityTransaction


  public Long addPrivateMessageObj(PrivateMessages privateMessage) {
    try {
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
     
      privateMessage = session.merge(privateMessage);
      Long privateMessageId = privateMessage.getPrivateMessageFolderId();
     
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return privateMessageId;     
    } catch (Exception e) {
      log.error("[addPrivateMessage]",e);
View Full Code Here


     
      String hql = "select c from PrivateMessages c ";
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
     
      List<PrivateMessages> privateMessages = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return privateMessages;
     
    } catch (Exception e) {
View Full Code Here

      String hql = "select c from PrivateMessages c " +
            "where c.privateMessageId = :privateMessageId ";
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("privateMessageId", privateMessageId);
     
      PrivateMessages privateMessage = null;
      try {
        privateMessage = (PrivateMessages) query.getSingleResult();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return privateMessage;
     
    } catch (Exception e) {
View Full Code Here

  public void updatePrivateMessages(PrivateMessages privateMessage) {
    try {
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
     
      if (privateMessage.getPrivateMessageFolderId() == null) {
        session.persist(privateMessage);
          } else {
            if (!session.contains(privateMessage)) {
              session.merge(privateMessage);
          }
      }
     
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
    } catch (Exception e) {
      log.error("[updatePrivateMessages]",e);
    }
View Full Code Here

        hql += " ) ";
      }

      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("toUserId", toUserId);
      if (search.length() != 0) {
        query.setParameter("search", StringUtils.lowerCase("%"+search+"%"));
      }
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return (Long)ll.get(0);
     
    } catch (Exception e) {
View Full Code Here

        hql += " DESC";
      }

      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("toUserId", toUserId);
      query.setParameter("isTrash", false);
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
      if (search.length() != 0) {
        query.setParameter("search", StringUtils.lowerCase("%"+search+"%"));
      }
      query.setFirstResult(start);
      query.setMaxResults(max);
      List<PrivateMessages> ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return ll; 
    } catch (Exception e) {
      log.error("[getPrivateMessagesByUser]",e);
View Full Code Here

        hql += " ) ";
      }

      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("toUserId", toUserId);
      query.setParameter("isTrash", false);
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
      if (search.length() != 0) {
        query.setParameter("search", StringUtils.lowerCase("%"+search+"%"));
      }
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return (Long)ll.get(0);
     
    } catch (Exception e) {
View Full Code Here

        hql += " DESC";
      }

      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      if (search.length() != 0) {
        query.setParameter("search", StringUtils.lowerCase("%"+search+"%"));
      }
      query.setParameter("user_id", user_id);
      query.setFirstResult(start);
      query.setMaxResults(max);
      List<PrivateMessages> ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return ll; 
    } catch (Exception e) {
      log.error("[getTrashPrivateMessagesByUser]",e);
View Full Code Here

        hql += " ) ";
      }
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("user_id", user_id);
      if (search.length() != 0) {
        query.setParameter("search", StringUtils.lowerCase("%"+search+"%"));
      }
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return (Long)ll.get(0);
     
    } catch (Exception e) {
View Full Code Here

        hql += " DESC";
      }

      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("toUserId", toUserId);
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
      if (search.length() != 0) {
        query.setParameter("search", StringUtils.lowerCase("%"+search+"%"));
      }
      query.setFirstResult(start);
      query.setMaxResults(max);
      List<PrivateMessages> ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
      return ll; 
    } catch (Exception e) {
      log.error("[getSendPrivateMessagesByUser]",e);
View Full Code Here

TOP

Related Classes of javax.persistence.EntityTransaction

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.