Examples of javax.persistence.EntityManager.createQuery()

javax.persistence.EntityManager.createQuery()
Create an instance of Query for executing an EJB QL statement. @param ejbqlString an EJB QL query string @return the new query instance @throws IllegalStateException if this EntityManager has been closed @throws IllegalArgumentException if query string is not valid


      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+"%"));

View Full Code Here


      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);

View Full Code Here

      
      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();

View Full Code Here


      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+"%"));
      }

View Full Code Here

      
      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);

View Full Code Here

      
      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+"%"));

View Full Code Here

      
      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();

View Full Code Here

      //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();

View Full Code Here

      
      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!

View Full Code Here

      //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();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.