ObjectDB Database Search

JPA Interface Tuple Interface for extracting the elements of a query result tuple ... correspond to an element in the query result tuple Since: JPA 2.0 X get (String alias, Class   ... result tuple or element cannot be assigned to the specified type Since: JPA 2.0 X get ( TupleElement

result from the next result set. The provider will call execute on the query if needed. A REF_CURSOR result set, if any, is retrieved in the order the REF_CURSOR parameter was registered with the query. Return: the result or null if the next item is not a result set Throws: NoResultException

a single result from the next result set. The provider will call execute on the query if needed. A REF_CURSOR result set, if any, is retrieved in the order the REF_CURSOR parameter was registered with the query. Return: the result or null if the next item is not a result set or if there is no result

.class The class of each query result . If a result set mapping is specified, the specified result class must agree with the type inferred from the result set mapping. If a resultClass is not explicitly specified, then it is inferred from the result set mapping, if any, or defaults to Object or Object

definition. This includes configuration information such as max results , hints, flush mode, lock mode, result set mapping information, and information about stored procedure parameters. When the query ... function returns without throwing an exception, the result of the function is returned. If the given

attribute using an inner join. Parameters: attribute - target of the join Return: the resulting join ... - target of the join jt - join type Return: the resulting join Since: JPA 2.0 Fetch fetch ... an inner join. Parameters: attribute - target of the join Return: the resulting fetch join Since: JPA 2.0

: the resulting join Inherited from: FetchParent Since: JPA 2.0 Fetch fetch ( PluralAttribute   ... : the resulting join Inherited from: FetchParent Since: JPA 2.0 Fetch fetch ( SingularAttribute  attribute ... : attribute - target of the join Return: the resulting fetch join Inherited from: FetchParent Since: JPA 2.0

if the next result corresponds to a result set, and false if it is an update count or if there are no results other than through INOUT and OUT parameters, if any. Return: true if next result corresponds to result set Throws: QueryTimeoutException - if the query execution exceeds the query timeout value

of results from the next result set. The provider will call execute on the query if needed. A REF_CURSOR result set, if any, is retrieved in the order the REF_CURSOR parameter was registered with the query. Return: a list of the results or null is the next item is not a result set Throws

result corresponds to a result set, and false if it is an update count or if there are no results other than through INOUT and OUT parameters, if any. Return: true if first result corresponds to result set Throws: QueryTimeoutException - if the query execution exceeds the query timeout value set

JPA Method in jakarta.persistence.criteria.AbstractQuery Class getResultType () Return the result type of the query or subquery. If a result type was specified as an argument to the createQuery or ... , the result type is Tuple . Otherwise, the result type is Object . Return: result type Since: JPA 2.0

a mapping of the columns of a result set of a native SQL query or stored procedure. Example: {@snippet ... ConstructorResult [] classes default {} Specifies the result set mapping to constructors. Since: JPA 2.1 ColumnResult [] columns default {} Specifies the result set mapping to scalar values. Since: JPA 1.0

. Since: JPA 1.0 Class resultClass default void.class (Optional) The class of each query result . The result class may be overridden by explicitly passing a class object to (String, Class) . If the result class of a named query is not specified, the persistence implementation is entitled to default the result class to Object or Object[] . Since: JPA 1.0

;distinct ) Specify whether duplicate query results are eliminated. A true value will cause duplicates ... been specified, duplicate results must be retained. This method only overrides the return type ... results must be eliminated from the subquery result or whether they must be retained Return: the modified subquery. Since: JPA 2.0

JPA Method in jakarta.persistence.StoredProcedureQuery int getUpdateCount () Return the update count or -1 if there is no pending result or if the next result is not an update count. Return: update count or -1 if there is no pending result or if the next result is not an update count Throws

JPA Method in jakarta.persistence.Query Object getSingleResult () Execute a SELECT query that returns a single untyped result . Return: the result Throws: NoResultException - if there is no result NonUniqueResultException - if more than one result IllegalStateException - if called for a Jakarta

JPA Method in jakarta.persistence.TypedQuery X getSingleResult () Execute a SELECT query that returns a single result . Return: the result , of type {@link X} Throws: NoResultException - if there is no result NonUniqueResultException - if more than one result IllegalStateException - if called

(Optional) The class of each query result . The result class may be overridden by explicitly passing a class object to (String, Class) . If the result class of a named query is not specified, the persistence implementation is entitled to default the result class to Object or Object[] . Since: JPA 1.0

count of -1 if there is no pending result or if the first result is not an update count. The provider will call execute on the query if needed. Return: the update count or -1 if there is no pending result or if the next result is not an update count. Throws: TransactionRequiredException

;boolean distinct ) Specify whether duplicate query results are eliminated. A true value will cause ... been specified, duplicate results must be retained. Parameters: distinct - boolean value specifying whether duplicate results must be eliminated from the query result or whether they must be retained Return: the modified query Since: JPA 2.0

(setwise) subtraction of the second query from the first query, without elimination of duplicate results . Return: a new criteria query which returns the result of subtracting the results of the second query from the results of the first query Since: JPA 3.2

JPA Method in jakarta.persistence.Query Object getSingleResultOrNull () Execute a SELECT query that returns a single untyped result . Return: the result , or null if there is no result Throws: NonUniqueResultException - if more than one result IllegalStateException - if called for a Jakarta

;boolean distinct ) Specify whether duplicate query results are eliminated. A true value will cause ... been specified, duplicate results must be retained. This method only overrides the return type ... whether duplicate results must be eliminated from the query result or whether they must be retained Return: the modified query. Since: JPA 2.0

must be specified in the order in which the result sets is returned by the stored procedure invocation ... of the result set mappings to be used in mapping result sets returned by the stored procedure Return ... result set mapping of the given name does not exist (or the query execution will fail) Since: JPA 1.0

JPA Method in jakarta.persistence.TypedQuery X getSingleResultOrNull () Execute a SELECT query that returns a single untyped result . Return: the result , of type {@link X} , or null if there is no result Throws: NonUniqueResultException - if more than one result IllegalStateException - if called

;List  selectionList ) Specify the selection items that are to be returned in the query result . Replaces the previously specified selection(s), if any. The type of the result of the query execution ... , will be instantiated and returned for each row that results from the query execution. If the type

result . Replaces the previously specified selection(s), if any. The type of the result of the query ... and returned for each row that results from the query execution. If the type of the criteria query ... order. Parameters: selections - selection items corresponding to the results to be returned by

; Selection  selection ) Specify the item that is to be returned in the query result . Replaces ... to specify the type of the select item when it results from a get or join operation and the query result ... in the query result Return: the modified query Throws: IllegalArgumentException - if the selection

delete. If the query is not an update or delete query, query execution will result in each row of the SQL result being returned as a result of type Object[] (or a result of type Object

, Selection , TupleElement The SetJoin interface is the type of the result of joining to a collection ... SetJoin on ( Expression  restriction) Modify the join to restrict the result according ... .1 SetJoin on (Predicate... restrictions) Modify the join to restrict the result according

to database delete operations. The persistence context is not synchronized with the result ... result type Return: subquery Inherited from: CommonAbstractCriteria Since: JPA 2.1 Subquery subquery ( EntityType  type) Create a subquery of the query. Parameters: type - the subquery result type

"" The name of a SqlResultSetMapping , as defined in metadata. The named result set mapping is used to interpret the result set of the native SQL query. Alternatively, the elements entities , classes , and columns may be used to specify a result set mapping. These elements may not be used in conjunction with resultSetMapping . Since: JPA 1.0

result . If this annotation is used, the SQL statement should select all the columns that are mapped to the entity object. This should include foreign key columns to related entities. The results ... 1.0 Class entityClass default null The class of the result . Since: JPA 1.0 FieldResult [] fields

.Connection} A function which makes use of a native database connection to compute a result ... Since: JPA 3.2 Public Methods T apply (C connection) Compute a result using the given connection. Parameters: connection - the connection to use Return: the result Throws: Exceptionif a problem

JPA Method in jakarta.persistence.Query Stream getResultStream () Execute a SELECT query and return the query results as an untyped java.util.stream.Stream . By default, this method delegates ... additional capabilities. Return: a stream of the results , or an empty stream if there are no results

JPA Method in jakarta.persistence.Query List getResultList () Execute a SELECT query and return the query results as an untyped List. Return: a list of the results , or an empty list if there are no results Throws: IllegalStateException - if called for a Jakarta Persistence query language UPDATE or

JPA Method in jakarta.persistence.TypedQuery List getResultList () Execute a SELECT query and return the query results as a typed List. Return: a list of the results , each of type {@link X} , or an empty list if there are no results Throws: IllegalStateException - if called for a Jakarta

JPA Method in jakarta.persistence.TypedQuery Stream getResultStream () Execute a SELECT query and return the query result as a typed Stream . By default, this method delegates to List ... : a stream of the results , each of type {@link X} , or an empty stream if there are no results Throws

JPA Method in jakarta.persistence.Tuple Object get (   int i ) Get the value of the element at the specified position in the result tuple. The first position is 0. Parameters: i - position in result tuple Return: value of the tuple element Throws: IllegalArgumentException - if i exceeds length of result tuple Since: JPA 2.0

 type ) Get the value of the element at the specified position in the result tuple. The first position is 0. Parameters: i - position in result tuple type - type of the tuple element Return: value of the tuple element Throws: IllegalArgumentException - if i exceeds length of result tuple or

according to the query result type. Update and delete operations are typed according to the target ... of the query. Parameters: type - the subquery result type Return: subquery Since: JPA 2.1 Subquery subquery ( EntityType  type) Create a subquery of the query. Parameters: type - the subquery result type Return: subquery Since: JPA 2.1

, PluralJoin , Selection , TupleElement The CollectionJoin interface is the type of the result of joining ... the join to restrict the result according to the specified ON condition and return the join object ... ;restrictions) Modify the join to restrict the result according to the specified ON condition and return

OUT parameter. For portability, all results corresponding to result sets and update counts must be retrieved before the values of output parameters. Parameters: position - parameter position Return: the result

OUT parameter. For portability, all results corresponding to result sets and update counts ... registered or specified in metadata Return: the result that is passed back through the parameter

JPA Enum Nulls java.lang.Object ∟  java.lang.Enum ∟  jakarta.persistence.criteria.Nulls Specifies the precedence of null values within query result sets. See Also: CriteriaBuilder.asc ... of the result set. Since: JPA 3.2 LAST Null values occur at the end of the result set. Since: JPA 3.2 NONE Null

the result of subtracting the results of the second query from the results of the first query Since: JPA 3.2

, TupleElement The ListJoin interface is the type of the result of joining to a collection ... the result according to the specified ON condition and return the join object. Replaces ... to restrict the result according to the specified ON condition and return the join object. Replaces

, Path , PluralJoin , Selection , TupleElement The MapJoin interface is the type of the result ... on ( Expression  restriction) Modify the join to restrict the result according to the specified ... on (Predicate... restrictions) Modify the join to restrict the result according to the specified

synchronized with the result of the bulk update. A CriteriaUpdate object must have a single root ... - the subquery result type Return: subquery Inherited from: CommonAbstractCriteria Since: JPA 2.1 ... - the subquery result type Return: subquery Inherited from: CommonAbstractCriteria Since: JPA 2.1 CriteriaUpdate

.hummingbird.Action[endDate] locating all the Action (a) instances. [Step 1b] Filter the results of step 1a retaining only results that satisfy: (a.endDate=:1). [Step 1c] Retrieve fields in Action (a) instances. [Step 1d] Filter the results of step 1c retaining only results that satisfy: (a.state=3). [Step 1e