Examples of javax.persistence.EntityTransaction

javax.persistence.EntityTransaction
The EntityTransaction interface is used to control resource transactions on resource-local entity managers. The EntityManager.getTransaction() method returns the EntityTransaction interface. @author Emmanuel Bernard

        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

      
      log.debug("privateMessageFolderId "+privateMessageFolderId);
      
      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) {

View Full Code Here

            "SET c.isTrash = :isTrash,c.privateMessageFolderId = :privateMessageFolderId " +
            "where c.privateMessageId IN (:privateMessageIds) ";
      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql); 
      query.setParameter("isTrash", isTrash);
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
      query.setParameter("privateMessageIds", privateMessageIds);
      int updatedEntities = query.executeUpdate();
      
      //Refresh the Entities in the Cache as Hibernate will not do it!
      for (Long privateMessageId : privateMessageIds) {
        String hqlSel = "select c from PrivateMessages c " +
                "where c.privateMessageId = :privateMessageId ";
  
        Query querySel = session.createQuery(hqlSel); 
        querySel.setParameter("privateMessageId", privateMessageId);
        
        PrivateMessages privateMessages = null;
        try {
          privateMessages = (PrivateMessages) querySel.getSingleResult();
          } catch (NoResultException ex) {
          }
        
        if (privateMessages != null) {
          session.refresh(privateMessages);
        }
      }
      
      
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);

View Full Code Here

            "SET c.isRead = :isRead " +
            "where c.privateMessageId IN (:privateMessageIds) ";
      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql); 
      query.setParameter("isRead", isRead);
      query.setParameter("privateMessageIds", privateMessageIds);
      int updatedEntities = query.executeUpdate();
      
      //Refresh the Entities in the Cache as Hibernate will not do it!
      for (Long privateMessageId : privateMessageIds) {
        String hqlSel = "select c from PrivateMessages c " +
                "where c.privateMessageId = :privateMessageId ";
  
        Query querySel = session.createQuery(hqlSel); 
        querySel.setParameter("privateMessageId", privateMessageId);
        
        PrivateMessages privateMessages = null;
        try {
          privateMessages = (PrivateMessages) querySel.getSingleResult();
          } catch (NoResultException ex) {
          }
        
        if (privateMessages != null) {
          session.refresh(privateMessages);
        }
      }
      
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return updatedEntities;
    } catch (Exception e) {
      log.error("[updatePrivateMessagesReadStatus]",e);
    }

View Full Code Here

            "SET c.privateMessageFolderId = :privateMessageFolderId, c.isTrash = false " +
            "where c.privateMessageId IN (:privateMessageIds) ";
      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql); 
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
      query.setParameter("privateMessageIds", privateMessageIds);
      int updatedEntities = query.executeUpdate();
      
      //Refresh the Entities in the Cache as Hibernate will not do it!
      for (Long privateMessageId : privateMessageIds) {
        String hqlSel = "select c from PrivateMessages c " +
                "where c.privateMessageId = :privateMessageId ";
  
        Query querySel = session.createQuery(hqlSel); 
        querySel.setParameter("privateMessageId", privateMessageId);
        
        PrivateMessages privateMessages = null;
        try {
          privateMessages = (PrivateMessages) querySel.getSingleResult();
          } catch (NoResultException ex) {
          }
        
        if (privateMessages != null) {
          session.refresh(privateMessages);
        }
      }
      
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return updatedEntities;
    } catch (Exception e) {
      log.error("[updatePrivateMessagesReadStatus]",e);
    }

View Full Code Here

      String hql = "DELETE PrivateMessages c " +
            "where c.privateMessageId IN (:privateMessageIds) ";
      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql); 
      query.setParameter("privateMessageIds", privateMessageIds);
      int updatedEntities = query.executeUpdate();
      
//      //Refresh the Entities in the Cache as Hibernate will not do it!
//      for (Long privateMessageId : privateMessageIds) {
//        String hqlSel = "select c from PrivateMessages c " +
//                "where c.privateMessageId = :privateMessageId ";
//  
//        Query querySel = session.createQuery(hqlSel); 
//        querySel.setParameter("privateMessageId", privateMessageId);
//        
//        PrivateMessages privateMessages = (PrivateMessages) querySel.uniqueResult();
//        
//        if (privateMessages != null) {
//          session.refresh(privateMessages);
//        }
//      }
      
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return updatedEntities;
    } catch (Exception e) {
      log.error("[updatePrivateMessagesReadStatus]",e);
    }

View Full Code Here

            "where c.room.rooms_id = :roomId ";
      
      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql); 
      query.setParameter("roomId", roomId);
      List<PrivateMessages> ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      
      return ll;  
    } catch (Exception e) {
      log.error("[getPrivateMessagesByRoom]",e);

View Full Code Here

      userContact.setPending(pending);
      userContact.setHash(hash);
      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      
      userContact = session.merge(userContact);
      Long userContactId = userContact.getUserContactId();
      
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      
      return userContactId;      
    } catch (Exception e) {
      log.error("[addUserContact]",e);

View Full Code Here

      
      userContact.setInserted(new Date());
      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      
      userContact = session.merge(userContact);
      Long userContactId = userContact.getUserContactId();
      
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      
      return userContactId;      
    } catch (Exception e) {
      log.error("[addUserContact]",e);

View Full Code Here

      
      String hql = "delete from UserContacts where userContactId = :userContactId";
      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      
      Query query = session.createQuery(hql);
          query.setParameter("userContactId",userContactId);
          int rowCount = query.executeUpdate();
      
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      
      return rowCount;      
    } catch (Exception e) {
      log.error("[deleteUserContact]",e);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of javax.persistence.EntityTransaction

br.com.caelum.vraptor.jpa.JPATransactionInterceptor

br.com.caelum.vraptor.util.jpa.JPATransactionInterceptor

br.gov.frameworkdemoiselle.transaction.JPATransaction

cave.nice.testMessage.data.DataManager

com.adaptrex.core.persistence.jpa.JPAModelInstance

com.adaptrex.core.persistence.jpa.JpaPersistence

com.appspot.finajjarane.framework.generic.GenericDaoImpl

com.darkhonor.rage.libs.dataaccess.CategoryDAO

com.darkhonor.rage.libs.dataaccess.CourseDAO

com.darkhonor.rage.libs.dataaccess.GradedEventDAO

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.