ObjectDB Database Search

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 int getMaxResults() The maximum number of results the query object was set to retrieve. Returns Integer.java.lang.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 (    ... 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. 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) 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) 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

Jakarta Persistence (JPA) Method in jakarta.persistence. Query Object getParameterValue (    int position ) Return the input value bound to the positional parameter. (Note that OUT parameters are unbound.) Parameters: position - position Returns: parameter value. Throws

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

hi, We've hit again against troubles with the variable naming when trying to get the query string ... us without ordering. The issue is that the name of the root variable is $1 as well as the name of our left join variable becomes $1. We're also adding a custom function expression in where clause

, derived attributes, grouping queries and aggregate queries ) which are usually missing from Object Oriented ... . Query program cache (for repeating queries with different arguments). Query result cache (for repeating queries with the same arguments). Many other internal caches. Indexing Single field and multi field

to view data in ObjectDB databases, execute JPQL and JDOQL queries and edit the content of databases ... and embeddable classes) in the database and their persistent fields and indexes. The [ Query ] window enables running JPQL and JDOQL queries , as discussed below. Closing a Database Connection Use the File Close

by ObjectDB to be a database URL rather than a persistence unit name. The $objectdb variable

: Query Interface used to control stored procedure query execution. Stored procedure query execution ... on an unexecuted stored procedure query before processing getResultList or getSingleResult . When executeUpdate ... procedure query , followed by getUpdateCount . The results of executeUpdate

query construction. Since: Jakarta Persistence (JPA) 2.0 Public Instance Methods Selection alias ... to avoid the use of Path variables . For example: CriteriaQuery q = cb.createQuery(Person.class); Root p ... a compound selection. Modifications to the list do not affect the query . Inherited from Selection

, TupleElement A root type in the from clause. Query roots always reference entities. Since: Jakarta ... the Path.get operation in order to avoid the use of Path variables . For example: CriteriaQuery q ... a compound selection. Modifications to the list do not affect the query . Inherited from Selection Returns

Jakarta Persistence (JPA) Interface jakarta.persistence.TypedQuery Type Parameters: - query result type Super Interfaces: Query Interface used to control the execution of typed queries . See Also: Query Parameter Since: Jakarta Persistence (JPA) 2.0 Chapter 4 - JPA Queries (JPQL / Criteria

the use of Path variables . For example: CriteriaQuery q = cb.createQuery(Person.class); Root p = q.from ... selection. Modifications to the list do not affect the query . Inherited from Selection Returns: list ... if no fetch joins have been made from this type. Modifications to the set do not affect the query

the use of Path variables . For example: CriteriaQuery q = cb.createQuery(Person.class); Root p = q ... a compound selection. Modifications to the list do not affect the query . Inherited from Selection Returns ... the query . Inherited from FetchParent Returns: fetch joins made from this type. Since: Jakarta Persistence

.get operation in order to avoid the use of Path variables . For example: CriteriaQuery q = cb.createQuery ... the selection items composing a compound selection. Modifications to the list do not affect the query ... to the set do not affect the query . Inherited from FetchParent Returns: fetch joins made from this type

to avoid the use of Path variables . For example: CriteriaQuery q = cb.createQuery(Person.class); Root p = q ... a compound selection. Modifications to the list do not affect the query . Inherited from Selection ... the query . Inherited from FetchParent Returns: fetch joins made from this type. Since: Jakarta

of Path variables . For example: CriteriaQuery q = cb.createQuery(Person.class); Root p = q.from(Person ... the query . Inherited from Selection Returns: list of selection items. Throws: IllegalStateException ... to the set do not affect the query . Inherited from FetchParent Returns: fetch joins made from this type

the Path.get operation in order to avoid the use of Path variables . For example: CriteriaQuery q = cb ... items composing a compound selection. Modifications to the list do not affect the query . Inherited from ... do not affect the query . Inherited from FetchParent Returns: fetch joins made from this type

(which modify the database) have to be recorded. For debugging of query failure ... to accelerate the execution of relevant queries . The element The element specifies settings of the two cache mechanisms that ObjectDB manages for queries : The results attribute specifies the size

with no parameters, and have no final methods or persistent instance variables . An enum, record, or ... of the entity class. This name is used to refer to the entity in queries . The name must not be a reserved literal in the Jakarta Persistence query language. Default: "" Since: Jakarta Persistence (JPA) 1.0

the use of Path variables . For example: CriteriaQuery q = cb.createQuery(Person.class); Root p = q.from ... the selection items composing a compound selection. Modifications to the list do not affect the 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 :