About variable

1-10 of 117Refresh
Manual
173

FROM clause (JPQL / Criteria API)

The FROM clause declares query identification variables that represent iteration over objects in the database. A query identification variable is similar to a variable of a Java enhanced for loop in a program, since both are used for iteration over objects. Range Variables Range variables are query
JPA Doc
104

Criteria Query From Elements

Variables The FROM clause in JPA queries (as in SQL) defines the query variables. Query variables are represented in criteria queries by descendant interfaces of the From interface: Range variables (bound by an entity class) are represented by the Root subinterface: Join variables (bound by
JDO Doc
104

declareVariables(variables)

Method 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 one or more unbound variable
JDO Doc
94

Constants.OPTION_UNCONSTRAINED_QUERY_VARIABLES

Static Field javax.jdo.Constants String OPTION_UNCONSTRAINED_QUERY_VARIABLES "javax.jdo.option.UnconstrainedQueryVariables" Since: JDO 2.1 See Also: PersistenceManagerFactory.supportedOptions()
Manual
63

Paths and Types in JPQL and Criteria API

classes) are represented in JPQL by the following types of expressions: Variables - FROM identification variables and SELECT result variables. Parameters - when instances of these classes are assigned ... with an instance of a user defined class (represented by a variable, parameter or prefix path expression
Manual
53

JPA Query Structure (JPQL / Criteria)

clause declares one or more query variables (also known as identification variables). Query variables are similar to loop variables in programing languages. Each query variable represents iteration over objects in the database. A query variable that is bound to an entity class is referred to as
Forum
41

JPA JPQL WHERE clause for IN :variable not working if variable is a list of Enums

JPA JPQL WHERE clause for IN :variable not working if variable is a list of Enums
Manual
41

WHERE clause (JPQL / Criteria API)

variable. Before passing these Country objects to the SELECT clause for collecting as query results ... difference in query execution time if proper indexes are defined. WHERE Filter in Multi Variable Queries In a multi-variable query the FROM clause defines iteration on tuples. In this case the WHERE clause
Manual
33

DELETE Queries in JPA/JPQL

instances: DELETE FROM Country       // no variable DELETE FROM Country c     // an optional variable DELETE FROM Country AS c  // AS + an optional variable ObjectDB supports using the java.lang ... cannot include multiple variables and JOIN, and cannot include the GROUP BY, HAVING and ORDER BY clauses
Manual
33

ORDER BY clause (JPQL / Criteria API)

Alias variables are referred to as result variables to distinguish them from the identification variables that are defined in the FROM clause. Order Direction (ASC, DESC) The default ordering direction ... "))); Unlike other methods for setting criteria query clauses - the orderBy method takes a variable number