ObjectDB Database Search

Greetings ObjectDB team, Suppose I pass a List of persistent objects to some query as a parameter , can I navigate to those objects' fields ? E.g.: SELECT x FROM ClassX x WHERE x ... . So if the parameter y is a collection the expression y.b is invalid. support Support

It is possible to execute a query over a keySet of a map field with comparing to a collection parameter ? Set values = new HashSet (); values.add("c2"); String query = // "SELECT e " + "FROM ... with a parameter which is a collection of strings. SELECT e FROM EntityParent e JOIN e . map key

cannot be both before and after the date parameter . support Support Hello, to archieve the results the date parameter used in both queries is obviously not the same. For the first query it is 1 year in the future

. In your test the request is very large (the query parameter arguments) and the response ... with their huge query parameter arguments. Build 2.3.3_06 fixes this issue. Thank you for this report and for the test program. support Support

with the given name already exists, it is replaced. Parameters : graphName - name for the entity graph ... .createNamedStoredProcedureQuery methods. Any configuration of the query object (except for actual parameter ... mapping information, and information about stored procedure parameters . When the query is executed

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

parameter . The elements To remove the ObjectDB evaluation restrictions (a limit of 10 entity classes

. A container annotation that groups multiple @NamedQuery definitions on a single class. Supplies parameters

Date and time expressions can appear in JPQL queries in the following ways: As date and time literals --for example, {d '2011-12-31'} and {t '23:59:59'} . As parameters --when date and time values are passed as arguments. As path expressions --to navigate to persistent date and time fields. As

JPQL / Criteria Parameters JPQL / Criteria Literals Every query expression consists

to ObjectDB). Interface for declaring and handling named or positional query parameters . Use

A named query is a statically defined query with a predefined, unchangeable query string. Using named queries instead of dynamic queries can improve code organization by separating JPQL query strings from Java code. This practice also enforces the use of query parameters instead of embedding

for restricting query scope using parameters and subqueries across all query types. SELECT Queries

Exception on comparing array fields against parameters in queries

selection item. Inherited from Selection Parameters : name - alias Returns: selection item. Since: Jakarta ... Parameters : type - intended type of the expression Returns: new expression of the given type ... between other basic types is not required. Inherited from Expression Parameters : type - a basic type

. This method may, but is not required to, load the given entity by side effect. Parameters : entity ... until after the database insert has occurred. Returns null if the entity does not yet have an id. Parameters : entity ... until after the database insert has occurred. Returns null if the entity does not yet have an id. Parameters : entity

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.CriteriaDelete Type Parameters ... . A CriteriaDelete object has a single root, the entity that is being deleted. Parameters : entityClass ... that is being deleted. Parameters : entity - metamodel entity representing the entity of type X Returns: query root

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.Fetch Type Parameters ... using an inner join. Inherited from FetchParent Parameters : attribute - target of the join Returns ... join type. Inherited from FetchParent Parameters : jt - join type attribute - target of the join

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.FetchParent Type Parameters ... join. Parameters : attribute - target of the join Returns: the resulting fetch join. Since: Jakarta ... to the specified single-valued attribute using the given join type. Parameters : jt - join type

PessimisticLockException exception with the specified detail message. Parameters : message - the detail message ... . Parameters : cause - the cause. message - the detail message. Since: Jakarta Persistence (JPA) 1.0 ... with the specified cause. Parameters : cause - the cause. Since: Jakarta Persistence (JPA) 1.0

. Parameters : message - the detail message. Since: Jakarta Persistence (JPA) 1.0 LockTimeoutException ... detail message and cause. Parameters : cause - the cause. message - the detail message. Since: Jakarta ... LockTimeoutException exception with the specified cause. Parameters : cause - the cause. Since: Jakarta Persistence (JPA

. Parameters : tupleElement - tuple element Returns: value of tuple element. Throws: IllegalArgumentException ... to which the specified alias has been assigned. Parameters : alias - alias assigned to tuple element type ... of the tuple element to which the specified alias has been assigned. Parameters : alias - alias assigned

(JPA) 2.1 Public Instance Methods Set getParameters () Return the parameters of the query. Returns empty set if there are no parameters . Modifications to the set do not affect the query. Returns: the query parameters . Since: Jakarta Persistence (JPA) 1.0 Predicate getRestriction () Return

through an INOUT or OUT parameter . For portability, all results corresponding to result sets and update counts must be retrieved before the values of output parameters . Parameters : parameterName - name of the parameter as registered or specified in metadata Returns: the result that is passed

representing the embeddable class. Parameters : cls - the type of the represented embeddable class ... entity type representing the entity. Parameters : entityName - the name of the represented entity Returns ... the metamodel entity type representing the entity. Parameters : cls - the type of the represented

, Object primaryKey ) Whether the cache contains data for the given entity. Parameters : cls - entity ... for the given entity from the cache. Parameters : cls - entity class primaryKey - primary key ... (and its subclasses) from the cache. Parameters : cls - entity class Since: Jakarta Persistence (JPA

through an INOUT or OUT parameter . For portability, all results corresponding to result sets and update counts must be retrieved before the values of output parameters . Parameters : position - parameter position Returns: the result that is passed back through the parameter . Throws: IllegalArgumentException

;  String name ,    Object value ) Bind an argument value to a named parameter . Parameters : name - parameter name value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or

an instance of Calendar to a named parameter . Parameters : name - parameter name temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or if the value argument

an instance of Date to a named parameter . Parameters : name - parameter name temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or if the value argument

to a named parameter . Parameters : name - parameter name value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter

temporalType ) Bind an instance of java.util.Calendar to a named parameter . Parameters : name - parameter name temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query

temporalType ) Bind an instance of java.util.Date to a named parameter . Parameters : name - parameter name temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if the parameter name does not correspond to a parameter of the query or

; ParameterMode mode ) Register a positional parameter . All parameters must be registered. Parameters : mode - parameter mode position - parameter position type - type of the parameter Returns

EntityExistsException exception with the specified detail message. Parameters : message ... . Parameters : cause - the cause. message - the detail message. Since: Jakarta Persistence (JPA) 1.0 ... with the specified cause. Parameters : cause - the cause. Since: Jakarta Persistence (JPA) 1.0 Additional JDK methods

Jakarta Persistence (JPA) Interface jakarta.persistence.AttributeConverter Type Parameters ... the entity attribute into the data representation to be stored in the database. Parameters : attribute ... conversion. Parameters : dbData - the data from the database column to be converted Returns: the converted

,    ParameterMode mode ) Register a named parameter . Parameters : mode - parameter mode parameterName - name of the parameter as registered or specified in metadata type - type of the parameter

;  int position ,    Object value ) Bind an argument value to a positional parameter . Parameters : position - position value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or

an instance of Calendar to a positional parameter . Parameters : position - position temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or if the value argument

an instance of Date to a positional parameter . Parameters : position - position temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or if the value argument

to a positional parameter . Parameters : position - position value - parameter value Returns: the same query ... parameter of the query or if the argument is of incorrect type. Since: Jakarta Persistence (JPA) 1.0

temporalType ) Bind an instance of java.util.Calendar to a positional parameter . Parameters : position - position temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter

temporalType ) Bind an instance of java.util.Date to a positional parameter . Parameters : position - position temporalType - temporal type value - parameter value Returns: the same query instance. Throws: IllegalArgumentException - if position does not correspond to a positional parameter of the query or

) Determine the load state of a given persistent attribute. Parameters : attributeName - name of attribute ... to unintended loading of state. Parameters : entity - whose load state is to be determined Returns

Jakarta Persistence (JPA) Interface jakarta.persistence.ConnectionConsumer Type Parameters : - the connection type, usually java.sql.Connection An executable action which makes use of a native ... Methods void accept ( C connection ) Execute the action using the given connection. Parameters : connection

Jakarta Persistence (JPA) Interface jakarta.persistence.ConnectionFunction Type Parameters : - the connection type, usually java.sql.Connection A function which makes use of a native database ... Instance Methods T apply ( C connection ) Compute a result using the given connection. Parameters

. Parameters : message - the detail message. Since: Jakarta Persistence (JPA) 1.0 EntityNotFoundException ... with the specified detail message. Parameters : message - the detail message. Since: Jakarta Persistence (JPA) 1

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.Selection Type Parameters : - the type of the selection item Super Interfaces: TupleElement The Selection interface defines an item ... reassigned. Returns the same selection item. Parameters : name - alias Returns: selection item

Jakarta Persistence (JPA) Interface jakarta.persistence.criteria.CompoundSelection Type Parameters : - the type of the selection item Super Interfaces: Selection , TupleElement The CompoundSelection ... selection item. Inherited from Selection Parameters : name - alias Returns: selection item

in the candidate collection of the query. Optional JDOQL components, such as filter, parameters