ObjectDB Database Search

join. Parameters: attribute - target of the join Returns: the resulting fetch join. Since: Jakarta ... attribute - target of the join Returns: the resulting fetch join. Since: Jakarta Persistence (JPA) 1.0 ... attribute using an inner join. Parameters: attribute - target of the join Returns: the resulting join

. This includes configuration information such as max results , hints, flush mode, lock mode, result set ... without throwing an exception, the result of the function is returned. If the given function throws ... and the result of the function is returned. If the function does throw an exception, the transaction is rolled

Interfaces: Annotation Target: Type Specifies a mapping of the columns of a result set of a native SQL ... Since: Jakarta Persistence (JPA) 1.0 Annotation Elements String name The name given to the result set ... . Since: Jakarta Persistence (JPA) 1.0 EntityResult[] entities Specifies the result set mapping to entities

getSingleResult() Retrieve 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. Returns: the result or null if the next item is not a result set. Throws

getSingleResultOrNull() Retrieve 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. Returns: the result or null if the next item is not a result set or

. Since: Jakarta Persistence (JPA) 1.0 Class resultClass (Optional) The class of each query result . The result ... . 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[] . Default: void/class Since: Jakarta Persistence (JPA

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

connection to compute a result . The connection is usually a JDBC connection. See Also: ConnectionConsumer ... Instance Methods T apply ( C connection ) Compute a result using the given connection. Parameters: connection - the connection to use Returns: the result . Throws: Exception - if a problem occurs calling

the SELECT clause of a SQL query to an entity result . If this annotation is used, the SQL statement ... columns to related entities. The results obtained when insufficient data is available are undefined ... The class of the result . Since: Jakarta Persistence (JPA) 1.0 LockModeType lockMode The lock mode obtained

is not changed. Warning: may result in a runtime failure. Inherited from Expression Parameters: type ... to the specified type, returning a new expression object. Unlike Expression.as , this method does result in ... the string-based API may need to specify the type resulting from the get operation in order to avoid

Specifies the precedence of null values within query result sets. See Also: CriteriaBuilder::asc ... Constants FIRST Null values occur at the beginning of the result set. Since: Jakarta Persistence (JPA) 1.0 LAST Null values occur at the end of the result set. Since: Jakarta Persistence (JPA) 1.0

are typed differently. Criteria queries are typed according to the query result type. Update ... type ) Create a subquery of the query. Parameters: type - the subquery result type Returns: subquery ... of the query. Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0

. The persistence context is not automatically synchronized with the result of the bulk update ... of the query. Inherited from CommonAbstractCriteria Parameters: type - the subquery result type ... a subquery of the query. Inherited from CommonAbstractCriteria Parameters: type - the subquery result

context is not synchronized with the result of the bulk delete. A CriteriaDelete object ... Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0 Subquery ... Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (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 ... the createTupleQuery method, the result type is Tuple . Otherwise, the result type is Object . Returns: result type. Since: Jakarta Persistence (JPA) 1.0

() Return true if the first 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. Returns: true if first result corresponds to result set. Throws: PersistenceException - if the query execution exceeds

hasMoreResults() Return true 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. Returns: true if next result corresponds to result set. Throws: PersistenceException - if the query execution exceeds

() Retrieve the list 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. Returns: a list of the results or null is the next item is not a result set

distinct (    boolean distinct ) Specify whether duplicate query results are eliminated. A true ... . If distinct has not been specified, duplicate results must be retained. Parameters: distinct - boolean value specifying whether duplicate results must be eliminated from the query result or

(    boolean distinct ) Specify whether duplicate query results are eliminated. A true value ... has not been specified, duplicate results must be retained. This method only overrides the return ... whether duplicate results must be eliminated from the subquery result or whether they must be retained

a SELECT query that returns a single result . Returns: the result , of type X . Throws ... back. NonUniqueResultException - if more than one result . QueryTimeoutException - if the query execution exceeds the query ... fails and the transaction is rolled back. NoResultException - if there is no result

() Execute a SELECT query that returns a single untyped result . Returns: the result , of type X , or null if there is no result . Throws: IllegalStateException - if called for a Jakarta Persistence query ... and only the statement is rolled back. NonUniqueResultException - if more than one result . QueryTimeoutException

Jakarta Persistence (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. Returns: update count or -1 if there is no pending result or if the next result is not

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

must be specified in the order in which the result sets is returned by the stored procedure invocation. Parameters: resultSetMappings - the names of the result set mappings to be used in mapping result sets returned by the stored procedure procedureName - name of the stored procedure in the database

., for update or 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

) The class of each query result . The result class may be overridden by explicitly passing a class object to EntityManager.createNamedQuery . 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[] . Default: void/class Since: Jakarta Persistence (JPA) 1.0

distinct (    boolean distinct ) Specify whether duplicate query results are eliminated. A true ... . If distinct has not been specified, duplicate results must be retained. This method only overrides ... specifying whether duplicate results must be eliminated from the query result or

results . Returns: a new criteria query which returns the result of subtracting the results of the second query from the results of the first query. Since: Jakarta Persistence (JPA) 3.2

select (    Selection selection ) Specify the item that is to be returned in the query result ... API may need to specify the type of the select item when it results from a get or join operation and the query result type is specified. For example: CriteriaQuery q = cb.createQuery(String.class); Root

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

() Execute a SELECT query that returns a single untyped result . Returns: the result , or null if there is no result . Throws: IllegalStateException - if called for a Jakarta Persistence query language UPDATE or ... is rolled back. NonUniqueResultException - if more than one result . QueryTimeoutException - if the query

the query result . Replaces the previously specified selection(s), if any. The type of the result ... the specified order, will be instantiated and returned for each row that results from the query ... to the results to be returned by the query Returns: the modified query. Throws

a SELECT query that returns a single untyped result . Returns: the result . Throws: IllegalStateException ... - if more than one result . QueryTimeoutException - if the query execution exceeds the query timeout ... fails and the transaction is rolled back. NoResultException - if there is no result

, and the database locking failure results in transaction-level rollback, the provider must throw ... . When the lock cannot be obtained, and the database locking failure results in only statement-level

the name of a column in the SELECT list — i.e., column alias, if applicable. Scalar result types can be included in the query result by specifying this annotation in the metadata. Example: Query q = em

: the runtime type is not changed. Warning: may result in a runtime failure. Inherited from Expression ... result in a runtime type conversion. Providers are required to support casting scalar expressions

. Warning: may result in a runtime failure. Inherited from Expression Parameters: type - intended type ... , returning a new expression object. Unlike Expression.as , this method does result in a runtime type

Jakarta Persistence (JPA) Interface jakarta.persistence.TypedQueryReference Type Parameters: - an upper bound on the result type of the query A reference to a named query declared via the NamedQuery ... () The result type of the query. Since: Jakarta Persistence (JPA) 1.0

: may result in a runtime failure. Inherited from Expression Parameters: type - intended type of the expression ... expression object. Unlike Expression.as , this method does result in a runtime type conversion

cause type conversion: the runtime type is not changed. Warning: may result in a runtime failure ... Expression.as , this method does result in a runtime type conversion. Providers are required to support

changed. Warning: may result in a runtime failure. Parameters: type - intended type ... expression object. Unlike as , this method does result in a runtime type conversion. Providers

;  Class 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 Returns: value of the tuple element. Throws: IllegalArgumentException - if i exceeds length of result

) 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 Returns: value of the tuple element. Throws: IllegalArgumentException - if i exceeds length of result tuple. Since: Jakarta Persistence (JPA) 1.0

() Execute a SELECT query and return the query result as a typed Stream . By default, this method delegates ... to provide additional capabilities. Returns: a stream of the results , each of type X , or an empty stream if there are no results . Throws: IllegalStateException - if called for a Jakarta Persistence query

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

through an INOUT or OUT parameter. For portability, all results corresponding to result sets and update counts ... Returns: the result that is passed back through the parameter. Throws: IllegalArgumentException

through an INOUT or OUT parameter. For portability, all results corresponding to result sets and update ... of the parameter as registered or specified in metadata Returns: the result that is passed

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.Case Case when (    Expression condition ,    R result ) Add a when/then clause to the case expression. Parameters: result - "then" result value condition - "when" condition Returns: general case expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder.Case Case when (    Expression condition ,    Expression result ) Add a when/then clause to the case expression. Parameters: result - "then" result expression condition - "when" condition Returns