Top Description Methods
org.eclipse.persistence.annotations

public @Interface NamedStoredProcedureQuery

extends Annotation
Annotations
@Target:TYPE
@Retention:RUNTIME
@Repeatable:NamedStoredProcedureQueries
Imports
java.lang.annotation.Retention, .Target, .Repeatable, jakarta.persistence.QueryHint

A NamedStoredProcedureQuery annotation allows the definition of queries that call stored procedures as named queries. A NamedStoredProcedureQuery annotation may be defined on an Entity or MappedSuperclass.
Author
Guy Pelletier
Since
Oracle TopLink 11.1.1.0.0
See Also
org.eclipse.persistence.annotations.StoredProcedureParameter

Method Summary

Modifier and TypeMethod and Description
public boolean
callByIndex()

(Optional) Defines if the stored procedure should be called by index or by name.

public QueryHint[]
hints()

(Optional) Query hints.

public boolean
multipleResultSets()

(Optional) Defines if the stored procedure returns multiple result sets.

public String
name()

(Required) Unique name that references this stored procedure query.

public StoredProcedureParameter[]
parameters()

(Optional) Defines the parameters to the stored procedure.

public String
procedureName()

(Required) The name of the stored procedure.

public Class<?>
resultClass()

Deprecated
(Optional) Refers to the class of the result.
public Class<?>[]
resultClasses()

(Optional) Refers to the classes of the result.

public String
resultSetMapping()

Deprecated
(Optional) The name of the SQLResultMapping.
public String[]
resultSetMappings()

(Optional) The names of the SQLResultMappings.

public boolean
returnsResultSet()

(Optional) Defines if stored procedure returns a result set.

Inherited from java.lang.annotation.Annotation:
annotationTypeequalshashCodetoString

Method Detail

callByIndexback to summary
public boolean callByIndex()

(Optional) Defines if the stored procedure should be called by index or by name. By index requires that the StoredProcedureParameter are defined in the same order as the procedure on the database. By name requires the database platform support naming procedure parameters.

hintsback to summary
public QueryHint[] hints()

(Optional) Query hints.

multipleResultSetsback to summary
public boolean multipleResultSets()

(Optional) Defines if the stored procedure returns multiple result sets. This is only relevant on databases that support multiple result sets from stored procedures.

nameback to summary
public String name()

(Required) Unique name that references this stored procedure query.

parametersback to summary
public StoredProcedureParameter[] parameters()

(Optional) Defines the parameters to the stored procedure.

procedureNameback to summary
public String procedureName()

(Required) The name of the stored procedure.

resultClassback to summary
public Class<?> resultClass()

Deprecated

(Optional) Refers to the class of the result.

Annotations
@Deprecated
See Also
resultClasses
resultClassesback to summary
public Class<?>[] resultClasses()

(Optional) Refers to the classes of the result.

resultSetMappingback to summary
public String resultSetMapping()

Deprecated

(Optional) The name of the SQLResultMapping.

Annotations
@Deprecated
See Also
resultSetMappings
resultSetMappingsback to summary
public String[] resultSetMappings()

(Optional) The names of the SQLResultMappings.

returnsResultSetback to summary
public boolean returnsResultSet()

(Optional) Defines if stored procedure returns a result set. This is only relevant on databases that support returning result sets from stored procedures.