Examples of 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

Examples of javax.persistence.EntityTransaction

    try {
      
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Users> cq = cb.createQuery(Users.class);
      Root<Users> c = cq.from(Users.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      TypedQuery<Users> q = session.createQuery(cq);
      List<Users> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      
      return ll;        


    } catch (Exception ex2) {

View Full Code Here

Examples of javax.persistence.EntityTransaction

    try {
      
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Users> cq = cb.createQuery(Users.class);
      Root<Users> c = cq.from(Users.class);
      Predicate condition = cb.equal(c.get("deleted"), "false");
      cq.where(condition);
      TypedQuery<Users> q = session.createQuery(cq);
      List<Users> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      
      return ll;        


    } catch (Exception ex2) {

View Full Code Here

Examples of javax.persistence.EntityTransaction

      
      log.debug("Show HQL: "+hql);            
      
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      
      //log.debug("id: "+folderId);
      
      //query.setParameter("macomUserId", userId);
      //query.setParameter("messageFolder", folderId);
      //query
            
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      
      
      //log.error((Long)ll.get(0));
      Long i = (Long)ll.get(0);

View Full Code Here

Examples of javax.persistence.EntityTransaction

   */
  public boolean checkUserLogin(String DataValue) {
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery("select c from Users as c where c.login = :DataValue AND c.deleted <> :deleted");
      query.setParameter("DataValue", DataValue);
      query.setParameter("deleted", "true");
      int count = query.getResultList().size();


      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      if (count != 0) {
        return false;
      }      
    } catch (Exception ex2) {

View Full Code Here

Examples of javax.persistence.EntityTransaction

      String hql = "SELECT u FROM Users as u " +
          " where u.login = :login" +
          " AND u.deleted <> :deleted";
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("login", login);
      query.setParameter("deleted", "true");
      Users us = null;
      try {
        us = (Users) query.getSingleResult();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return us;      
    } catch (Exception e) {
      log.error("[getUserByAdressesId]",e);
    }

View Full Code Here

Examples of javax.persistence.EntityTransaction

      String hql = "SELECT u FROM Users as u " +
          " where u.adresses.adresses_id = :adresses_id" +
          " AND u.deleted <> :deleted";
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("adresses_id", adresses_id);
      query.setParameter("deleted", "true");
      Users us = null;
      try {
        us = (Users) query.getSingleResult();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return us;      
    } catch (Exception e) {
      log.error("[getUserByAdressesId]",e);
    }

View Full Code Here

Examples of javax.persistence.EntityTransaction

      String hql = "SELECT u FROM Users as u " +
          " where u.resethash = :resethash" +
          " AND u.deleted <> :deleted";
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("resethash", hash);
      query.setParameter("deleted", "true");
      Users us = null;
      try {
        us = (Users) query.getSingleResult();
        } catch (NoResultException ex) {
        }
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      if (us!=null) {
        return us;    
      } else {
        return new Long(-5);

View Full Code Here

Examples of javax.persistence.EntityTransaction

   */
  public Long addUserSalutation(String titelname, long fieldvalues_id) {
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Salutations ti = new Salutations();
      ti.setName(titelname);
      ti.setDeleted("false");
      ti.setFieldvalues_id(fieldvalues_id);
      ti.setStarttime(new Date());
      ti = session.merge(ti);
      Long salutations_id = ti.getSalutations_id();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      return salutations_id;
    } catch (Exception ex2) {
      log.error("[addUserSalutation]" ,ex2);
    }

View Full Code Here

Examples of javax.persistence.EntityTransaction

   */
  public List<Salutations> getUserSalutations(long language_id){
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      CriteriaBuilder cb = session.getCriteriaBuilder();
      CriteriaQuery<Salutations> cq = cb.createQuery(Salutations.class);
      Root<Salutations> from = cq.from(Salutations.class);
      CriteriaQuery<Salutations> select = cq.select(from);
      TypedQuery<Salutations> q = session.createQuery(select);
      List<Salutations> ll = q.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      for (Iterator it4 = ll.iterator(); it4.hasNext();) {
        Salutations ti = (Salutations) it4.next();
        ti.setLabel(Fieldmanagment.getInstance().getFieldByIdAndLanguage(ti.getFieldvalues_id(),language_id));
      }

View Full Code Here

Examples of javax.persistence.EntityTransaction

          ")";
      
      //get all users
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql); 
      query.setParameter("search", StringUtils.lowerCase(search));
      List ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
      log.info("selectMaxFromUsers"+(Long)ll.get(0));
      return (Long)ll.get(0);        
    } catch (Exception ex2) {
      log.error("[selectMaxFromUsers] ",ex2);

View Full Code Here

0 1 2 3 4 5

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.