org.hibernate.annotations

Annotation Type NamedNativeQuery

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

Extends NamedNativeQuery with Hibernate features.

See Also:

SQLQuery

Required Element Summary

Required Elements

Modifier and Type	Required Element and Description
String	name The name.
String	query The SQL query string.

Optional Element Summary

Optional Elements

Modifier and Type	Optional Element and Description
boolean	cacheable Whether the query (results) is cacheable or not.
CacheModeType	cacheMode The cache mode used for this query.
String	cacheRegion If the query results are cacheable, name the query cache region to use.
boolean	callable Does the SQL (query()) represent a call to a procedure/function?
String	comment A comment added to the SQL query.
int	fetchSize The number of rows fetched by the JDBC Driver per trip.
FlushModeType	flushMode The flush mode for the query.
String[]	querySpaces The query spaces to apply for the query.
boolean	readOnly Whether the results should be read-only.
Class	resultClass The result Class.
String	resultSetMapping The name of a SQLResultSetMapping to use.
int	timeout The query timeout (in seconds).

Element Detail

name

public abstract String name

The name. It is a named query after all :)

query

public abstract String query

The SQL query string.

resultClass

public abstract Class resultClass

The result Class. Should not be used in conjunction with resultSetMapping()

Default:

void.class

resultSetMapping

public abstract String resultSetMapping

The name of a SQLResultSetMapping to use. Should not be used in conjunction with resultClass().

Default:

""

flushMode

public abstract FlushModeType flushMode

The flush mode for the query.

Default:

org.hibernate.annotations.FlushModeType.PERSISTENCE_CONTEXT

cacheable

public abstract boolean cacheable

Whether the query (results) is cacheable or not. Default is false, that is not cacheable.

Default:

false

cacheRegion

public abstract String cacheRegion

If the query results are cacheable, name the query cache region to use.

Default:

""

fetchSize

public abstract int fetchSize

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

Default:

-1

timeout

public abstract int timeout

The query timeout (in seconds). Default is no timeout.

Default:

-1

callable

public abstract boolean callable

Does the SQL (query()) represent a call to a procedure/function?

Default:

false

comment

public abstract String comment

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

Default:

""

cacheMode

public abstract CacheModeType cacheMode

The cache mode used for this query. This refers to entities/collections returned from the query.

Default:

org.hibernate.annotations.CacheModeType.NORMAL

readOnly

public abstract boolean readOnly

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

Default:

false

querySpaces

public abstract String[] querySpaces

The query spaces to apply for the query.

See Also:

SynchronizeableQuery

Default:

{}