ObjectDB Database Search

Query parameters enable you to define reusable queries. You can execute these queries with different parameter values to retrieve different results. Executing the same query multiple times with different parameter values is more efficient than using a new query string for each execution

Jakarta Persistence (JPA) Interface jakarta.persistence. Parameter Type Parameters : - the type of the parameter Type for query parameter objects. See Also: Query TypedQuery Since: Jakarta Persistence (JPA) 2.0 Chapter 4 - JPA Queries (JPQL / Criteria) explains how to use Parameter . Public Instance

; Parameter param ) Return the input value bound to the parameter . (Note that OUT parameters are unbound.) Parameters : param - parameter object Returns: parameter value. Throws: IllegalStateException - if the parameter has not been bound. IllegalArgumentException - if the parameter is not a parameter of the query. Since: Jakarta Persistence (JPA) 2.0

;  Parameter param ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a Parameter object. Parameters : temporalType - temporal type param - parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException

;  Parameter param ,    T value ) Bind the value of a Parameter object. Parameters : param - parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query. Since: Jakarta Persistence (JPA) 1.0

;  Parameter param ,    Calendar value ,    TemporalType temporalType ) Bind an instance of Calendar to a Parameter object. Parameters : temporalType - temporal type param - parameter object value - parameter value Returns: the same query instance. Throws

setParameter (    Parameter param ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a Parameter object. Parameters : temporalType - temporal type param - parameter object value - parameter value Returns: the same query instance. Throws

setParameter (    Parameter param ,    T value ) Bind the value of a Parameter object. Parameters : param - parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query. Since: Jakarta Persistence (JPA) 1.0

setParameter (    Parameter param ,    Calendar value ,    TemporalType temporalType ) Bind an instance of Calendar to a Parameter object. Parameters : temporalType - temporal type param - parameter object value - parameter value Returns: the same query instance. Throws

; Parameter param ,    T value ) Bind the value of a Parameter object. Parameters : param - parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter does not correspond to a parameter of the query. Since: Jakarta Persistence (JPA) 2.0

; Parameter param ,    Calendar value ,    TemporalType temporalType ) Bind an instance of Calendar to a Parameter object. Parameters : temporalType - temporal type param - parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException

; Parameter param ,    Date value ,    TemporalType temporalType ) Bind an instance of Date to a Parameter object. Parameters : temporalType - temporal type param - parameter object value - parameter value Returns: the same query instance. Throws: IllegalArgumentException

ParameterExpression parameter (    Class paramClass ,    String name ) Create a parameter expression with the given name. Parameters : name - name that can be used to refer to the parameter paramClass - parameter class Returns: parameter expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. Parameter Integer getPosition() Return the parameter position, or null if the parameter is not a positional parameter . Returns: position of parameter . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence. Parameter Class getParameterType() Return the Java type of the parameter . Values bound to the parameter must be assignable to this type ... : the Java type of the parameter . Throws: IllegalStateException - if invoked on a parameter obtained from

Jakarta Persistence (JPA) Method in jakarta.persistence. Parameter String getName() Return the parameter name, or null if the parameter is not a named parameter or no name has been assigned. Returns: parameter name. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder ParameterExpression parameter (    Class paramClass ) Create a parameter expression. Parameters : paramClass - parameter class Returns: parameter expression. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (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 Returns: boolean indicating whether parameter has been bound. Since: Jakarta Persistence (JPA) 2.0

Jakarta Persistence (JPA) Method in jakarta.persistence.NamedStoredProcedureQuery StoredProcedureParameter[] parameters Information about all parameters of the stored procedure. Parameters must be specified in the order in which they occur in the parameter list of the stored procedure. Default: {} Since: Jakarta Persistence (JPA) 1.0

Hello, I cannot set an entity object in a parameter for a bulk update in the explorer query execution. The format Entity#001 works well for the parameter in the WHERE clause, but it doesn't work in ...   Parameters :  a:    Status#10002 b:    Status#10003 That query

an expression that returns the absolute value of its argument. Parameters : x - expression Returns ... an all expression over the subquery results. Parameters : subquery - subquery Returns: all expression ... of the given boolean expressions. Parameters : x - boolean expression y - boolean expression Returns

of all required IN and INOUT parameters . It is not required to set the values of stored procedure parameters for which default values have been defined by the stored procedure. When getResultList ... back only via INOUT and OUT parameters as well as the most general case (multiple result sets and/or update

Jakarta Persistence (JPA) Interface jakarta.persistence.TypedQuery Type Parameters : - query result ... . See Also: Query Parameter Since: Jakarta Persistence (JPA) 2.0 Chapter 4 - JPA Queries (JPQL / Criteria ... Parameter getParameter ( String name ) Get the parameter object corresponding to the declared parameter

execution. See Also: TypedQuery StoredProcedureQuery Parameter Since: Jakarta Persistence (JPA) 1.0 ... : maximum number of results. Since: Jakarta Persistence (JPA) 2.0 Parameter getParameter ( String name ) Get the parameter object corresponding to the declared parameter of the given name. This method

is built. Parameters in Criteria queries The following string is a JPQL query with a parameter : SELECT c ... .class); Root c = q. from (Country.class); ParameterExpression p = cb. parameter (Integer.class); q ... the query parameter . The where method sets the WHERE clause. As shown, the CriteriaQuery interface

Collections can appear in JPQL queries in the following ways: As parameters when a collection ... to check other collections, such as a collection passed as a query parameter . For example: 'English' IN :languages evaluates to TRUE if the languages parameter collection contains 'English' , and FALSE

of persistence unit properties as a second parameter : Map properties = new HashMap (); properties ... of the database file on the server, relative to the server data root path. Connection URL Parameters The following parameters are supported as part of an ObjectDB connection URL: user : Specifies

, the persistence provider must mark the transaction for rollback. Parameters : function - the function Returns ... to the current persistence context. Parameters : entity - entity instance Returns: boolean value indicating ... mutable EntityGraph , allowing dynamic definition of an entity graph. Parameters : rootType - class

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.PluralJoin Type Parameters ... reassigned. Returns the same selection item. Inherited from Selection Parameters : name - alias ... failure. Inherited from Expression Parameters : type - intended type of the expression Returns: new

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.MapJoin Type Parameters ... Parameters : name - alias Returns: selection item. Since: Jakarta Persistence (JPA) 1.0 Expression as ... : may result in a runtime failure. Inherited from Expression Parameters : type - intended type

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.SetJoin Type Parameters ... reassigned. Returns the same selection item. Inherited from Selection Parameters : name - alias Returns ... . Inherited from Expression Parameters : type - intended type of the expression Returns: new expression

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.CollectionJoin Type Parameters ... Parameters : name - alias Returns: selection item. Since: Jakarta Persistence (JPA) 1.0 Expression as ( Class ... : may result in a runtime failure. Inherited from Expression Parameters : type - intended type

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.ListJoin Type Parameters ... reassigned. Returns the same selection item. Inherited from Selection Parameters : name - alias Returns ... . Inherited from Expression Parameters : type - intended type of the expression Returns: new

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.Join Type Parameters ... Selection Parameters : name - alias Returns: selection item. Since: Jakarta Persistence (JPA) 1.0 Expression ... . Warning: may result in a runtime failure. Inherited from Expression Parameters : type - intended type

' and '' . As parameters when string values are passed as query arguments. As path expressions ... a path expression), and the right operand is the pattern (usually a parameter or literal). For example ... : // Create path and parameter expressions: Expression path = country. get ("name"); Expression param = cb

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.Root Type Parameters ... Selection Parameters : name - alias Returns: selection item. Since: Jakarta Persistence (JPA) 1.0 ... . Warning: may result in a runtime failure. Inherited from Expression Parameters : type - intended type

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.From Type Parameters ... the same selection item. Inherited from Selection Parameters : name - alias Returns: selection item ... Expression Parameters : type - intended type of the expression Returns: new expression of the given

and -12.5 . As parameters that are bound to numeric arguments. As path expressions that navigate ... expression or a simple Java numeric object. // Create path and parameter expressions: Expression path = country. get ("population"); Expression param = cb. parameter (Integer.class); // Addition

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.Subquery Type Parameters ... Parameters : name - alias Returns: selection item. Since: Jakarta Persistence (JPA) 1.0 Expression ... . Warning: may result in a runtime failure. Inherited from Expression Parameters : type - intended type

Parameters : - the type of the parameter expression Super Interfaces: Parameter , Expression , Selection , TupleElement Type of criteria query parameter expressions. Since: Jakarta Persistence (JPA) 2.0 Public ... Selection Parameters : name - alias Returns: selection item. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Interface jakarta.persistence.EntityGraph Type Parameters : - The type ... if there is no existing node. Inherited from Graph Parameters : attributeName - name of the attribute ... . Inherited from Graph Parameters : attribute - attribute Returns: the attribute node. Throws

Jakarta Persistence (JPA) Interface jakarta.persistence.metamodel.IdentifiableType Type Parameters ... of the managed type that corresponds to the specified name. Inherited from ManagedType Parameters ... ManagedType Parameters : name - the name of the represented attribute elementType - the element type

Jakarta Persistence (JPA) Interface jakarta.persistence.metamodel.EntityType Type Parameters ... that corresponds to the specified name. Inherited from ManagedType Parameters : name - the name ... . Inherited from ManagedType Parameters : name - the name of the represented attribute elementType

Parameters : - The represented mapped superclass type Super Interfaces: IdentifiableType , ManagedType ... Parameters : name - the name of the represented attribute Returns: attribute with given name. Throws ... ManagedType Parameters : name - the name of the represented attribute elementType - the element type

Jakarta Persistence (JPA) Interface jakarta.persistence.Subgraph Type Parameters : - The type ... . Inherited from Graph Parameters : attributeName - name of the attribute Returns: the attribute node ... attribute, or add a new attribute node if there is no existing node. Inherited from Graph Parameters

. Parameters : attributeName - name of the attribute Returns: the attribute node. Throws ... attribute node if there is no existing node. Parameters : attribute - attribute Returns: the attribute ... , that particular argument is ignored and has no effect. Parameters : attributeName - name

predicate ├─ Path # Navigation path (attributes) ├─ ParameterExpression # Query parameter ... of a query parameter used for binding runtime values. Advanced expressions Additional interfaces

type literals (for example, Country ). Use JPQL literals sparingly. Queries that use parameters ... times with different parameter values. Embed literals in JPQL queries only when a single, constant

retrieves only countries with a population greater than the value of the parameter p : SELECT c ... . select (c); ParameterExpression p = cb. parameter (Integer.class); q. where (cb. gt (c

a custom backup root directory by setting the target parameter before you execute the backup query ... parameter , it represents a path relative to the ObjectDB home directory. In client-server mode, the path