com.mysema.query.jpa.hibernate.sql
Class HibernateSQLQuery

java.lang.Object
  com.mysema.query.support.QueryBase<Q>
      com.mysema.query.support.ProjectableQuery<T>
          com.mysema.query.jpa.AbstractSQLQuery<HibernateSQLQuery>
              com.mysema.query.jpa.hibernate.sql.HibernateSQLQuery

All Implemented Interfaces:

FilteredClause<HibernateSQLQuery>, Projectable, Query<HibernateSQLQuery>, SQLCommonQuery<HibernateSQLQuery>

public final class HibernateSQLQuery
extends AbstractSQLQuery<HibernateSQLQuery>
implements SQLCommonQuery<HibernateSQLQuery>

HibernateSQLQuery is an SQLQuery implementation that uses Hibernate's Native SQL functionality to execute queries

Author:

tiwe

Field Summary

Fields inherited from class com.mysema.query.support.QueryBase

queryMixin

Constructor Summary

protected	HibernateSQLQuery(SessionHolder session, SQLTemplates sqlTemplates, QueryMetadata metadata)
	HibernateSQLQuery(org.hibernate.Session session, SQLTemplates sqlTemplates)
	HibernateSQLQuery(org.hibernate.StatelessSession session, SQLTemplates sqlTemplates)

Method Summary

HibernateSQLQuery	clone(org.hibernate.Session session)
org.hibernate.Query	createQuery(Expression<?>... args)
com.mysema.commons.lang.CloseableIterator<Object[]>	iterate(Expression<?>[] args) iterate over the results for the given projection
<RT> com.mysema.commons.lang.CloseableIterator<RT>	iterate(Expression<RT> projection) iterate over the results for the given projection
List<Object[]>	list(Expression<?>[] projection) list the results for the given projection
<RT> List<RT>	list(Expression<RT> projection) list the results for the given projection
<RT> SearchResults<RT>	listResults(Expression<RT> projection) list the results for the given projection
protected void	logQuery(String queryString)
protected void	reset()
HibernateSQLQuery	setCacheable(boolean cacheable) Enable caching of this query result set.
HibernateSQLQuery	setCacheRegion(String cacheRegion) Set the name of the cache region.
HibernateSQLQuery	setFetchSize(int fetchSize) Set a fetch size for the underlying JDBC query.
HibernateSQLQuery	setReadOnly(boolean readOnly) Entities retrieved by this query will be loaded in a read-only mode where Hibernate will never dirty-check them or make changes persistent.
HibernateSQLQuery	setTimeout(int timeout) Set a timeout for the underlying JDBC query.
protected String	toCountRowsString()
protected String	toQueryString()
<RT> RT	uniqueResult(Expression<RT> expr) return a unique result for the given projection or null if not result is found

Methods inherited from class com.mysema.query.jpa.AbstractSQLQuery

count, exists, from, from, fullJoin, fullJoin, fullJoin, getMetadata, innerJoin, innerJoin, innerJoin, join, join, join, leftJoin, leftJoin, leftJoin, on, rightJoin, rightJoin, rightJoin

Methods inherited from class com.mysema.query.support.ProjectableQuery

countDistinct, iterate, iterateDistinct, iterateDistinct, iterateDistinct, list, listDistinct, listDistinct, listDistinct, listDistinctResults, map, notExists, uniqueResult, uniqueResult

Methods inherited from class com.mysema.query.support.QueryBase

distinct, groupBy, having, limit, offset, orderBy, restrict, set, toString, where

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.mysema.query.sql.SQLCommonQuery

from, from, fullJoin, fullJoin, fullJoin, innerJoin, innerJoin, innerJoin, join, join, join, leftJoin, leftJoin, leftJoin, on, rightJoin, rightJoin, rightJoin

Methods inherited from interface com.mysema.query.Query

distinct, groupBy, having, limit, offset, orderBy, restrict, set

Methods inherited from interface com.mysema.query.FilteredClause

where

Constructor Detail

HibernateSQLQuery

public HibernateSQLQuery(org.hibernate.Session session,
                         SQLTemplates sqlTemplates)

HibernateSQLQuery

protected HibernateSQLQuery(SessionHolder session,
                            SQLTemplates sqlTemplates,
                            QueryMetadata metadata)

HibernateSQLQuery

public HibernateSQLQuery(org.hibernate.StatelessSession session,
                         SQLTemplates sqlTemplates)

Method Detail

clone

public HibernateSQLQuery clone(org.hibernate.Session session)

createQuery

public org.hibernate.Query createQuery(Expression<?>... args)

list

public List<Object[]> list(Expression<?>[] projection)

Description copied from interface: Projectable

list the results for the given projection

Specified by:

list in interface Projectable

Overrides:

list in class ProjectableQuery<HibernateSQLQuery>

Returns:

list

public <RT> List<RT> list(Expression<RT> projection)

Description copied from interface: Projectable

list the results for the given projection

Specified by:

list in interface Projectable

Overrides:

list in class ProjectableQuery<HibernateSQLQuery>

Type Parameters:

RT - generic type of the List

Returns:

a List over the projection

iterate

public com.mysema.commons.lang.CloseableIterator<Object[]> iterate(Expression<?>[] args)

Description copied from interface: Projectable

iterate over the results for the given projection

Specified by:

iterate in interface Projectable

Returns:

iterate

public <RT> com.mysema.commons.lang.CloseableIterator<RT> iterate(Expression<RT> projection)

Description copied from interface: Projectable

iterate over the results for the given projection

Specified by:

iterate in interface Projectable

Type Parameters:

RT - generic type of the Iterator

Returns:

an Iterator over the projection

listResults

public <RT> SearchResults<RT> listResults(Expression<RT> projection)

Description copied from interface: Projectable

list the results for the given projection

Specified by:

listResults in interface Projectable

Returns:

logQuery

protected void logQuery(String queryString)

reset

protected void reset()

toCountRowsString

protected String toCountRowsString()

toQueryString

protected String toQueryString()

uniqueResult

public <RT> RT uniqueResult(Expression<RT> expr)

Description copied from interface: Projectable

return a unique result for the given projection or null if not result is found

Specified by:

uniqueResult in interface Projectable

Overrides:

uniqueResult in class ProjectableQuery<HibernateSQLQuery>

Type Parameters:

RT - return type

Returns:

the result or null for an empty result

setCacheable

public HibernateSQLQuery setCacheable(boolean cacheable)

Enable caching of this query result set.

Parameters:

cacheable - Should the query results be cacheable?

setCacheRegion

public HibernateSQLQuery setCacheRegion(String cacheRegion)

Set the name of the cache region.

Parameters:

cacheRegion - the name of a query cache region, or null for the default query cache

setFetchSize

public HibernateSQLQuery setFetchSize(int fetchSize)

Set a fetch size for the underlying JDBC query.

Parameters:

fetchSize - the fetch size

setReadOnly

public HibernateSQLQuery setReadOnly(boolean readOnly)

Entities retrieved by this query will be loaded in a read-only mode where Hibernate will never dirty-check them or make changes persistent.

setTimeout

public HibernateSQLQuery setTimeout(int timeout)

Set a timeout for the underlying JDBC query.

Parameters:

timeout - the timeout in seconds