Use @StoredProcedureParameter
within a NamedStoredProcedureQuery
annotation.
Annotation Elements
Table 2-63 describes this annotation's elements.
Table 2-63 @StoredProcedureParameter Annotation Elements
Annotation Element | Description | Default |
---|---|---|
|
(Required) The query parameter name |
|
|
(Optional) The direction of the stored procedure parameter:
|
|
|
(Optional) JDBC type code. This depends on the type returned from the procedure. |
|
|
(Optional) JDBC type name. This may be required for |
|
|
(Optional) Stored procedure parameter name |
|
|
(Optional) Specify if the parameter is required, or optional and defaulted by the procedure. |
|
|
(Optional) Type of Java class desired back from the procedure. This depends on the |
|
Examples
See "@NamedStoredProcedureQuery" for an example using the @StoredProcedureParameter
annotation.
See Also
For more information:
Stored Procedure Examples
http://wiki.eclipse.org/EclipseLink/Examples/JPA/StoredProcedures