Example usage for org.hibernate.criterion DetachedCriteria getExecutableCriteria

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria getExecutableCriteria.

Prototype

public Criteria getExecutableCriteria(Session session)

Source Link

Document

Get an executable instance of Criteria to actually run the query.

Usage

From source file:com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public List<Tenant> getAllSubTenantList(ExecutionContext context, String parentTenantId, String text,
        int depth) {
    List subTenantList = new ArrayList();

    /* Retrieving parent tenant. */
    RepoTenant parent = getRepoTenant(parentTenantId, false);

    if (parent != null) {
        DetachedCriteria criteria = createSubTenantsCriteria(parent, text, depth);
        criteria.getExecutableCriteria(getSession()).setCacheable(true); // .setCacheMode(CacheMode.REFRESH);
        subTenantList.addAll(getHibernateTemplate().findByCriteria(criteria));
    }/*from   w  w w  .ja  va  2  s. c o m*/

    return toClientTenantList(subTenantList);
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

private DetachedCriteria createUserSearchCriteria(String username, RepoTenant tenant, boolean isCaseSensitive) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentUserClass());

    criteria.add(/* www  . j  ava 2 s  .  c  o m*/
            isCaseSensitive ? Restrictions.eq("username", username) : Restrictions.ilike("username", username));
    criteria.add(Restrictions.eq("tenant", tenant));
    criteria.getExecutableCriteria(getSession()).setCacheable(true);

    return criteria;
}

From source file:com.jdon.persistence.hibernate.HibernateTemplate.java

License:Apache License

public List findByCriteria(final DetachedCriteria criteria, final int firstResult, final int maxResults)
        throws Exception {

    return (List) doHibernate(new HibernateCallback() {
        public Object execute(Session session) throws HibernateException {
            Criteria executableCriteria = criteria.getExecutableCriteria(session);
            prepareCriteria(executableCriteria);
            if (firstResult >= 0) {
                executableCriteria.setFirstResult(firstResult);
            }/*from   www .  j  ava 2  s  .c o  m*/
            if (maxResults > 0) {
                executableCriteria.setMaxResults(maxResults);
            }
            return executableCriteria.list();
        }
    });
}

From source file:com.joey.Fujikom.common.persistence.BaseDao.java

License:Open Source License

/**
 * ?//ww  w  .  j  a  v  a2  s.  c o  m
 *
 * @param detachedCriteria
 * @param count
 * @return
 */
public List<T> findWithLimit(DetachedCriteria detachedCriteria, Integer startIndex, Integer pageSize) {
    if (startIndex != null) {
        detachedCriteria.getExecutableCriteria(getSession()).setFirstResult(startIndex);
    }
    detachedCriteria.getExecutableCriteria(getSession()).setMaxResults(pageSize);
    return find(detachedCriteria);
}

From source file:com.jsilvamoises.dao.HibernateDAO.java

@Override
public T getEntityByDetachedCriteria(DetachedCriteria detachedCriteria) {
    try {//from   ww w  .java  2  s.c  o m
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.getTransaction().begin();
        T entity = (T) detachedCriteria.getExecutableCriteria(session).uniqueResult();
        return entity;
    } catch (Exception e) {
        return null;
    } finally {
        session.getTransaction().commit();
    }
}

From source file:com.jsilvamoises.dao.HibernateDAO.java

@Override
public List<T> getEntitiesByDetachedCriteria(DetachedCriteria detachedCriteria) {
    try {/*from  www .  j a  va  2s .c  o  m*/
        session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.getTransaction().begin();
        return detachedCriteria.getExecutableCriteria(session).list();
    } catch (Exception e) {
        return null;
    } finally {
        session.getTransaction().commit();
    }
}

From source file:com.myapp.core.base.dao.impl.AbstractBaseDao.java

public Criteria findByDetachedCriteria(Class claz, DetachedCriteria dca) throws QueryException {
    dca.setResultTransformer(new MyResultTransFormer(claz));
    return dca.getExecutableCriteria(getCurrentSession());
}

From source file:com.myapp.core.base.dao.impl.AbstractBaseDao.java

/**
 * ? ?? ?//from  w  w  w .j a v a  2 s.c o  m
 * ? ???
 */

@Deprecated
public PageModel toPageDetachedCriteria(Class claz, DetachedCriteria dca, ProjectionList pList, Integer curPage,
        Integer pageSize) throws QueryException {
    Criteria query = dca.getExecutableCriteria(getCurrentSession());
    long rowCount = ((Long) query.setProjection(Projections.rowCount()).uniqueResult()).longValue();
    PageModel pm = new PageModel(curPage, pageSize, rowCount);
    if (pList != null) {
        query.setProjection(pList);
    } else {
        query.setProjection(null);
    }

    query.setResultTransformer(Transformers.aliasToBean(claz));
    query.setFirstResult(pm.getStartNum());
    query.setMaxResults(pageSize);
    pm.setDatas(query.list());
    return pm;
}

From source file:com.project.dao.Dao.java

@Override
public T getEntityByDetachedCriteria(DetachedCriteria criteria) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    try {/* w w w.  ja  va  2s.c om*/
        session.getTransaction().begin();
        T entity = (T) criteria.getExecutableCriteria(session).uniqueResult();
        return entity;
    } catch (Exception e) {
        return null;
    } finally {
        session.getTransaction().commit();
        if (session.isOpen()) {
            session.close();
        }
    }
}

From source file:com.project.dao.Dao.java

@Override
public List<T> getEntitiesByDetachetCriteria(DetachedCriteria criteria) {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    try {/*from w w w. j  a  v a 2s .c o  m*/
        session.getTransaction().begin();
        List<T> lista = (List<T>) session.createCriteria(classe).list();
        return criteria.getExecutableCriteria(session).list();
    } catch (Exception e) {
        return null;
    } finally {
        session.getTransaction().commit();
        if (session.isOpen()) {
            session.close();
        }
    }

}