Internal Website Search

JPA Interface AbstractQuery Type Parameters: - the type of the result Super Interfaces ... whether duplicate query results will be eliminated. A true value will cause duplicates to be eliminated ... results must be retained. Parameters: distinct - boolean value specifying whether duplicate results

JPA Interface TypedQuery Type Parameters: - query result type Super Interfaces: Query Interface ... Since: JPA 1.0 int getFirstResult () The position of the first result the query object was set ... result Inherited from: Query Since: JPA 2.0 The Running JPA Queries article explains how to use

is rolled back Since: JPA 1.0 int getFirstResult () The position of the first result the query object ... : position of the first result Since: JPA 2.0 The Running JPA Queries article explains how to use ... int getMaxResults () The maximum number of results the query object was set to retrieve. Returns

an all expression over the subquery results . Parameters: subquery - subquery Return: all expression ...  subquery) Create an any expression over the subquery results . This expression is equivalent ... . This method is used to specify a constructor that will be applied to the results of the query execution

and names a stored procedure, its parameters, and its result type. The NamedStoredProcedureQuery ... classes) that are used to map the results . The resultSetMappings element names one or more result set mappings, as defined by the SqlResultSetMapping annotation. If there are multiple result sets

; result ) Add an "else" clause to the case expression. Parameters: result - "else" result expression Return: expression Since: JPA 2.0 Expression otherwise (R  result ) Add an "else" clause to the case expression. Parameters: result - "else" result Return: expression Since: JPA 2.0 CriteriaBuilder

. Since: JPA 2.0 Public Methods Expression otherwise ( Expression   result ) Add an "else" clause to the case expression. Parameters: result - "else" result expression Return: expression Since: JPA 2.0 Expression otherwise (R  result ) Add an "else" clause to the case expression. Parameters

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, will be 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

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 set

of results from the next result set. The provider will call execute on the query if needed. A REF_CURSOR result set, if any, will be 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

JPA Method in javax.persistence.StoredProcedureQuery boolean execute () 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. Return: true if first result corresponds to result

JPA Method in javax.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

the mapping of the result of a native SQL query or stored procedure. Example: Query q = em ... 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 EntityResult [] entities default {} Specifies

;distinct ) Specify whether duplicate query results will be eliminated. A true value will cause ... 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 javax.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 javax.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 Java

JPA Method in javax.persistence.TypedQuery X getSingleResult () Execute a SELECT query that returns a single result . Return: the result Throws: NoResultException - if there is no result NonUniqueResultException - if more than one result IllegalStateException - if called for a Java Persistence

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 will be eliminated. A true value ... 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 whether they must be retained Return: the modified query Since: JPA 2.0

;boolean distinct ) Specify whether duplicate query results will be eliminated. A true value ... has not 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 will be returned by the stored procedure invocation ... of the result set mappings to be used in mapping result sets returned by the stored procedure ... or result set mapping of the given name does not exist (or the query execution will fail) Since: JPA 1.0

;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

;Selection ... selections ) 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 ... and returned for each row that results from the query execution. If the type of the criteria query

;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 ... : selection - selection specifying the item that is to be returned in the query result Return: the modified

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

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

with the SqlResultSetMapping annotation to map the SELECT clause of a SQL query to an entity result ... object. This should include foreign key columns to related entities. The results obtained ... the type of the entity instance. Since: JPA 1.0 Class entityClass default null The class of the result

JPA Method in javax.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 element cannot be assigned to the specified type Since: JPA 2.0

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

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

) to which the foreign key annotation is applied. A value of NO_CONSTRAINT will result in no constraint being generated. A value of PROVIDER_DEFAULT will result in the provider's default behavior (which may or may not result in the generation of a constraint for the given join column(s). Since: JPA 2.1

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

) to which the foreign key annotation is applied. A value of NO_CONSTRAINT will result in no constraint being generated. A value of PROVIDER_DEFAULT will result in the provider's default behavior (which may or may not result in the generation of a constraint for the given join column(s). Since: JPA 2.1

, 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 the previous ... 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 ...  restriction) Modify the join to restrict the result according to the specified ON condition ... on (Predicate... restrictions) Modify the join to restrict the result according to the specified

.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

- the name of a query defined in metadata resultClass - the type of the query result Return ... name or if the query string is found to be invalid or if the query result is found to not be assignable to the specified type Since: JPA 2.0

to database delete operations. The persistence context is not synchronized with the result ... ) Create a subquery of the query. Parameters: type - the subquery result type Return: subquery Inherited

the range of results to return. The parameter is a String containing a comma-separated fromIncl and toExcl ... setRange("50, :to"); . The execution of the query is modified to return only a subset of results ... , then the first 50 results that would have been returned are skipped, the next 20 results are returned

;long toExcl ) Set the range of results to return. The execution of the query is modified to return only a subset of results . If the filter would normally return 100 instances, and fromIncl is set to 50, and toExcl is set to 70, then the first 50 results that would have been returned are skipped

parameter instance is unmodified as a result of the addSubquery or subsequent execution of the outer ... specification, uniqueness, result specification, and grouping specification. The association with a PersistenceManager, the candidate collection or extent, result class, and range limits are not used

JDO Method in javax.jdo.Query void closeAll () Close all query results associated with this Query instance, and release all resources associated with them. The query results might have iterators open on them. Iterators associated with the query results are invalidated: they return false to hasNext

result and release any resources associated with it. The parameter is the return from execute(...) and might have iterators open on it. Iterators associated with the query result are invalidated ... - the result of execute(...) on this Query instance. Since: JDO 1.0

unregisters the specified class. Any further attempt to get metadata for the specified class will result in ... . Any attempt to get metadata for unregistered classes will result in a JDOFatalUserException ... for the constructor Return: the result of construction Since: JDO 1.0 JDOImplHelper getInstance

identity, the parameter for the constructor; for non-single-field application identity, the result ... and Collection . Parameters: cls - the Class of results cln - the Collection of candidate instances Return ... instances and filter. Parameters: cls - the Class of results filter - the filter for candidate instances

resultClass default void.class Result class into which to put the results . Since: JDO 2.1 String unique default "" Whether the query returns a single unique result . Since: JDO 2.1 String unmodifiable