SQLQuery (Hibernate JavaDocs)

All Superinterfaces:

BasicQueryContract<CommonQueryContract>, CommonQueryContract, Query, SynchronizeableQuery<T>, TypedQuery<T>

All Known Subinterfaces:

NativeQuery<T>, NativeQueryImplementor<T>

Deprecated.
(since 5.2) use NativeQuery instead.
```
@Deprecated
public interface SQLQuery<T>
extends Query<T>, SynchronizeableQuery<T>
```
Represents a "native sql" query. Allows the user to define certain aspects about its execution, such as:
- result-set value mapping (see below)
- Tables used via addSynchronizedQuerySpace(java.lang.String), addSynchronizedEntityName(java.lang.String) and addSynchronizedEntityClass(java.lang.Class). This allows Hibernate to know how to properly deal with auto-flush checking as well as cached query results if the results of the query are being cached.
In terms of result-set mapping, there are 3 approaches to defining:
- If this represents a named sql query, the mapping could be associated with the query as part of its metadata
- A pre-defined (defined in metadata and named) mapping can be associated with setResultSetMapping(java.lang.String)
- Defined locally per the various addEntity(java.lang.String), addRoot(java.lang.String, java.lang.String), addJoin(java.lang.String, java.lang.String), addFetch(java.lang.String, java.lang.String, java.lang.String) and addScalar(java.lang.String) methods

Nested Class Summary

Nested Classes
Modifier and Type	Interface and Description
`static interface`	`SQLQuery.FetchReturn` Deprecated. Allows access to further control how join fetch returns are mapped back from result sets.
`static interface`	`SQLQuery.ReturnProperty` Deprecated. Allows access to further control how properties within a root or join fetch are mapped back from the result set.
`static interface`	`SQLQuery.RootReturn` Deprecated. Allows access to further control how root returns are mapped back from result sets.

Method Summary

All Methods Instance Methods Abstract Methods Deprecated Methods
Modifier and Type	Method and Description
`SQLQuery<T>`	`addEntity(Class entityType)` Deprecated. Declare a "root" entity, without specifying an alias.
`SQLQuery<T>`	`addEntity(String entityName)` Deprecated. Declare a "root" entity, without specifying an alias.
`SQLQuery<T>`	`addEntity(String tableAlias, Class entityType)` Deprecated. Declare a "root" entity.
`SQLQuery<T>`	`addEntity(String tableAlias, Class entityClass, LockMode lockMode)` Deprecated. Declare a "root" entity, specifying a lock mode.
`SQLQuery<T>`	`addEntity(String tableAlias, String entityName)` Deprecated. Declare a "root" entity.
`SQLQuery<T>`	`addEntity(String tableAlias, String entityName, LockMode lockMode)` Deprecated. Declare a "root" entity, specifying a lock mode.
`SQLQuery.FetchReturn`	`addFetch(String tableAlias, String ownerTableAlias, String joinPropertyName)` Deprecated. Declare a join fetch result.
`SQLQuery<T>`	`addJoin(String tableAlias, String path)` Deprecated. Declare a join fetch result.
`SQLQuery<T>`	`addJoin(String tableAlias, String path, LockMode lockMode)` Deprecated. Declare a join fetch result, specifying a lock mode.
`SQLQuery<T>`	`addJoin(String tableAlias, String ownerTableAlias, String joinPropertyName)` Deprecated. Declare a join fetch result.
`NativeQuery<T>`	`addQueryHint(String hint)` Deprecated. Add a DB query hint to the SQL.
`SQLQuery.RootReturn`	`addRoot(String tableAlias, Class entityType)` Deprecated. Add a new root return mapping, returning a `SQLQuery.RootReturn` to allow further definition.
`SQLQuery.RootReturn`	`addRoot(String tableAlias, String entityName)` Deprecated. Add a new root return mapping, returning a `SQLQuery.RootReturn` to allow further definition.
`SQLQuery<T>`	`addScalar(String columnAlias)` Deprecated. Declare a scalar query result.
`SQLQuery<T>`	`addScalar(String columnAlias, Type type)` Deprecated. Declare a scalar query result.
`SQLQuery<T>`	`addSynchronizedEntityClass(Class entityClass)` Deprecated. Adds an entity for (a) auto-flush checking and (b) query result cache invalidation checking.
`SQLQuery<T>`	`addSynchronizedEntityName(String entityName)` Deprecated. Adds an entity name for (a) auto-flush checking and (b) query result cache invalidation checking.
`SQLQuery<T>`	`addSynchronizedQuerySpace(String querySpace)` Deprecated. Adds a query space.
`List<NativeSQLQueryReturn>`	`getQueryReturns()` Deprecated. Retrieve the returns associated with this query.
`boolean`	`isCallable()` Deprecated. Is this native-SQL query known to be callable?
`NativeQuery<T>`	`setCacheable(boolean cacheable)` Deprecated. Enable/disable second level query (result) caching for this query.
`NativeQuery<T>`	`setCacheMode(CacheMode cacheMode)` Deprecated. (Re)set the current CacheMode in effect for this query.
`NativeQuery<T>`	`setCacheRegion(String cacheRegion)` Deprecated. Set the name of the cache region where query results should be cached (if cached at all).
`NativeQuery<T>`	`setComment(String comment)` Deprecated. Set the comment for this query.
`NativeQuery<T>`	`setFetchSize(int fetchSize)` Deprecated. Sets a JDBC fetch size hint for the query.
`NativeQuery<T>`	`setFlushMode(FlushMode flushMode)` Deprecated. (Re)set the current FlushMode in effect for this query.
`NativeQuery<T>`	`setFlushMode(FlushModeType flushMode)` Deprecated.
`NativeQuery<T>`	`setHibernateFlushMode(FlushMode flushMode)` Deprecated. (Re)set the current FlushMode in effect for this query.
`NativeQuery<T>`	`setLockMode(String alias, LockMode lockMode)` Deprecated. Set the LockMode to use for specific alias (as defined in the query's `FROM` clause).
`NativeQuery<T>`	`setLockOptions(LockOptions lockOptions)` Deprecated. Set the lock options for the query.
`NativeQuery<T>`	`setParameter(int position, Calendar value, TemporalType temporalType)` Deprecated.
`NativeQuery<T>`	`setParameter(int position, Date value, TemporalType temporalType)` Deprecated.
`NativeQuery<T>`	`setParameter(int position, Object val)` Deprecated. Bind a positional query parameter using its inferred Type.
`NativeQuery<T>`	`setParameter(int position, Object val, Type type)` Deprecated. Bind a value to a JDBC-style query parameter.
`<P> NativeQuery<T>`	`setParameter(int position, P val, TemporalType temporalType)` Deprecated. Bind a positional query parameter as some form of date/time using the indicated temporal-type.
`NativeQuery<T>`	`setParameter(Parameter<Calendar> param, Calendar value, TemporalType temporalType)` Deprecated.
`NativeQuery<T>`	`setParameter(Parameter<Date> param, Date value, TemporalType temporalType)` Deprecated.
`<P> NativeQuery<T>`	`setParameter(Parameter<P> param, P value)` Deprecated.
`<P> NativeQuery<T>`	`setParameter(QueryParameter<P> parameter, P val)` Deprecated. Bind a query parameter using its inferred Type.
`<P> NativeQuery<T>`	`setParameter(QueryParameter<P> parameter, P val, TemporalType temporalType)` Deprecated. Bind a query parameter as some form of date/time using the indicated temporal-type.
`<P> NativeQuery<T>`	`setParameter(QueryParameter<P> parameter, P val, Type type)` Deprecated. Bind a query parameter using the supplied Type
`NativeQuery<T>`	`setParameter(String name, Calendar value, TemporalType temporalType)` Deprecated.
`NativeQuery<T>`	`setParameter(String name, Date value, TemporalType temporalType)` Deprecated.
`NativeQuery<T>`	`setParameter(String name, Object val)` Deprecated. Bind a named query parameter using its inferred Type.
`NativeQuery<T>`	`setParameter(String name, Object val, Type type)` Deprecated. Bind a named query parameter using the supplied Type
`<P> NativeQuery<T>`	`setParameter(String name, P val, TemporalType temporalType)` Deprecated. Bind a named query parameter as some form of date/time using the indicated temporal-type.
`<P> NativeQuery<T>`	`setParameterList(QueryParameter<P> parameter, Collection<P> values)` Deprecated. Bind multiple values to a query parameter using its inferred Type.
`NativeQuery<T>`	`setParameterList(String name, Collection values)` Deprecated. Bind multiple values to a named query parameter.
`NativeQuery<T>`	`setParameterList(String name, Collection values, Type type)` Deprecated. Bind multiple values to a named query parameter.
`NativeQuery<T>`	`setParameterList(String name, Object[] values)` Deprecated. Bind multiple values to a named query parameter.
`NativeQuery<T>`	`setParameterList(String name, Object[] values, Type type)` Deprecated. Bind multiple values to a named query parameter.
`NativeQuery<T>`	`setProperties(Map bean)` Deprecated. Bind the values of the given Map for each named parameters of the query, matching key names with parameter names and mapping value types to Hibernate types using heuristics.
`NativeQuery<T>`	`setProperties(Object bean)` Deprecated. Bind the property values of the given bean to named parameters of the query, matching property names with parameter names and mapping property types to Hibernate types using heuristics.
`NativeQuery<T>`	`setReadOnly(boolean readOnly)` Deprecated. Set the read-only/modifiable mode for entities and proxies loaded by this Query.
`SQLQuery<T>`	`setResultSetMapping(String name)` Deprecated. Use a predefined named result-set mapping.
`NativeQuery<T>`	`setTimeout(int timeout)` Deprecated. Set the query timeout in seconds.

Methods inherited from interface org.hibernate.Query
determineProperBooleanType, determineProperBooleanType, getCacheMode, getCacheRegion, getComment, getFetchSize, getFlushMode, getHibernateFirstResult, getHibernateFlushMode, getHibernateMaxResults, getLockOptions, getNamedParameters, getParameterMetadata, getQueryOptions, getQueryString, getReturnAliases, getReturnTypes, getTimeout, isCacheable, isReadOnly, iterate, list, scroll, scroll, setBigDecimal, setBigDecimal, setBigInteger, setBigInteger, setBinary, setBinary, setBoolean, setBoolean, setByte, setByte, setCalendar, setCalendar, setCalendarDate, setCalendarDate, setCharacter, setCharacter, setDate, setDate, setDouble, setDouble, setEntity, setEntity, setFirstResult, setFloat, setFloat, setHibernateFirstResult, setHibernateMaxResults, setHint, setInteger, setInteger, setLocale, setLocale, setLockMode, setLong, setLong, setMaxResults, setParameterList, setParameterList, setParameterList, setParameterList, setParameters, setResultTransformer, setSerializable, setSerializable, setShort, setShort, setString, setString, setText, setText, setTime, setTime, setTimestamp, setTimestamp, uniqueResult

Methods inherited from interface javax.persistence.TypedQuery
getResultList, getResultStream, getSingleResult

Methods inherited from interface javax.persistence.Query
executeUpdate, getFirstResult, getHints, getLockMode, getMaxResults, getParameter, getParameter, getParameter, getParameter, getParameters, getParameterValue, getParameterValue, getParameterValue, isBound, unwrap

Methods inherited from interface org.hibernate.SynchronizeableQuery
addSynchronizedEntityClass, addSynchronizedEntityName, addSynchronizedQuerySpace, addSynchronizedTable, addSynchronizedTable, getSynchronizedQuerySpaces

- Method Detail
 - setResultSetMapping
```
SQLQuery<T> setResultSetMapping(String name)
```
 Deprecated.
 
 Use a predefined named result-set mapping. This might be defined by a <result-set/> element in a Hibernate hbm.xml file or through a SqlResultSetMapping annotation.
 
 Parameters:
 
 name - The name of the mapping to use.
 
 Returns:
 
 this, for method chaining
 - isCallable
```
boolean isCallable()
```
 Deprecated.
 
 Is this native-SQL query known to be callable?
 
 Returns:
 
 true if the query is known to be callable; false otherwise.
 - getQueryReturns
```
List<NativeSQLQueryReturn> getQueryReturns()
```
 Deprecated.
 
 Retrieve the returns associated with this query.
 
 Returns:
 
 The return descriptors
 - addScalar
```
SQLQuery<T> addScalar(String columnAlias)
```
 Deprecated.
 
 Declare a scalar query result. Hibernate will attempt to automatically detect the underlying type.
 Functions like <return-scalar/> in hbm.xml or ColumnResult
 
 Parameters:
 
 columnAlias - The column alias in the result-set to be processed as a scalar result
 
 Returns:
 
 this, for method chaining
 - addScalar
```
SQLQuery<T> addScalar(String columnAlias,
 Type type)
```
 Deprecated.
 
 Declare a scalar query result.
 Functions like <return-scalar/> in hbm.xml or ColumnResult
 
 Parameters:
 
 columnAlias - The column alias in the result-set to be processed as a scalar result
 
 type - The Hibernate type as which to treat the value.
 
 Returns:
 
 this, for method chaining
 - addRoot
```
SQLQuery.RootReturn addRoot(String tableAlias,
 String entityName)
```
 Deprecated.
 
 Add a new root return mapping, returning a SQLQuery.RootReturn to allow further definition.
 
 Parameters:
 
 tableAlias - The SQL table alias to map to this entity
 
 entityName - The name of the entity.
 
 Returns:
 
 The return config object for further control.
 
 Since:
 
 3.6
 - addRoot
```
SQLQuery.RootReturn addRoot(String tableAlias,
 Class entityType)
```
 Deprecated.
 
 Add a new root return mapping, returning a SQLQuery.RootReturn to allow further definition.
 
 Parameters:
 
 tableAlias - The SQL table alias to map to this entity
 
 entityType - The java type of the entity.
 
 Returns:
 
 The return config object for further control.
 
 Since:
 
 3.6
 - addEntity
```
SQLQuery<T> addEntity(String entityName)
```
 Deprecated.
 
 Declare a "root" entity, without specifying an alias. The expectation here is that the table alias is the same as the unqualified entity name
 Use addRoot(java.lang.String, java.lang.String) if you need further control of the mapping
 
 Parameters:
 
 entityName - The entity name that is the root return of the query.
 
 Returns:
 
 this, for method chaining
 - addEntity
```
SQLQuery<T> addEntity(String tableAlias,
 String entityName)
```
 Deprecated.
 
 Declare a "root" entity.
 
 Parameters:
 
 tableAlias - The SQL table alias
 
 entityName - The entity name
 
 Returns:
 
 this, for method chaining
 - addEntity
```
SQLQuery<T> addEntity(String tableAlias,
 String entityName,
 LockMode lockMode)
```
 Deprecated.
 
 Declare a "root" entity, specifying a lock mode.
 
 Parameters:
 
 tableAlias - The SQL table alias
 
 entityName - The entity name
 
 lockMode - The lock mode for this return.
 
 Returns:
 
 this, for method chaining
 - addEntity
```
SQLQuery<T> addEntity(Class entityType)
```
 Deprecated.
 
 Declare a "root" entity, without specifying an alias. The expectation here is that the table alias is the same as the unqualified entity name
 
 Parameters:
 
 entityType - The java type of the entity to add as a root
 
 Returns:
 
 this, for method chaining
 - addEntity
```
SQLQuery<T> addEntity(String tableAlias,
 Class entityType)
```
 Deprecated.
 
 Declare a "root" entity.
 
 Parameters:
 
 tableAlias - The SQL table alias
 
 entityType - The java type of the entity to add as a root
 
 Returns:
 
 this, for method chaining
 - addEntity
```
SQLQuery<T> addEntity(String tableAlias,
 Class entityClass,
 LockMode lockMode)
```
 Deprecated.
 
 Declare a "root" entity, specifying a lock mode.
 
 Parameters:
 
 tableAlias - The SQL table alias
 
 entityClass - The entity Class
 
 lockMode - The lock mode for this return.
 
 Returns:
 
 this, for method chaining
 - addFetch
```
SQLQuery.FetchReturn addFetch(String tableAlias,
 String ownerTableAlias,
 String joinPropertyName)
```
 Deprecated.
 
 Declare a join fetch result.
 
 Parameters:
 
 tableAlias - The SQL table alias for the data to be mapped to this fetch
 
 ownerTableAlias - Identify the table alias of the owner of this association. Should match the alias of a previously added root or fetch
 
 joinPropertyName - The name of the property being join fetched.
 
 Returns:
 
 The return config object for further control.
 
 Since:
 
 3.6
 - addJoin
```
SQLQuery<T> addJoin(String tableAlias,
 String path)
```
 Deprecated.
 
 Declare a join fetch result.
 
 Parameters:
 
 tableAlias - The SQL table alias for the data to be mapped to this fetch
 
 path - The association path ([owner-alias].[property-name]).
 
 Returns:
 
 this, for method chaining
 - addJoin
```
SQLQuery<T> addJoin(String tableAlias,
 String ownerTableAlias,
 String joinPropertyName)
```
 Deprecated.
 
 Declare a join fetch result.
 
 Parameters:
 
 tableAlias - The SQL table alias for the data to be mapped to this fetch
 
 ownerTableAlias - Identify the table alias of the owner of this association. Should match the alias of a previously added root or fetch
 
 joinPropertyName - The name of the property being join fetched.
 
 Returns:
 
 this, for method chaining
 
 Since:
 
 3.6
 - addJoin
```
SQLQuery<T> addJoin(String tableAlias,
 String path,
 LockMode lockMode)
```
 Deprecated.
 
 Declare a join fetch result, specifying a lock mode.
 
 Parameters:
 
 tableAlias - The SQL table alias for the data to be mapped to this fetch
 
 path - The association path ([owner-alias].[property-name]).
 
 lockMode - The lock mode for this return.
 
 Returns:
 
 this, for method chaining
 - addSynchronizedQuerySpace
```
SQLQuery<T> addSynchronizedQuerySpace(String querySpace)
```
 Deprecated.
 
 Description copied from interface: SynchronizeableQuery
 
 Adds a query space.
 
 Specified by:
 
 addSynchronizedQuerySpace in interface SynchronizeableQuery<T>
 
 Parameters:
 
 querySpace - The query space to be auto-flushed for this query.
 
 Returns:
 
 this, for method chaining
 - addSynchronizedEntityName
```
SQLQuery<T> addSynchronizedEntityName(String entityName)
 throws MappingException
```
 Deprecated.
 
 Description copied from interface: SynchronizeableQuery
 
 Adds an entity name for (a) auto-flush checking and (b) query result cache invalidation checking. Same as SynchronizeableQuery.addSynchronizedQuerySpace(java.lang.String) for all tables associated with the given entity.
 
 Specified by:
 
 addSynchronizedEntityName in interface SynchronizeableQuery<T>
 
 Parameters:
 
 entityName - The name of the entity upon whose defined query spaces we should additionally synchronize.
 
 Returns:
 
 this, for method chaining
 
 Throws:
 
 MappingException - Indicates the given name could not be resolved as an entity
 - addSynchronizedEntityClass
```
SQLQuery<T> addSynchronizedEntityClass(Class entityClass)
 throws MappingException
```
 Deprecated.
 
 Description copied from interface: SynchronizeableQuery
 
 Adds an entity for (a) auto-flush checking and (b) query result cache invalidation checking. Same as SynchronizeableQuery.addSynchronizedQuerySpace(java.lang.String) for all tables associated with the given entity.
 
 Specified by:
 
 addSynchronizedEntityClass in interface SynchronizeableQuery<T>
 
 Parameters:
 
 entityClass - The class of the entity upon whose defined query spaces we should additionally synchronize.
 
 Returns:
 
 this, for method chaining
 
 Throws:
 
 MappingException - Indicates the given class could not be resolved as an entity
 - setHibernateFlushMode
```
NativeQuery<T> setHibernateFlushMode(FlushMode flushMode)
```
 Deprecated.
 
 Description copied from interface: Query
 
 (Re)set the current FlushMode in effect for this query.
 
 Specified by:
 
 setHibernateFlushMode in interface BasicQueryContract<CommonQueryContract>
 
 Parameters:
 
 flushMode - The new FlushMode to use.
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.getHibernateFlushMode()
 - setFlushMode
```
NativeQuery<T> setFlushMode(FlushModeType flushMode)
```
 Deprecated.
 
 Specified by:
 
 setFlushMode in interface Query
 
 Specified by:
 
 setFlushMode in interface TypedQuery<T>
 - setCacheMode
```
NativeQuery<T> setCacheMode(CacheMode cacheMode)
```
 Deprecated.
 
 Description copied from interface: Query
 
 (Re)set the current CacheMode in effect for this query.
 
 Specified by:
 
 setCacheMode in interface BasicQueryContract<CommonQueryContract>
 
 Parameters:
 
 cacheMode - The new CacheMode to use.
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.getCacheMode()
 - setCacheable
```
NativeQuery<T> setCacheable(boolean cacheable)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Enable/disable second level query (result) caching for this query.
 
 Specified by:
 
 setCacheable in interface BasicQueryContract<CommonQueryContract>
 
 Parameters:
 
 cacheable - Should the query results be cacheable?
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.isCacheable()
 - setCacheRegion
```
NativeQuery<T> setCacheRegion(String cacheRegion)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Set the name of the cache region where query results should be cached (if cached at all).
 
 Specified by:
 
 setCacheRegion in interface BasicQueryContract<CommonQueryContract>
 
 Parameters:
 
 cacheRegion - the name of a query cache region, or null to indicate that the default region should be used.
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.getCacheRegion()
 - setTimeout
```
NativeQuery<T> setTimeout(int timeout)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Set the query timeout in seconds. NOTE it is important to understand that any value set here is eventually passed directly through to the JDBC Statement which expressly disallows negative values. So negative values should be avoided as a general rule.
 
 Specified by:
 
 setTimeout in interface BasicQueryContract<CommonQueryContract>
 
 Parameters:
 
 timeout - the timeout in seconds
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.getTimeout()
 - setFetchSize
```
NativeQuery<T> setFetchSize(int fetchSize)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Sets a JDBC fetch size hint for the query.
 
 Specified by:
 
 setFetchSize in interface BasicQueryContract<CommonQueryContract>
 
 Parameters:
 
 fetchSize - the fetch size hint
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.getFetchSize()
 - setReadOnly
```
NativeQuery<T> setReadOnly(boolean readOnly)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Set the read-only/modifiable mode for entities and proxies loaded by this Query. This setting overrides the default setting for the persistence context.
 
 Specified by:
 
 setReadOnly in interface BasicQueryContract<CommonQueryContract>
 
 Parameters:
 
 readOnly - true indicates that entities and proxies loaded by the query are to be put in read-only mode; false indicates that entities and proxies loaded by the query will be put in modifiable mode
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 To set the default read-only/modifiable setting used for entities and proxies that are loaded into the session:, PersistenceContext.setDefaultReadOnly(boolean), Read-only entities are not dirty-checked and snapshots of persistent state are not maintained. Read-only entities can be modified, but changes are not persisted. When a proxy is initialized, the loaded entity will have the same read-only/modifiable setting as the uninitialized proxy has, regardless of the session's current setting. The read-only/modifiable setting has no impact on entities/proxies returned by the query that existed in the session before the query was executed.
 - setLockOptions
```
NativeQuery<T> setLockOptions(LockOptions lockOptions)
```
 Deprecated.
 
 Description copied from interface: Query
 Set the lock options for the query. Specifically only the following are taken into consideration:
 For alias-specific locking, use Query.setLockMode(String, LockMode).
 Parameters:
 
 lockOptions - The lock options to apply to the query.
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.getLockOptions()
 - setLockMode
```
NativeQuery<T> setLockMode(String alias,
 LockMode lockMode)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Set the LockMode to use for specific alias (as defined in the query's FROM clause). The alias-specific lock modes specified here are added to the query's internal LockOptions. The effect of these alias-specific LockModes is somewhat dependent on the driver/database in use. Generally speaking, for maximum portability, this method should only be used to mark that the rows corresponding to the given alias should be included in pessimistic locking (LockMode.PESSIMISTIC_WRITE).
 
 Parameters:
 
 alias - a query alias, or "this" for a collection filter
 
 lockMode - The lock mode to apply.
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.getLockOptions()
 - setComment
```
NativeQuery<T> setComment(String comment)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Set the comment for this query.
 
 Parameters:
 
 comment - The human-readable comment
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.getComment()
 - addQueryHint
```
NativeQuery<T> addQueryHint(String hint)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Add a DB query hint to the SQL. These differ from JPA's QueryHint, which is specific to the JPA implementation and ignores DB vendor-specific hints. Instead, these are intended solely for the vendor-specific hints, such as Oracle's optimizers. Multiple query hints are supported; the Dialect will determine concatenation and placement.
 
 Parameters:
 
 hint - The database specific query hint to add.
 - setParameter
```
 NativeQuery<T> setParameter(QueryParameter parameter,
 P val)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind a query parameter using its inferred Type. If the parameter is defined in such a way that the Type cannot be inferred from its usage context then use of this form of binding is not allowed, and Query.setParameter(QueryParameter, Object, Type) should be used instead
 
 Parameters:
 
 parameter - The query parameter memento
 
 val - the possibly-null parameter value
 
 Returns:
 
 this, for method chaining
 - setParameter
```
 NativeQuery<T> setParameter(Parameter param,
 P value)
```
 Deprecated.
 
 Specified by:
 
 setParameter in interface Query
 
 Specified by:
 
 setParameter in interface TypedQuery<T>
 - setParameter
```
NativeQuery<T> setParameter(String name,
 Object val)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind a named query parameter using its inferred Type. If the parameter is defined in such a way that the Type cannot be inferred from its usage context then use of this form of binding is not allowed, and Query.setParameter(String, Object, Type) should be used instead
 
 Specified by:
 
 setParameter in interface Query
 
 Specified by:
 
 setParameter in interface TypedQuery<T>
 
 Parameters:
 
 name - the parameter name
 
 val - the (possibly-null) parameter value
 
 Returns:
 
 this, for method chaining
 - setParameter
```
NativeQuery<T> setParameter(int position,
 Object val)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind a positional query parameter using its inferred Type. If the parameter is defined in such a way that the Type cannot be inferred from its usage context then use of this form of binding is not allowed, and Query.setParameter(int, Object, Type) should be used instead
 
 Specified by:
 
 setParameter in interface Query
 
 Specified by:
 
 setParameter in interface TypedQuery<T>
 
 Parameters:
 
 position - the position of the parameter in the query string, numbered from 0.
 
 val - the possibly-null parameter value
 
 Returns:
 
 this, for method chaining
 - setParameter
```
 NativeQuery<T> setParameter(QueryParameter parameter,
 P val,
 Type type)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind a query parameter using the supplied Type
 
 Parameters:
 
 parameter - The query parameter memento
 
 val - the possibly-null parameter value
 
 type - the Hibernate type
 
 Returns:
 
 this, for method chaining
 - setParameter
```
NativeQuery<T> setParameter(String name,
 Object val,
 Type type)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind a named query parameter using the supplied Type
 
 Parameters:
 
 name - the name of the parameter
 
 val - the possibly-null parameter value
 
 type - the Hibernate type
 
 Returns:
 
 this, for method chaining
 - setParameter
```
NativeQuery<T> setParameter(int position,
 Object val,
 Type type)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind a value to a JDBC-style query parameter.
 
 Parameters:
 
 position - the position of the parameter in the query string, numbered from 0.
 
 val - the possibly-null parameter value
 
 type - the Hibernate type
 
 Returns:
 
 this, for method chaining
 - setParameter
```
 NativeQuery<T> setParameter(QueryParameter parameter,
 P val,
 TemporalType temporalType)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind a query parameter as some form of date/time using the indicated temporal-type.
 
 Parameters:
 
 parameter - The query parameter memento
 
 val - the possibly-null parameter value
 
 temporalType - the temporal-type to use in binding the date/time
 
 Returns:
 
 this, for method chaining
 - setParameter
```
 NativeQuery<T> setParameter(String name,
 P val,
 TemporalType temporalType)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind a named query parameter as some form of date/time using the indicated temporal-type.
 
 Parameters:
 
 name - the parameter name
 
 val - the possibly-null parameter value
 
 temporalType - the temporal-type to use in binding the date/time
 
 Returns:
 
 this, for method chaining
 - setParameter
```
 NativeQuery<T> setParameter(int position,
 P val,
 TemporalType temporalType)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind a positional query parameter as some form of date/time using the indicated temporal-type.
 
 Parameters:
 
 position - the position of the parameter in the query string, numbered from 0.
 
 val - the possibly-null parameter value
 
 temporalType - the temporal-type to use in binding the date/time
 
 Returns:
 
 this, for method chaining
 - setParameterList
```
 NativeQuery<T> setParameterList(QueryParameter parameter,
 Collection values)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind multiple values to a query parameter using its inferred Type. The Hibernate type of the parameter values is first detected via the usage/position in the query and if not sufficient secondly guessed from the class of the first object in the collection. This is useful for binding a list of values to an expression such as foo.bar in (:value_list).
 
 Parameters:
 
 parameter - the parameter memento
 
 values - a collection of values to list
 
 Returns:
 
 this, for method chaining
 - setParameterList
```
NativeQuery<T> setParameterList(String name,
 Collection values)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind multiple values to a named query parameter. The Hibernate type of the parameter is first detected via the usage/position in the query and if not sufficient secondly guessed from the class of the first object in the collection. This is useful for binding a list of values to an expression such as foo.bar in (:value_list).
 
 Parameters:
 
 name - the name of the parameter
 
 values - a collection of values to list
 
 Returns:
 
 this, for method chaining
 - setParameterList
```
NativeQuery<T> setParameterList(String name,
 Collection values,
 Type type)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind multiple values to a named query parameter. This is useful for binding a list of values to an expression such as foo.bar in (:value_list).
 
 Parameters:
 
 name - the name of the parameter
 
 values - a collection of values to list
 
 type - the Hibernate type of the values
 
 Returns:
 
 this, for method chaining
 - setParameterList
```
NativeQuery<T> setParameterList(String name,
 Object[] values,
 Type type)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind multiple values to a named query parameter. This is useful for binding a list of values to an expression such as foo.bar in (:value_list).
 
 Parameters:
 
 name - the name of the parameter
 
 values - a collection of values to list
 
 type - the Hibernate type of the values
 
 Returns:
 
 this, for method chaining
 - setParameterList
```
NativeQuery<T> setParameterList(String name,
 Object[] values)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind multiple values to a named query parameter. The Hibernate type of the parameter is first detected via the usage/position in the query and if not sufficient secondly guessed from the class of the first object in the array. This is useful for binding a list of values to an expression such as foo.bar in (:value_list).
 
 Parameters:
 
 name - the name of the parameter
 
 values - a collection of values to list
 
 Returns:
 
 this, for method chaining
 - setProperties
```
NativeQuery<T> setProperties(Object bean)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind the property values of the given bean to named parameters of the query, matching property names with parameter names and mapping property types to Hibernate types using heuristics.
 
 Parameters:
 
 bean - any JavaBean or POJO
 
 Returns:
 
 this, for method chaining
 - setProperties
```
NativeQuery<T> setProperties(Map bean)
```
 Deprecated.
 
 Description copied from interface: Query
 
 Bind the values of the given Map for each named parameters of the query, matching key names with parameter names and mapping value types to Hibernate types using heuristics.
 
 Parameters:
 
 bean - a java.util.Map
 
 Returns:
 
 this, for method chaining
 - setParameter
```
NativeQuery<T> setParameter(Parameter<Calendar> param,
 Calendar value,
 TemporalType temporalType)
```
 Deprecated.
 
 Specified by:
 
 setParameter in interface Query
 
 Specified by:
 
 setParameter in interface TypedQuery<T>
 - setParameter
```
NativeQuery<T> setParameter(Parameter<Date> param,
 Date value,
 TemporalType temporalType)
```
 Deprecated.
 
 Specified by:
 
 setParameter in interface Query
 
 Specified by:
 
 setParameter in interface TypedQuery<T>
 - setParameter
```
NativeQuery<T> setParameter(String name,
 Calendar value,
 TemporalType temporalType)
```
 Deprecated.
 
 Specified by:
 
 setParameter in interface Query
 
 Specified by:
 
 setParameter in interface TypedQuery<T>
 - setParameter
```
NativeQuery<T> setParameter(String name,
 Date value,
 TemporalType temporalType)
```
 Deprecated.
 
 Specified by:
 
 setParameter in interface Query
 
 Specified by:
 
 setParameter in interface TypedQuery<T>
 - setParameter
```
NativeQuery<T> setParameter(int position,
 Calendar value,
 TemporalType temporalType)
```
 Deprecated.
 
 Specified by:
 
 setParameter in interface Query
 
 Specified by:
 
 setParameter in interface TypedQuery<T>
 - setParameter
```
NativeQuery<T> setParameter(int position,
 Date value,
 TemporalType temporalType)
```
 Deprecated.
 
 Specified by:
 
 setParameter in interface Query
 
 Specified by:
 
 setParameter in interface TypedQuery<T>
 - setFlushMode
```
NativeQuery<T> setFlushMode(FlushMode flushMode)
```
 Deprecated.
 
 Description copied from interface: Query
 
 (Re)set the current FlushMode in effect for this query.
 
 Specified by:
 
 setFlushMode in interface BasicQueryContract<CommonQueryContract>
 
 Parameters:
 
 flushMode - The new FlushMode to use.
 
 Returns:
 
 this, for method chaining
 
 See Also:
 
 Query.getHibernateFlushMode()

Interface SQLQuery<T>

Nested Class Summary

Method Summary

Methods inherited from interface org.hibernate.Query

Methods inherited from interface javax.persistence.TypedQuery

Methods inherited from interface javax.persistence.Query

Methods inherited from interface org.hibernate.SynchronizeableQuery

Method Detail

setResultSetMapping

isCallable

getQueryReturns

addScalar

addScalar

addRoot

addRoot

addEntity

addEntity

addEntity

addEntity

addEntity

addEntity

addFetch

addJoin

addJoin

addJoin

addSynchronizedQuerySpace

addSynchronizedEntityName

addSynchronizedEntityClass

setHibernateFlushMode

setFlushMode

setCacheMode

setCacheable

setCacheRegion

setTimeout

setFetchSize

setReadOnly

setLockOptions

setLockMode

setComment

addQueryHint

setParameter

setParameter

setParameter

setParameter

setParameter

setParameter

setParameter

setParameter

setParameter

setParameter

setParameterList

setParameterList

setParameterList

setParameterList

setParameterList

setProperties

setProperties

setParameter

setParameter

setParameter

setParameter

setParameter

setParameter

setFlushMode