8.12.33 @NamedNativeQuery
- Organization of this subsection
(1) Description
This annotation specifies a named query in the SQL. This annotation can be applied to an entity class and mapped superclass.
The applicable target is class.
(2) Element
The following table lists the elements of @NamedNativeQuery:
Element name |
Optional/Required |
Element description |
---|---|---|
Required |
This element specifies the name of the named query. |
|
Required |
This element specifies the SQL string. |
|
Optional |
This element specifies an array of @QueryHint. |
|
Optional |
This element specifies the class in which the SQL results are applied. |
|
Optional |
This element specifies the name indicated in the name element of @SqlResultSetMapping. |
The details of attributes that are supported with Cosminexus JPA provider are as follows:
(a) name element
- Type
-
String
- Description
-
This element specifies the name of the named query.
The value that can be specified is a character string.
- Default value
-
None
(b) query element
- Type
-
String
- Description
-
This element specifies the SQL string.
The SQL that can be specified depends on the specifications of the database used.
- Default value
-
None
(c) hints element
- Type
-
QueryHint[]
- Description
-
This element specifies an array of @QueryHint.
You can specify the value within the specifiable range of the arrays of @QueryHint. For details, see 8.12.53 @QueryHint.
- Default value
-
Blank array
(d) resultClass element
- Type
-
Class
- Description
-
This element specifies the class in which the SQL results are applied.
The resultClass element is specified when the class, in which you want to map the execution results of the query, exists. Do not specify the resultClass element and resultSetMapping element concurrently.
The value that can be specified is the class name.
- Default value
-
void.class
(e) resultSetMapping element
- Type
-
String
- Description
-
This element specifies the name indicated in the name element of @SqlResultSetMapping in which the result set is defined.
This element is specified when the SQL results are to be mapped to any result set.
Do not specify the resultClass element and resultSetMapping element concurrently.
You can specify the value within the specifiable range of the name element of @SqlResultSetMapping. For details, see 8.12.57(2)(a) name element.
- Default value
-
Null character string