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

;  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

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

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

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

. 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

Jakarta Persistence (JPA) Interface jakarta.persistence.metamodel.ManagedType Type Parameters ... to the specified name. Parameters : name - the name of the represented attribute Returns: attribute ... of the managed type that corresponds to the specified name and Java element type. Parameters : name

Jakarta Persistence (JPA) Interface jakarta.persistence.metamodel.EmbeddableType Type Parameters ... to the specified name. Inherited from ManagedType Parameters : name - the name of the represented attribute ... to the specified name and Java element type. Inherited from ManagedType Parameters : name - the name

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.CriteriaQuery Type Parameters ... AbstractQuery.distinct Parameters : distinct - boolean value specifying whether duplicate results ... from AbstractQuery Parameters : entityClass - the entity class Returns: query root corresponding

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.AbstractQuery Type Parameters ... . Parameters : distinct - boolean value specifying whether duplicate results must be eliminated from ... to the given entity, forming a cartesian product with any existing roots. Parameters : entityClass - the entity

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 ... Parameters : type - a basic type Returns: a scalar expression of the given basic type. Since: Jakarta

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

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 ... Parameters : type - a basic type Returns: a scalar expression of the given basic type. Since: Jakarta

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.CriteriaUpdate Type Parameters ... that is being updated. Parameters : entityClass - the entity class Returns: query root corresponding to the given entity ... root, the entity that is being updated. Parameters : entity - metamodel entity representing the entity

cannot be changed or reassigned. Returns the same selection item. Inherited from Selection Parameters ... : may result in a runtime failure. Inherited from Expression Parameters : type - intended type of the expression ... . Inherited from Expression Parameters : type - a basic type Returns: a scalar expression of the given basic

. 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 ... . Support for typecasts between other basic types is not required. Inherited from Expression Parameters

.classIdentifier = '(PR)' and o.created ?1 we try to set the parameter (its a java.util.Date) in the parameters table. None of the following works: 2020-12-01 2020.12.01 {d '2020-12-01'} the parameter ... '. A workaround for previous versions is to use a date literal (embedded in the query) instead of a date parameter . support Support

configuration file. You can use the –conf command line parameter to specify the location of your server ... , you do not need to use the –conf command line parameter , because ObjectDB will automatically look for a server/server.xml file if the –conf parameter is not used. Also, if you do not use the –conf parameter

for representing objects in web applications (in which parameters are represented by strings). If getObjectID( ... ) is called with a transient parameter , it returns null . If it is called with a new