com.mysema.query.jpa.sql
Class AbstractJPASQLQuery<Q extends AbstractJPASQLQuery<Q> & Query>

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

Type Parameters:

Q -

All Implemented Interfaces:

Projectable

Direct Known Subclasses:

JPASQLQuery

public abstract class AbstractJPASQLQuery<Q extends AbstractJPASQLQuery<Q> & Query>
extends AbstractSQLQuery<Q>

AbstractJPASQLQuery is the base class for JPA Native SQL queries

Author:

tiwe

Field Summary

protected boolean	factoryExpressionUsed
protected javax.persistence.FlushModeType	flushMode
protected Map<String,Object>	hints
protected javax.persistence.LockModeType	lockMode
protected SQLTemplates	templates
protected SubQueryExpression<?>[]	union

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

queryMixin

Constructor Summary

AbstractJPASQLQuery(javax.persistence.EntityManager entityManager, SQLTemplates sqlTemplates)

AbstractJPASQLQuery(javax.persistence.EntityManager entityManager, SQLTemplates sqlTemplates, QueryMetadata metadata)

Method Summary

javax.persistence.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<?>[] args) list the results for the given projection An empty list is returned for no results.
<RT> List<RT>	list(Expression<RT> projection) list the results for the given projection An empty list is returned for no results.
<RT> SearchResults<RT>	listResults(Expression<RT> projection) list the results for the given projection
protected void	logQuery(String queryString)
protected void	reset()
Q	setFlushMode(javax.persistence.FlushModeType flushMode)
Q	setHint(String name, Object value)
Q	setLockMode(javax.persistence.LockModeType lockMode)
protected String	toCountRowsString()
protected String	toQueryString()
<RT> Union<RT>	union(ListSubQuery<RT>... sq)
<RT> Q	union(Path<?> alias, ListSubQuery<RT>... sq)
<RT> Q	union(Path<?> alias, SubQueryExpression<RT>... sq)
<RT> Union<RT>	union(SubQueryExpression<RT>... sq)
<RT> Union<RT>	unionAll(ListSubQuery<RT>... sq)
<RT> Q	unionAll(Path<?> alias, ListSubQuery<RT>... sq)
<RT> Q	unionAll(Path<?> alias, SubQueryExpression<RT>... sq)
<RT> Union<RT>	unionAll(SubQueryExpression<RT>... sq)
Object[]	uniqueResult(Expression<?>[] args) return a unique result for the given projection or null if no result is found
<RT> RT	uniqueResult(Expression<RT> expr) return a unique result for the given projection or null if no result is found

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

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

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

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

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

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

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

templates

protected final SQLTemplates templates

hints

protected final Map<String,Object> hints

union

@Nullable
protected SubQueryExpression<?>[] union

lockMode

@Nullable
protected javax.persistence.LockModeType lockMode

flushMode

@Nullable
protected javax.persistence.FlushModeType flushMode

factoryExpressionUsed

protected boolean factoryExpressionUsed

Constructor Detail

AbstractJPASQLQuery

public AbstractJPASQLQuery(javax.persistence.EntityManager entityManager,
                           SQLTemplates sqlTemplates)

AbstractJPASQLQuery

public AbstractJPASQLQuery(javax.persistence.EntityManager entityManager,
                           SQLTemplates sqlTemplates,
                           QueryMetadata metadata)

Method Detail

createQuery

public javax.persistence.Query createQuery(Expression<?>... args)

list

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

Description copied from interface: Projectable

list the results for the given projection An empty list is returned for no results.

Specified by:

list in interface Projectable

Overrides:

list in class ProjectableQuery<Q extends AbstractJPASQLQuery<Q> & Query>

Returns:

list

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

Description copied from interface: Projectable

list the results for the given projection An empty list is returned for no results.

Specified by:

list in interface Projectable

Overrides:

list in class ProjectableQuery<Q extends AbstractJPASQLQuery<Q> & Query>

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

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

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

Returns:

logQuery

protected void logQuery(String queryString)

reset

protected void reset()

toCountRowsString

protected String toCountRowsString()

toQueryString

protected String toQueryString()

union

public <RT> Union<RT> union(ListSubQuery<RT>... sq)

union

public <RT> Union<RT> union(SubQueryExpression<RT>... sq)

unionAll

public <RT> Union<RT> unionAll(ListSubQuery<RT>... sq)

unionAll

public <RT> Union<RT> unionAll(SubQueryExpression<RT>... sq)

union

public <RT> Q union(Path<?> alias,
                    ListSubQuery<RT>... sq)

union

public <RT> Q union(Path<?> alias,
                    SubQueryExpression<RT>... sq)

unionAll

public <RT> Q unionAll(Path<?> alias,
                       ListSubQuery<RT>... sq)

unionAll

public <RT> Q unionAll(Path<?> alias,
                       SubQueryExpression<RT>... sq)

uniqueResult

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

Description copied from interface: Projectable

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

There is some ambiguity for missing results and null valued results, for disambiguation use the list or iterate methods instead.

Type Parameters:

RT - return type

Returns:

the result or null for an empty result

uniqueResult

public Object[] uniqueResult(Expression<?>[] args)

Description copied from interface: Projectable

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

There is some ambiguity for missing results and null valued results, for disambiguation use the list or iterate methods instead.

Returns:

setLockMode

public Q setLockMode(javax.persistence.LockModeType lockMode)

setFlushMode

public Q setFlushMode(javax.persistence.FlushModeType flushMode)

setHint

public Q setHint(String name,
                 Object value)