ObjectDB Database Search

Querying without indexes requires sequential iteration over entities in the database. If many ... this full iteration, allowing complex queries over millions of objects to execute quickly ... lastName; Address address; : } Indexes in queries ObjectDB manages a B-tree for every index. A B-tree

to specify a constructor that is applied to the results of the query execution. If the constructor is for an entity class, the resulting entities will be in the new state after the query is executed ... result type. Parameters: resultClass - type of the query result Returns: criteria query object

distinct ) Specify whether duplicate query results are eliminated. A true value will cause duplicates ... Persistence (JPA) 1.0 Class getResultType () Return the result type of the query or subquery ... . If the query was created using the createTupleQuery method, the result type is Tuple

the query result or whether they must be retained Returns: the modified query . Since: Jakarta ... . Since: Jakarta Persistence (JPA) 1.0 Class getResultType () Return the result type of the query or subquery ... is returned. If the query was created using the createTupleQuery method, the result type is Tuple

Most JPQL queries use at least one comparison operator in their WHERE clause. Comparison operators ... (the JDO Query Language). ObjectDB supports both forms. In addition to the different notation ... how each comparison operator handles NULL values. One column shows the result of comparing a NULL value

several server-side caches: Cache of database file pages . Cache of query programs . Cache of query execution results . The scope of these server-side caches is wider because they exist per database ... for a specific retrieval operation: // Before executing a query : query . setHint ("jakarta.persistence.cache

or implicitly as a result of a cascade operation. Explicit remove To delete an entity from ... the database. DELETE Queries DELETE queries provide an alternative way to remove entities from the database. They are especially useful for deleting many entities in a single operation. For more information, see DELETE Queries in JPA/JPQL .

mode can also be set for a query to lock all the query result objects. When a retrieval operation ... query . Releasing a Pessimistic Lock Pessimistic locks are automatically released at the end

entities efficiently in the database. This technique is especially useful for queries that return large result sets. For example, consider a real-time system that detects events from various sensors ... , sensor ID, and other details. Suppose that queries to retrieve all events from a specific sensor in

query construction. Since: Jakarta Persistence (JPA) 2.0 Public Instance Methods Selection alias ... does not cause type conversion: the runtime type is not changed. Warning: may result in a runtime ... Expression.as , this method does result in a runtime type conversion. Providers are required

The MapJoin interface is the type of the result of joining to a collection over an association or element ... : may result in a runtime failure. Inherited from Expression Parameters: type - intended type ... expression object. Unlike Expression.as , this method does result in a runtime type conversion

of the result of joining to a collection over an association or element collection ... cause type conversion: the runtime type is not changed. Warning: may result in a runtime failure ... Expression.as , this method does result in a runtime type conversion. Providers are required to support

interface is the type of the result of joining to a collection over an association or element collection ... : may result in a runtime failure. Inherited from Expression Parameters: type - intended type ... expression object. Unlike Expression.as , this method does result in a runtime type conversion

of the result of joining to a collection over an association or element collection ... not cause type conversion: the runtime type is not changed. Warning: may result in a runtime failure ... Expression.as , this method does result in a runtime type conversion. Providers are required

, TupleElement A root type in the from clause. Query roots always reference entities. Since: Jakarta ... . Warning: may result in a runtime failure. Inherited from Expression Parameters: type - intended type ... , returning a new expression object. Unlike Expression.as , this method does result in a runtime type

. Warning: may result in a runtime failure. Inherited from Expression Parameters: type - intended type ... , returning a new expression object. Unlike Expression.as , this method does result in a runtime type ... : the resulting fetch join. Since: Jakarta Persistence (JPA) 1.0 Fetch fetch ( SingularAttribute attribute

conversion: the runtime type is not changed. Warning: may result in a runtime failure. Inherited from ... , this method does result in a runtime type conversion. Providers are required to support casting ... : attribute - target of the join Returns: the resulting fetch join. Since: Jakarta Persistence (JPA

. Annotations for defining Native SQL queries and result set mappings. ... behavior. Declare static, reusable JPQL queries directly on the entity class. Optimize data retrieval by

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

of the result of the native SQL query . Query names are scoped to the persistence unit. A named query ... how the native SQL query result set should be interpreted, for example: @NamedNativeQuery( name ... query result . If a result set mapping is specified, the specified result class must agree

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 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 setTimeout (    Integer timeout ) Set the query timeout, in milliseconds. This is a hint, and is an alternative to setting the hint jakarta.persistence. query .timeout . Parameters: timeout - the timeout, in milliseconds

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 (    ... - 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 is of incorrect

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 is of incorrect

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Query setParameter (    ... - 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 is of incorrect type

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 (    ... 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 Query setCacheRetrieveMode (   ... during query execution. This cache retrieval mode overrides the cache retrieve mode in use by the entity manager. Parameters: cacheRetrieveMode - cache retrieval 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 ... . 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 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 (    ... 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 (    ... 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 should use

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

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

( 20 ): You may click Preview Results  to see the query results : Close the dialog box by clicking ... Queries against the database are represented in BIRT as data sets. To create the data set: Open ... this tutorial contains Point entities. We will use a simple JPQL query that retrieves points with x value in