ObjectDB Database Search

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

JPA Method in javax.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 been bound Since: JPA 2.0

JPA Method in javax.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 javax.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 javax.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

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

are represented in queries by entity names . By default, the entity name is the unqualified name ... . their instances cannot be shared by different entity objects and they cannot be queried directly), so a decision ... ). It simplifies queries on dates and ranges of dates. When an entity is stored, its date and time fields

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

retrieval operation or query . Releasing a Pessimistic Lock Pessimistic locks are automatically ... can also be set for a query in order to lock all the query result objects. When a retrieval operation includes

in the database in an efficient way. This is especially useful when using queries that return large ... time, sensor ID and additional details. Suppose that queries that retrieve all the events ... , the following primary key can significantly improve query run performance: @Entity public class Event

for Query instances, which are needed for executing queries on the database. Every JPA implementation

The ObjectDB BIRT/ODA driver is an extension of the open source Business Intelligence and Reporting Tools (BIRT) that adds support of ObjectDB as a data source and JPQL as a data set query ... ) and click Next . Entry a JPQL or a JDOQL query and click Finish . See the Report Generation

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

getAllGuests() { TypedQuery query = em.createQuery( "SELECT g FROM Guest g ORDER BY g.id", Guest.class); return query .getResultList(); } } The  GuestDao session bean (EJB) class defines two methods

() { TypedQuery query = em.createQuery( "SELECT g FROM Guest g ORDER BY g.id", Guest.class); return query .getResultList(); } } The GuestDao Spring component class defines two methods: persist

getAllGuests() { TypedQuery query = em.createQuery( "SELECT g FROM Guest g ORDER BY g.id", Guest.class); return query .getResultList(); } } The GuestDao Spring component class defines two methods: persist

JDO Annotation Attribute in javax.jdo.annotations. Queries Query [] value default null The named queries 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

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

JDO Method in javax.jdo. Query void declareVariables (   String variables ) Declare the unbound variables to be used in the query . Variables might be used in the filter, and these variables must be declared with their type. The unbound variable declaration is a String containing

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 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 Method in javax.jdo. Query void declareImports (   String imports ) Set the import statements to be used to identify the fully qualified name of variables or parameters. Parameters and unbound variables might come from a different class from the candidate class, and the names

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

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

and delete database objects. Chapter 7 - JDOQL Queries Describes JDOQL, the JDO Query Language. The last