ObjectDB Database Search

JPA Interface Query Interface used to control query execution. See Also: TypedQuery StoredProcedureQuery Parameter Since: JPA 1.0 Chapter 4 - JPA Queries (JPQL / Criteria) explains how to use Query ... of entities updated or deleted Throws: IllegalStateException - if called for a Java Persistence query

after retrieval by a special automatic query . Note : Navigation through inverse fields is much less efficient than navigation through ordinary persistent fields, since it requires running queries . Inverse ... the following query (where :d represents the Department entity): SELECT e FROM Employee e WHERE e

Querying without indexes requires iteration over entity objects in the database one by ... indexes the iteration can be avoided and complex queries over millions of objects can be executed quickly ... firstName; String lastName; Address address; : } Indexes in Queries ObjectDB manages a BTree

. Starting Online Backup The online backup can be started by executing a special query on an EntityManager ... ; em.createQuery("objectdb backup").getSingleResult(); The backup query string is always exactly ... directory can be specified by setting the target parameter before executing the backup query :  

Logical operators in JPQL and in JPA criteria queries enable composition of complex JPQL boolean ... , the JDO Query Language). ObjectDB supports both forms. Binary AND (&&) Operator The following query retrieves countries whose population and area (both) exceed specified limits: SELECT c FROM

;name,     Query   query ) Define the query , typed query , or stored procedure query as a named query such that future query objects can be created from it using the createNamedQuery or createNamedStoredProcedureQuery method. Any configuration of the query object (except for actual

JPA Method in javax.persistence. Query Query setLockMode (    LockModeType  lockMode ) Set the lock mode type to be used for the query execution. Parameters: lockMode - lock mode Return: the same query instance Throws: IllegalStateException - if the query is found not to be a Java

JPA Method in javax.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 ... for a Java Persistence query language UPDATE or DELETE statement QueryTimeoutException - if the query

JPA Method in javax.persistence. Query List getResultList () Execute a SELECT query and return the query results as an untyped List. Return: a list of the results Throws: IllegalStateException - if called for a Java Persistence query language UPDATE or DELETE statement QueryTimeoutException

and the other for checking a persistent field of an entity object. Retrieval by Query The most flexible method for retrieving objects from the database is to use queries . The official query language of JPA is JPQL (Java Persistence Query Language). It enables retrieval of objects from the database by

of NoSQL technology, which are weak query capabilities and lack of ACID (atomicity, consistency, isolation, durability). Unlike other NoSQL solutions, ObjectDB provides full support of rich complex queries , using two standard Java query languages: JPQL (Java Persistence Query Language) and JDOQL (JDO

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

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

classes are not included in the extents of their classes, so they cannot be iterated or queried directly ... one. If more selective retrieval is needed, a Query can be used to retrieve only objects that satisfy some ... (the commented line in the code above). Retrieval by Query The most advanced method for retrieving objects from

of queries against the class instances. However, maintaining an extent for a class has some overhead ... are not included in the extents of their classes, so they cannot be queried directly. When the embedded ... ;Index Definition Querying a large extent without indexes may take a significant amount of time

JDO Annotation Query Target: ElementType.TYPE Implemented Interfaces: Annotation Annotation for a named query . Corresponds to the xml element " query ". Since: JDO 2.1 Public Annotation Attributes ... "" The name of the fetch plan used by this query Since: JDO 2.1 String language default "JDOQL" The query

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 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 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