ObjectDB Database Search

. Parameters: cacheStoreMode - cache storage mode Returns: the same query instance. Since: Jakarta Persistence (JPA) 3. 2 ... Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setCacheStoreMode (    CacheStoreMode cacheStoreMode ) Set the cache storage mode that is in effect during query

Jakarta Persistence (JPA) Method in jakarta.persistence. Query int getMaxResults() The maximum number of results the query object was set to retrieve. Returns Integer#MAX_VALUE if Query .setMaxResults was not applied to the query object. Returns: maximum number of results. Since: Jakarta Persistence (JPA) 2 .0

- parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query . Since: Jakarta Persistence (JPA) 2 .0 ... Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (   

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (    ... - parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query . Deprecated: Newly-written

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (    ... object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query . Deprecated: Newly-written code

Jakarta Persistence (JPA) Method in jakarta.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. Returns: position of the first result. Since: Jakarta Persistence (JPA) 2 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Parameter getParameter (    ... . This method is not required to be supported for native queries . Parameters: name - parameter name Returns: parameter object. Throws: IllegalStateException - if invoked on a native query

Jakarta Persistence (JPA) Method in jakarta.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. Returns: flush mode. Since: Jakarta Persistence (JPA) 2 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Parameter getParameter (    ... with the given position. This method is not required to be supported for native queries . Parameters ... query when the implementation does not support this use. IllegalArgumentException - if the parameter

Jakarta Persistence (JPA) Method in jakarta.persistence. Query T unwrap (    Class cls ... implementation of Query does not support the given type, the PersistenceException is thrown ... implementing Query or an interface it implements. Returns: an instance of the specified class. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Map getHints() Get the properties and hints and associated values that are in effect for the query instance. Returns: query properties and hints. Since: Jakarta Persistence (JPA) 2 .0

- if the parameter has not been bound. IllegalArgumentException - if the parameter is not a parameter of the query . Since: Jakarta Persistence (JPA) 2 .0 ... Jakarta Persistence (JPA) Method in jakarta.persistence. Query T getParameterValue (    Parameter param ) Return the input value bound to the parameter. (Note that OUT parameters

Jakarta Persistence (JPA) Method in jakarta.persistence. Query CacheRetrieveMode getCacheRetrieveMode() The cache retrieval mode that will be in effect during query execution. Since: Jakarta Persistence (JPA) 3. 2

Jakarta Persistence (JPA) Method in jakarta.persistence. Query CacheStoreMode getCacheStoreMode() The cache storage mode that will be in effect during query execution. Since: Jakarta Persistence (JPA) 3. 2

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Integer getTimeout() The query timeout. Since: Jakarta Persistence (JPA) 3. 2

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Object getParameterValue (    String name ) Return the input value bound to the named parameter. (Note that OUT parameters ... name does not exist. Since: Jakarta Persistence (JPA) 2 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Object getParameterValue (    int position ) Return the input value bound to the positional parameter. (Note ... with the specified position does not exist. Since: Jakarta Persistence (JPA) 2 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. Query boolean isBound (    Parameter param ) Return a boolean indicating whether a value has been bound to the parameter. Parameters: param - parameter object Returns: boolean indicating whether parameter has been bound. Since: Jakarta Persistence (JPA) 2 .0

, derived attributes, grouping queries and aggregate queries ) which are usually missing from Object Oriented ... Objects (JDO) Complete JDO 2 support (passed the JDO 2 TCK). Support for JDO 3 new features is in ... entity data cache  (per EntityManagerFactory). Database file page cache . Query program cache

. 2 CacheStoreMode getCacheStoreMode () The cache storage mode that will be in effect during query execution. Inherited from Query Since: Jakarta Persistence (JPA) 3. 2 int getFirstResult () The position ... Persistence (JPA) 2 .0 The Running JPA Queries article explains how to use getFirstResult

. See Also: Query Parameter Since: Jakarta Persistence (JPA) 2 .0 Chapter 4 - JPA Queries (JPQL / Criteria ... effect during query execution. Inherited from Query Since: Jakarta Persistence (JPA) 3. 2 CacheStoreMode ... . Inherited from Query Since: Jakarta Persistence (JPA) 3. 2 int getFirstResult () The position of the first

is structured as follows: Criteria Query From Components in Jakarta Persistence (JPA) 3. 2   Criteria query variables The FORM clause in queries defines query variables, which act as loop ... clause of a query . These interfaces define query variables, including entity roots and various join types

. The page attribute specifies the size of a page in a database file. The default value of 2 KB ... , which modify the database. For debugging query failures, you might need to record "all" operations to reproduce ... can use the new indexes to accelerate relevant queries . The element The element specifies settings

graph. Since: Jakarta Persistence (JPA) 2 .1 Query createNamedQuery ( String name ) Create an instance ... - if no query has been defined with the given name. Since: Jakarta Persistence (JPA) 2 .1 Query ... Persistence (JPA) 3. 2 Query createQuery ( CriteriaUpdate updateQuery ) Create an instance of Query

the Level 2 (L2) cache, if enabled. JPA then adds the new entity to the persistence context as a managed ... its persistence context, it returns the existing managed object without querying the database. Otherwise, JPA ... , getReference might return a hollow object instead of querying the database immediately. It never returns null

The FROM clause declares query identification variables for iterating over objects in the database. A query identification variable is similar to a variable in a Java enhanced for loop because both are used to iterate over objects. Range variables Range variables are query identification variables

query returns Country objects, which then become managed by the EntityManager instance em : TypedQuery query = em. createQuery ("SELECT c FROM Country c", Country.class); List results = query ... for deletion , and so on. Query results are not limited to entities. You can use almost any valid JPQL

Logical operators in JPQL and JPA criteria queries combine simple Boolean expressions to form ... the following table: Set 1: JPQL / SQL Set 2 : Java / JDO AND && OR || NOT ! JPQL uses SQL notation, while Java uses its own notation, which is also used by the JDO Query Language (JDOQL). ObjectDB

. Since: Jakarta Persistence (JPA) 2 .0 The JPA Criteria API Queries article explains how to use ... ) 3. 2 boolean isDistinct () Return whether duplicate query results must be eliminated or retained ... more restriction predicates Returns: the modified query . Since: Jakarta Persistence (JPA) 3. 2

Jakarta Persistence (JPA) Method in jakarta.persistence. Query List getResultList() Execute a SELECT query and return the query results as an untyped List . Returns: a list of the results, or ... query language UPDATE or DELETE statement. PessimisticLockException - if pessimistic locking fails

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Object getSingleResult() Execute a SELECT query that returns a single untyped result. Returns: the result. Throws: IllegalStateException - if called for a Jakarta Persistence query language UPDATE or DELETE statement

Jakarta Persistence (JPA) Method in jakarta.persistence. Query int executeUpdate() Execute ... : IllegalStateException - if called for a Jakarta Persistence query language SELECT statement or for a criteria query . PersistenceException - if the query execution exceeds the query timeout value set

Jakarta Persistence (JPA) Constructor in jakarta.persistence.QueryTimeoutException QueryTimeoutException (    Query query ) Constructs a new QueryTimeoutException exception with the specified query . Parameters: query - the query . Since: Jakarta Persistence (JPA) 1.0

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

Jakarta Persistence (JPA) Method in jakarta.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

Jakarta Persistence (JPA) Method in jakarta.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

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (    ... type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or if the value argument

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (    ... - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or if the value argument

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (    ... value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or if the value argument

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (    ... . Parameters: position - position value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (    ... - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or if the value argument

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (    ... : name - parameter name value - parameter value Returns: 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: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.NamedQuery String query () (Required) The query string in the Jakarta Persistence query language. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setMaxResults (    int maxResult ) Set the maximum number of results to retrieve. Parameters: maxResult - maximum number of results to retrieve Returns: the same query instance. Throws: IllegalArgumentException

Jakarta Persistence (JPA) Method in jakarta.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 Returns: the same query instance. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence.NamedNativeQuery String query () The native SQL query string. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Field in jakarta.persistence.PersistenceConfiguration QUERY _TIMEOUT Default query timeout hint. Since: Jakarta Persistence (JPA) 1.0

compatible with varags. Since: Jakarta Persistence (JPA) 2 .0 The JPA Criteria API Queries article ... operation Returns: the query object. Since: Jakarta Persistence (JPA) 2 .1 CriteriaQuery createQuery ... the results of the second query from the results of the first query . Since: Jakarta Persistence (JPA) 3. 2

of persistent types is available at section 3. 2 ). ObjectDB provides an additional storing method ... classes are not included in the extents of their classes, so they cannot be iterated or queried directly (an embedded object can only be retrieved using a reference from its containing object). 6. 2  

. Therefore, only the first metadata for a class in the search order specified above has effect. 4. 2    ... of queries against the class instances. However, maintaining an extent for a class has some overhead ... for determining if a field is persistent are explained in section 3. 2 . The persistence-modifier