Internal Website Search

JPA Method in javax.persistence. Query Parameter getParameter (   String name ... required to be supported for native queries . Parameters: name - parameter name Return: parameter ... IllegalStateException - if invoked on a native query when the implementation does not support this use Since: JPA 2.0

JPA Method in javax.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. Return: flush mode Since: JPA 2.0

JPA Method in javax.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 Return: the same query instance Throws: IllegalArgumentException - if the argument is negative Since: JPA 1.0

JPA Method in javax.persistence. Query int getMaxResults () The maximum number of results the query object was set to retrieve. Returns Integer.MAX_VALUE if setMaxResults was not applied to the query object. Return: maximum number of results Since: JPA 2.0

JPA Method in javax.persistence. Query Query setMaxResults (   int maxResult ) Set the maximum number of results to retrieve. Parameters: maxResult - maximum number of results to retrieve Return: the same query instance Throws: IllegalArgumentException - if the argument is negative Since: JPA 1.0

JPA Method in javax.persistence. Query Map getHints () Get the properties and hints and associated values that are in effect for the query instance. Return: query properties and hints Since: JPA 2.0

JPA Method in javax.persistence. Query T unwrap (   Class  cls ) Return an object of the specified type to allow access to the provider-specific API. If the provider's query ... - the class of the object to be returned. This is normally either the underlying query implementation

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

.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

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

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

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