Internal Website Search

JPA Method in javax.persistence. Query Object getSingleResult () Execute a SELECT query ... Persistence query language UPDATE or DELETE statement QueryTimeoutException - if the query execution exceeds the query timeout value set and only the statement is rolled back TransactionRequiredException

JPA Method in javax.persistence. Query LockModeType getLockMode () Get the current lock mode for the query . Returns null if a lock mode has not been set on the query object. Return: lock mode Throws: IllegalStateException - if the query is found not to be a Java Persistence query language SELECT query or a Criteria API query Since: JPA 2.0

JPA Method in javax.persistence. Query int executeUpdate () Execute an update or delete statement ... for a Java Persistence query language SELECT statement or for a criteria query TransactionRequiredException ... QueryTimeoutException - if the statement execution exceeds the query timeout value set

do not support aggregate queries (max, min, count, sum and avg). ObjectDB supports rich queries , including aggregate queries , as part of its support of JPQL (JPA Query Language) and JDOQL (JDO Query Language). ObjectDB is faster than other products.

to automatic removal of that object from the database. DELETE Queries DELETE queries provide an alternative way for removing entity objects from the database. Deleting objects using a DELETE query ... ;The  DELETE Queries in JPA/JPQL  in chapter 4 explains how to use JPA DELETE queries .

Most JPQL queries use at least one comparison operator in their WHERE clause. Comparison Operators ... its own notation (which is also in use by JDOQL, the JDO Query Language). ObjectDB supports both forms ... . Equality operators (=, , == , != ) on strings in queries follow the logic of Java's equals

Queries UPDATE queries provide an alternative way of updating entity objects in the database. Modifying objects using an UPDATE query may be useful especially when many entity objects have to be modified in one operation. The UPDATE Queries in JPA/JPQL in chapter 4 explains how to use JPA UPDATE queries .

JPA Method in javax.persistence. Query Parameter getParameter (   String name,  ... of the given name and type. This method is required to be supported for criteria queries ... IllegalStateException - if invoked on a native query or Java Persistence query language query when the implementation does not support this use Since: JPA 2.0

JPA Method in javax.persistence. Query Query setFlushMode (    FlushModeType  flushMode ) Set the flush mode type to be used for the query execution. The flush mode type applies to the query regardless of the flush mode type in use for the entity manager. Parameters: flushMode

JPA Method in javax.persistence. Query Set getParameters () Get the parameter objects corresponding to the declared parameters of the query . Returns empty set if the query has no parameters. This method is not required to be supported for native queries . Return: set of the parameter objects Throws

JPA Method in javax.persistence. Query Query setHint (   String hintName,    Object value ) Set a query property or hint. The hints elements may be used to specify query properties and hints. Properties defined by this specification must be observed by

;String message,    Throwable cause,     Query   query ) Constructs a new QueryTimeoutException exception with the specified detail message, cause, and query . Parameters: message - the detail message. cause - the cause. query - the query . Since: JPA 2.0

JPA Constructor in javax.persistence.QueryTimeoutException QueryTimeoutException (    Query   query ) Constructs a new QueryTimeoutException exception with the specified query . Parameters: query - the query . Since: JPA 2.0

JPA Method in javax.persistence. Query Parameter getParameter (   int position,    Class  type ) Get the parameter object corresponding to the declared positional ... IllegalStateException - if invoked on a native query or Java Persistence query language query when the implementation does not support this use Since: JPA 2.0

JPA Method in javax.persistence. Query Query setParameter (   String name,  ... value temporalType - temporal type Return: the same query instance Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or if the value argument is of incorrect type Since: JPA 1.0

JPA Method in javax.persistence. Query Query setParameter (   String name,  ... - parameter name value - parameter value Return: the same query instance Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or if the argument is of incorrect type Since: JPA 1.0

JPA Method in javax.persistence. Query Query setParameter (    Parameter  param ... value temporalType - temporal type Return: the same query instance Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query Since: JPA 2.0

JPA Method in javax.persistence. Query Query setParameter (    Parameter  param ... - parameter value temporalType - temporal type Return: the same query instance Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query Since: JPA 2.0

JPA Method in javax.persistence. Query Query setParameter (   int position,  ... temporalType - temporal type Return: the same query instance Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or if the value argument is of incorrect type Since: JPA 1.0

JPA Method in javax.persistence. Query Query setParameter (   int position,  ... value temporalType - temporal type Return: the same query instance Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or if the value argument is of incorrect type Since: JPA 1.0

JPA Method in javax.persistence. Query Query setParameter (   String name,  ... temporalType - temporal type Return: the same query instance Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or if the value argument is of incorrect type Since: JPA 1.0

JPA Method in javax.persistence. Query Query setParameter (   int position,  ... - position value - parameter value Return: the same query instance Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or if the argument is of incorrect type Since: JPA 1.0

JPA Method in javax.persistence. Query Query setParameter (    Parameter  param ... object value - parameter value Return: the same query instance Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query Since: JPA 2.0

JPA Method in javax.persistence. Query int getFirstResult () The position of the first result the query object was set to retrieve. Returns 0 if setFirstResult was not applied to the query object. Return: position of the first result Since: JPA 2.0 The Running JPA Queries article explains how to use getFirstResult .

JPA Annotation Attribute in javax.persistence.NamedQuery String query default null (Required) The query string in the Java Persistence query language. Since: JPA 1.0

JPA Method in javax.persistence. Query Parameter getParameter (   int position ... . This method is not required to be supported for native queries . Parameters: position - position Return ... does not exist IllegalStateException - if invoked on a native query when the implementation does not support this use Since: JPA 2.0

JPA Method in javax.persistence. Query Parameter getParameter (   String name ... required to be supported for native queries . Parameters: name - parameter name Return: parameter ... IllegalStateException - if invoked on a native query when the implementation does not support this use Since: JPA 2.0

JPA Method in javax.persistence. Query FlushModeType getFlushMode () Get the flush mode in effect for the query execution. If a flush mode has not been set for the query object, returns the flush mode in effect for the entity manager. Return: flush mode Since: JPA 2.0

JPA Method in javax.persistence. Query Query setFirstResult (   int startPosition ) Set the position of the first result to retrieve. Parameters: startPosition - position of the first result, numbered from 0 Return: the same query instance Throws: IllegalArgumentException - if the argument is negative Since: JPA 1.0

JPA Method in javax.persistence. Query int getMaxResults () The maximum number of results the query object was set to retrieve. Returns Integer.MAX_VALUE if setMaxResults was not applied to the query object. Return: maximum number of results Since: JPA 2.0

JPA Method in javax.persistence. Query Query setMaxResults (   int maxResult ) Set the maximum number of results to retrieve. Parameters: maxResult - maximum number of results to retrieve Return: the same query instance Throws: IllegalArgumentException - if the argument is negative Since: JPA 1.0

JPA Method in javax.persistence. Query Map getHints () Get the properties and hints and associated values that are in effect for the query instance. Return: query properties and hints Since: JPA 2.0

JPA Method in javax.persistence. Query T unwrap (   Class  cls ) Return an object of the specified type to allow access to the provider-specific API. If the provider's query ... - the class of the object to be returned. This is normally either the underlying query implementation

JDO Method in javax.jdo. Query void addSubquery (    Query  sub,     ... ;   String parameter ) Add a subquery to this query . The String version of the method ... : sub - the subquery to add to this Query variableDeclaration - the name of the variable to be used

JDO Method in javax.jdo. Query void addSubquery (    Query  sub,     ... a subquery to this query . Parameters: sub - the subquery to add to this Query variableDeclaration - the name of the variable in the outer query to bind the results of the subquery

JDO Method in javax.jdo.PersistenceManager Query newQuery (   String language,    Object  query ) Create a new Query using the specified language. Parameters: language - the language of the query parameter query - the query , which is of a form determined by the language Return: the new Query Since: JDO 1.0

JDO Method in javax.jdo.PersistenceManager Query newQuery (   String  query ) Create a Construct a new query instance using the specified String as the single-string representation of the query . Parameters: query - the single-string query Return: the new Query Since: JDO 2.0

JDO Method in javax.jdo. Query void setResult (   String data ) Specifies what type of data this query should return. If this is unset or set to null , this query returns instances of the query's candidate class. If set, this query will return expressions, including field values

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

JDO Method in javax.jdo. Query void setIgnoreCache (   boolean ignoreCache ) Set ... the PersistenceManager used to create this Query . The ignoreCache option setting specifies whether the query should execute entirely in the back end, instead of in the cache. If this flag is set

JDO Annotation Queries Target: ElementType.TYPE Implemented Interfaces: Annotation Annotation for a group of named queries . Since: JDO 2.1 Public Annotation Attributes Query [] value default null The named queries Since: JDO 2.1

JDO Method in javax.jdo. Query Object executeWithArray (   Object... parameters ) Execute the query and return the filtered Collection . The execution of the query obtains the values ... compatible to the Class of the query . It is then evaluated by the Boolean expression of the filter

JDO Method in javax.jdo. Query void close (   Object queryResult ) Close a query ... (...) 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

JDO Method in javax.jdo. Query PersistenceManager getPersistenceManager () Get the PersistenceManager associated with this Query . If this Query was restored from a serialized form, it has no PersistenceManager , and this method returns null . Return: the PersistenceManager associated with this Query . Since: JDO 1.0

JDO Method in javax.jdo. Query FetchPlan getFetchPlan () Returns the FetchPlan used by this Query . Modifications of the returned fetch plan will not cause this query's owning PersistenceManager 's FetchPlan to be modified. Return: the fetch plan used by this query Since: JDO 2.0

JDO Method in javax.jdo. Query void setFilter (   String filter ) Set the filter for the query . The filter specification is a String containing a Boolean expression ... to the candidate Class of the Query ; and for all variables there exists a value for which the filter

JDO Method in javax.jdo. Query void declareParameters (   String parameters ) Declare the list of parameters query execution. The parameter declaration is a String containing one or more query parameter declarations separated with commas. Each parameter named in the parameter

JDO Method in javax.jdo. Query void setRange (   String fromInclToExcl ) Set ... setRange("50, :to"); . The execution of the query is modified to return only a subset of results ... and the remaining 30 results are ignored. An implementation should execute the query such that the range

JDO Method in javax.jdo. Query void setUnique (   boolean unique ) Specify that only the first result of the query should be returned, rather than a collection. The execute method will return null if the query result size is 0. Parameters: unique - if true, only one element is returned Since: JDO 2.0

JDO Method in javax.jdo. Query void setRange (   long fromIncl,    long toExcl ) Set the range of results to return. The execution of the query is modified ... should execute the query such that the range algorithm is done at the data store. Parameters: fromIncl - 0