Annotation Interface NamedNativeQuery

@Target({TYPE,PACKAGE,MODULE})
@Retention(RUNTIME)
@Repeatable(NamedNativeQueries.class)
public @interface NamedNativeQuery

Declares a named query written in native SQL.

Whereas the JPA @NamedNativeQuery annotation allows custom settings specific to Hibernate to be specified via stringly-typed query hints, this annotation is completely typesafe.

Note that the members of this annotation correspond to hints enumerated by AvailableHints.

This annotation may also be applied to a package-info.java or module-info.java, which is a convenient location for query declarations not specific to any particular entity.

See Also:

• NativeQuery
• NamedQuery
• NamedNativeQuery

Required Element Summary

Required Elements

Modifier and Type	Required Element	Description
String	name	The name of this query.
String	query	The text of the SQL query.

Optional Element Summary

Optional Elements

Modifier and Type	Optional Element	Description
boolean	cacheable	Whether the query results are cacheable.
CacheMode	cacheMode	The cache interaction mode for this query.
String	cacheRegion	If the query results are cacheable, the name of the query cache region.
CacheRetrieveMode	cacheRetrieveMode	The cache retrieval mode for objects returned by this query.
CacheStoreMode	cacheStoreMode	The cache storage mode for objects returned by this query.
String	comment	A comment added to the SQL query.
int	fetchSize	The number of rows fetched by the JDBC driver per trip.
QueryFlushMode	flush	Determines whether the session should be flushed before executing the query.
String[]	querySpaces	The query spaces involved in this query.
boolean	readOnly	Whether the results should be loaded in read-only mode.
Class<?>	resultClass	The resulting Class.
String	resultSetMapping	The name of a SqlResultSetMapping.
int	timeout	The query timeout in seconds.

Element Details

name

String name

The name of this query. Must be unique within a persistence unit.

See Also:

• SessionFactory.addNamedQuery(String, TypedQuery)
• Session.createNamedQuery(String, Class)

query

String query

The text of the SQL query.

resultClass

Class<?> resultClass

The resulting Class.

Should not be used in conjunction with resultSetMapping()

Default:

void.class

resultSetMapping

String resultSetMapping

The name of a SqlResultSetMapping.

Should not be used in conjunction with resultClass().

Default:

""

flush

QueryFlushMode flush

Determines whether the session should be flushed before executing the query.

Since:

7.0

See Also:

• CommonQueryContract.setQueryFlushMode(QueryFlushMode)

Default:

DEFAULT

cacheable

boolean cacheable

Whether the query results are cacheable. Default is false, that is, not cacheable.

See Also:

• SelectionQuery.setCacheable(boolean)
• HibernateHints.HINT_CACHEABLE

Default:

false

cacheRegion

String cacheRegion

If the query results are cacheable, the name of the query cache region.

See Also:

• SelectionQuery.setCacheRegion(String)
• HibernateHints.HINT_CACHE_REGION

Default:

""

fetchSize

int fetchSize

The number of rows fetched by the JDBC driver per trip.

See Also:

• SelectionQuery.setFetchSize(int)
• HibernateHints.HINT_FETCH_SIZE

Default:

-1

timeout

int timeout

The query timeout in seconds. Default is no timeout.

See Also:

• CommonQueryContract.setTimeout(int)
• HibernateHints.HINT_TIMEOUT
• SpecHints.HINT_SPEC_QUERY_TIMEOUT

Default:

-1

comment

String comment

A comment added to the SQL query. Useful when engaging with DBA.

See Also:

• CommonQueryContract.setComment(String)
• HibernateHints.HINT_COMMENT

Default:

""

cacheStoreMode

CacheStoreMode cacheStoreMode

The cache storage mode for objects returned by this query.

Since:

6.2

See Also:

• Query.setCacheMode(CacheMode)
• SpecHints.HINT_SPEC_CACHE_STORE_MODE

Default:

USE

cacheRetrieveMode

CacheRetrieveMode cacheRetrieveMode

The cache retrieval mode for objects returned by this query.

Since:

6.2

See Also:

• Query.setCacheMode(CacheMode)
• SpecHints.HINT_SPEC_CACHE_RETRIEVE_MODE

Default:

USE

cacheMode

CacheMode cacheMode

The cache interaction mode for this query.

See Also:

• SelectionQuery.setCacheMode(CacheMode)
• HibernateHints.HINT_CACHE_MODE

Default:

NORMAL

readOnly

boolean readOnly

Whether the results should be loaded in read-only mode. Default is false.

See Also:

• SelectionQuery.setReadOnly(boolean)
• HibernateHints.HINT_READ_ONLY

Default:

false

querySpaces

String[] querySpaces

The query spaces involved in this query.

Typically, the names of tables which are referenced by the query.

See Also:

• SynchronizeableQuery.addSynchronizedQuerySpace(String)
• HibernateHints.HINT_NATIVE_SPACES
• Synchronize

Default:

{}