ObjectDB Database Search

JPA Method in jakarta.persistence. Query T unwrap (   Class  cls ) Return an object ... of Query does not support the given type, the PersistenceException is thrown. Parameters: cls ... Query } or an interface it implements. Return: an instance of the specified class Throws

JDO Method in javax.jdo. Query void setRange (   String fromInclToExcl ) Set ... setRange("50, :to"); . The execution of the query is modified to return only a subset of results ... and the remaining 30 results are ignored. An implementation should execute the query such that the range

JDO Method in javax.jdo. Query void setUnique (   boolean unique ) Specify that only the first result of the query should be returned, rather than a collection. The execute method will return null if the query result size is 0. Parameters: unique - if true, only one element is returned Since: JDO 2.0

JDO Method in javax.jdo. Query void setRange (   long fromIncl,    long toExcl ) Set the range of results to return. The execution of the query is modified ... should execute the query such that the range algorithm is done at the data store. Parameters: fromIncl - 0

JDO Method in javax.jdo. Query void setResultClass (   Class cls ) Specify the type ... of the query . If the result consists of one expression, the result class defaults to the type ... expression and the second argument is the value from the query result. Portable result classes do not

JDO Method in javax.jdo. Query Object executeWithMap (   Map parameters ) Execute the query and return the filtered Collection . The query is executed with the parameters set by the Map values. Each Map entry consists of a key which is the name of the parameter in

JDO Method in javax.jdo. Query void setClass (   Class cls ) Set the class of the candidate instances of the query . The class specifies the class of the candidates of the query . Elements of the candidate collection that are of the specified class are filtered before being put into

JDO Method in javax.jdo. Query void compile () Verify the elements of the query and provide a hint to the query to prepare and optimize an execution plan. Since: JDO 1.0

JDO Annotation Attribute in javax.jdo.annotations. Queries Query [] value default null The named queries Since: JDO 2.1

JPA Annotation Attribute in jakarta.persistence.NamedNativeQuery String query default null The native SQL query string. Since: JPA 1.0

JPA Method in jakarta.persistence. Query T getParameterValue (    Parameter  param ) Return the input value bound to the parameter. (Note that OUT parameters are unbound.) Parameters ... is not a parameter of the query IllegalStateException - if the parameter has not been bound Since: JPA 2.0

JPA Static Field in jakarta.persistence.PersistenceConfiguration QUERY _TIMEOUT Default query timeout hint. Since: JPA 3.2

JDO Method in javax.jdo. Query void addExtension (   String key,    Object value ) Add a vendor-specific extension to this query . The key and value are not standard. An implementation must ignore keys that are not recognized. Parameters: key - the key

JDO Method in javax.jdo. Query long deletePersistentAll (   Map parameters ) Deletes all the instances of the candidate class that pass the filter. Parameters: parameters - for the query Return: the number of instances of the candidate class that were deleted See Also: deletePersistentAll () Since: JDO 2.0

JDO Method in javax.jdo. Query boolean isUnmodifiable () The unmodifiable flag, when set, disallows further modification of the query , except for specifying the range, result class, and ignoreCache option. Return: the current setting of the flag Since: JDO 2.0

JDO Method in javax.jdo. Query void setUnmodifiable () The unmodifiable flag, when set, disallows further modification of the query , except for specifying the range, result class, and ignoreCache option. The unmodifiable flag can also be set in metadata. Since: JDO 2.0

JDO Method in javax.jdo. Query long deletePersistentAll (   Object... parameters ) Deletes all the instances of the candidate class that pass the filter. Parameters: parameters - for the query Return: the number of instances of the candidate class that were deleted See Also: deletePersistentAll () Since: JDO 2.0

JDO Method in javax.jdo. Query void setCandidates (   Collection pcs ) Set the candidate Collection to query . Parameters: pcs - the candidate Collection . Since: JDO 1.0

JDO Method in javax.jdo. Query void setCandidates (    Extent  pcs ) Set the candidate Extent to query . Parameters: pcs - the candidate Extent . Since: JDO 1.0

JDO Method in javax.jdo. Query Object execute (   Object p1,    Object p2,    Object p3 ) Execute the query and return the filtered Collection . Parameters: p1 - the value of the first parameter declared. p2 - the value of the second parameter

JDO Method in javax.jdo. Query Object execute (   Object p1,    Object p2 ) Execute the query and return the filtered Collection . Parameters: p1 - the value of the first parameter declared. p2 - the value of the second parameter declared. Return: the filtered

JDO Method in javax.jdo. Query Object execute () Execute the query and return the filtered Collection. Return: the filtered Collection . See Also: executeWithArray (Object[] parameters) Since: JDO 1.0

JDO Method in javax.jdo. Query Object execute (   Object p1 ) Execute the query and return the filtered Collection . Parameters: p1 - the value of the first parameter declared. Return: the filtered Collection . See Also: executeWithArray (Object[] parameters) Since: JDO 1.0

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

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

JPA Method in jakarta.persistence. Query Integer getTimeout () The query timeout. Since: JPA 3.2

JDO Annotation Attribute in javax.jdo.annotations. Query String fetchPlan default "" The name of the fetch plan used by this query Since: JDO 2.1

JDO Annotation Attribute in javax.jdo.annotations. Query String unmodifiable default "" Whether the query is unmodifiable. Since: JDO 2.1

JDO Annotation Attribute in javax.jdo.annotations. Query String language default "JDOQL" The query language Since: JDO 2.1

JDO Annotation Attribute in javax.jdo.annotations. Query String unique default "" Whether the query returns a single unique result. Since: JDO 2.1

JDO Annotation Attribute in javax.jdo.annotations. Query String value default null The query string (mandatory) Since: JDO 2.1

JDO Annotation Attribute in javax.jdo.annotations. Query String name default null Name of the query (mandatory) Since: JDO 2.1

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 Return: boolean indicating whether parameter has been bound Since: JPA 2.0

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 Return: parameter value Throws: IllegalStateException

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 Return: parameter value Throws: IllegalStateException - if the parameter

JDO Method in javax.jdo. Query void setExtensions (   Map extensions ) Set multiple extensions, or use null to clear all extensions. Map keys and values are not standard. An implementation must ignore entries that are not recognized. Parameters: extensions - the map of extensions See Also: addExtension Since: JDO 2.0

JDO Method in javax.jdo. Query void setGrouping (   String group ) Set the grouping expressions, optionally including a "having" clause. When grouping is specified, each result expression must either be an expression contained in the grouping, or an aggregate evaluated once per group

JDO Method in javax.jdo. Query long deletePersistentAll () Deletes all the instances of the candidate class that pass the filter. Returns the number of instances of the candidate class that were deleted, specifically not including the number of dependent and embedded instances. Dirty instances

JDO Method in javax.jdo. Query void setOrdering (   String ordering ) Set the ordering specification for the result Collection . The ordering specification is a String containing one or more ordering declarations separated by commas. Each ordering declaration is the name of the field

JDO Method in javax.jdo. Query boolean getIgnoreCache () Get the ignoreCache option setting. Return: the ignoreCache option setting. See Also: setIgnoreCache Since: JDO 1.0

JDO Annotation Attribute in javax.jdo.annotations. Query Extension [] extensions default {} Vendor extensions. Since: JDO 2.1

JDO Annotation Attribute in javax.jdo.annotations. Query Class resultClass default void.class Result class into which to put the results. Since: JDO 2.1

do not support aggregate queries (max, min, count, sum and avg). ObjectDB supports rich queries , including aggregate queries , as part of its support of JPQL (JPA Query Language) and JDOQL (JDO Query Language). ObjectDB is faster than other products.

to automatic removal of that object from the database. DELETE Queries DELETE queries provide an alternative way for removing entity objects from the database. Deleting objects using a DELETE query ... ;The  DELETE Queries in JPA/JPQL  in chapter 4 explains how to use JPA DELETE queries .

Most JPQL queries use at least one comparison operator in their WHERE clause. Comparison Operators ... its own notation (which is also in use by JDOQL, the JDO Query Language). ObjectDB supports both forms ... . Equality operators (=, , == , != ) on strings in queries follow the logic of Java's equals

Queries UPDATE queries provide an alternative way of updating entity objects in the database. Modifying objects using an UPDATE query may be useful especially when many entity objects have to be modified in one operation. The UPDATE Queries in JPA/JPQL in chapter 4 explains how to use JPA UPDATE queries .

processes JPQL (JPA Query Language) and JDOQL (JDO Query Language) queries directly, where ORM tools first convert these queries to SQL and then transition the SQL to the DBMS for execution through a JDBC

side: Cache of database file pages . Cache of query programs . Cache of query execution results ... can also be overridden for a specific retrieval operation: // Before executing a query :    query . setHint

.getTransaction().commit();         Query query = em.createQuery("SELECT e FROM MyEntity e");         List resultList = query

Queries against the database are represented in BIRT as data sets. To create the data set: Open ... this tutorial contains Point entity objects. We will use a simple JPQL query that retrieves points with x ... copy and paste to enter the above query and click Finish . When the data set is created