ObjectDB Database Search

Query parameters enable the definition of reusable queries. Such queries can be executed with different parameter values to retrieve different results. Running the same query multiple times with different parameter values (arguments) is more efficient than using a new query string for every query

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

which the query is built. Parameters in Criteria Queries The following query string represents a JPQL query with a parameter : SELECT c FROM Country c WHERE c.population :p An equivalent query can be built using ... . parameter (Integer.class); q. select (c). where (cb. gt (c. get ("population"), p

Collections may appear in JPQL queries: as parameters - when collections are assigned as arguments ... that is passed to the query as a parameter . For example: 'English' IN :languages is TRUE if the argument for the languages   parameter  is a collection that contains 'English' and FALSE if not

of the createEntityManagerFactory method takes a map of persistence unit properties as a second parameter : Map properties ... , relative to the server data root path. Connection URL Parameters The following parameters ... above). To obtain a connection to an empty database (discarding existing content if any) the drop parameter

, 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

' , ''. as parameters - when string values are assigned as arguments. as  path expressions - in ... (usually a parameter or literal). For example: c.name LIKE '_r%' is TRUE for 'Brazil' and FALSE ... , as shown in the following examples: // Create path and parameter expressions: Expression path

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

, -12.5 . as parameters - when numeric values are assigned as arguments. as  path expressions - in ... Java numeric object: // Create path and parameter expressions: Expression path = country. get ("population"); Expression param = cb. parameter (Integer.class); // Addition (+) Expression sum1 = cb. sum

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

). JPQL literals should be used sparingly as queries that use parameters instead of literals ... parameter values. Literals should only be embedded in JPQL queries when a single constant value

directory can be specified by setting the target parameter before executing the backup query:   ... is specified as a value for the target parameter it represents a path relative to the ObjectDB home

identification variables and SELECT result variables. Parameters - when instances of these classes ... with an instance of a user defined class (represented by a variable, parameter or prefix path

: Enter a query string. In the [ Parameters ] table provide arguments for parameters (if any