ObjectDB Database Search

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 ... to the transaction. Since: Jakarta Persistence (JPA) 3 .2 Integer getTimeout () The query timeout

Persistence (JPA) 3 .2 Query createQuery ( CriteriaUpdate updateQuery ) Create an instance of Query ... their primary key, and execute queries which range over entity types. An entity may be disassociated from ... must also be flushed before execution of any query whose result set would be affected by unflushed modifications

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

Jakarta Persistence API (JPA) 3 .2 documentation, generated from the official JavaDoc and enriched ... , query facilities, metamodel details, configuration options, annotations, and exception information ... the fundamental classes and interfaces for entity management and persistence operations. Covers the query API

the results of the second query from the results of the first query . Since: Jakarta Persistence (JPA) 3 .2 ... from the results of the first query . Since: Jakarta Persistence (JPA) 3 .2 Predicate exists ( Subquery ... criteria queries , compound selections, expressions, predicates, orderings. Note that Predicate

) 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 ... , CommonAbstractCriteria The CriteriaQuery interface defines functionality that is specific to top-level queries

(    String 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 ... of the query object (except for actual parameter binding) in effect when the named query is added

(JPA) 3 .2 Root from ( Class entityClass ) Create and add a query root corresponding to the given ... more restriction predicates Returns: the modified query . Since: Jakarta Persistence (JPA) 3 .2 Predicate in ... : restrictions - a list of zero or more restriction predicates Returns: the modified query . Since: Jakarta Persistence (JPA) 3 .2

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setLockMode (    LockModeType lockMode ) Set the lock mode type to be used for the query execution. Parameters: lockMode - lock mode Returns: the same query instance. Throws: IllegalStateException - if the query is found

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 Stream getResultStream() Execute a SELECT query and return the query results as an untyped java.util.stream.Stream . By default ... if there are no results. Throws: IllegalStateException - if called for a Jakarta Persistence query

Jakarta Persistence (JPA) Method in jakarta.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. Returns: lock mode. Throws: IllegalStateException - if the query is found not to be a Jakarta

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 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 . Returns: set

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Parameter getParameter (    ... parameter of the given name and type. This method is required to be supported for criteria queries ... : IllegalStateException - if invoked on a native query or Jakarta Persistence query language query

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

(PersistenceConfiguration) Starting with  JPA 3 .2 , it is no longer mandatory to use a  persistence.xml   ... that use annotations to define generators and named queries . Otherwise, these generators and named queries are available only after their containing classes become known to ObjectDB—for example, when the first instance of a class is stored in the database.

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 Parameter getParameter (    int position ,    Class type ) Get the parameter object corresponding to the declared ... : IllegalStateException - if invoked on a native query or Jakarta Persistence query language 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

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 . Since: Jakarta Persistence (JPA) 2.0

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

Jakarta Persistence (JPA) Method in jakarta.persistence.NamedNativeQuery String query The native SQL query string. Since: Jakarta Persistence (JPA) 1.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 ... - 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) Field in jakarta.persistence.PersistenceConfiguration QUERY _TIMEOUT Default query timeout hint. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Field in jakarta.persistence.QueryTimeoutException query Since: Jakarta Persistence (JPA) 1.0

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 are unbound.) Parameters: name - parameter name Returns: parameter value. Throws: IllegalStateException

Transaction (as shown in section 5. 3 ) or at the PersistenceManagerFactory level as a default ... .getRestoreValues(); Transaction modes are discussed in section 5. 3 , which deals with transactions. 5 ... that at some level a proper try-catch block exists. 5. 3   javax.jdo.Transaction The javax.jdo

of objects per second. Even queries on millions of objects are very fast, when proper indexes are defined ... with every ObjectDB product, is a sophisticated tool that enables browsing, querying , editing and the construction ... programming without the ability to explore, query and edit the database content visually, is like

on programming with ObjectDB and JDO: Chapter 3 - Persistent Classes Explains what a persistence capable ... and delete database objects. Chapter 7 - JDOQL Queries Describes JDOQL, the JDO Query Language. The last