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

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 ... by different entity objects and they cannot be queried directly), so a decision whether to declare ... . It is more efficient (storage and retrieval are faster). It simplifies queries on dates and ranges

.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 an efficient way. This is especially useful when using queries that return large result sets. As ... and additional details. Suppose that queries that retrieve all the events of a specified sensor in ... primary key can significantly improve query run performance: @Entity public class Event { @EmbeddedId

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

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

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