Examples with Query org.hibernate.query.Query used on opensource projects

Example 36 with Query

use of org.hibernate.query.Query in project querydsl by querydsl.

the class AbstractHibernateQuery method fetchCount.

@Override
public long fetchCount() {
    QueryModifiers modifiers = getMetadata().getModifiers();
    try {
        Query query = createQuery(modifiers, true);
        Long rv = (Long) query.uniqueResult();
        if (rv != null) {
            return rv;
        } else {
            throw new QueryException("Query returned null");
        }
    } finally {
        reset();
    }
}

Example 37 with Query

use of org.hibernate.query.Query in project querydsl by querydsl.

the class AbstractHibernateQuery method iterate.

/**
 * Return the query results as an {@code Iterator}. If the query
 * contains multiple results pre row, the results are returned in
 * an instance of {@code Object[]}.<br>
 * <br>
 * Entities returned as results are initialized on demand. The first
 * SQL query returns identifiers only.<br>
 */
@Override
public CloseableIterator<T> iterate() {
    try {
        Query query = createQuery();
        ScrollableResults results = query.scroll(ScrollMode.FORWARD_ONLY);
        return new ScrollableResultsIterator<T>(results);
    } finally {
        reset();
    }
}

Example 38 with Query

use of org.hibernate.query.Query in project querydsl by querydsl.

the class AbstractHibernateQuery method fetchResults.

@Override
public QueryResults<T> fetchResults() {
    try {
        Query countQuery = createQuery(null, true);
        long total = (Long) countQuery.uniqueResult();
        if (total > 0) {
            QueryModifiers modifiers = getMetadata().getModifiers();
            Query query = createQuery(modifiers, false);
            @SuppressWarnings("unchecked") List<T> list = query.list();
            return new QueryResults<T>(list, modifiers, total);
        } else {
            return QueryResults.emptyResults();
        }
    } finally {
        reset();
    }
}

Example 39 with Query

use of org.hibernate.query.Query in project querydsl by querydsl.

the class HibernateSQLBase method entityQueries_createQuery2.

@Test
@ExcludeIn(Target.MYSQL)
public void entityQueries_createQuery2() {
    SAnimal cat = new SAnimal("CAT");
    QCat catEntity = QCat.cat;
    Query query = query().from(cat).select(catEntity).createQuery();
    assertEquals(6, query.list().size());
}

Example 40 with Query

use of org.hibernate.query.Query in project ice by JBEI.

the class PermissionDAO method clearPermissions.

public int clearPermissions(Folder folder) {
    Session session = currentSession();
    Query query = session.createQuery("delete " + Permission.class.getName() + " where folder = :folder");
    query.setParameter("folder", folder);
    try {
        return query.executeUpdate();
    } catch (HibernateException he) {
        Logger.error(he);
        throw new DAOException(he);
    }
}