ObjectDB Database Search

. and if possible, all the above also on the test server. support Support Hi, we have collected results . Results from console program reveal some other interesting facts The test database on the production server from the Explorer. • Result 1: aprox 20000 records in 30ms • Result 2: 14000 Document

to do ad-hoc JPQL queries and navigate through the results and even make small changes to primitive ... the Results either as a table or tree. 4. It would be terrific if the Database tab had lots ... with max results limit. Viewing all the objects of a class without a query and max result limit is not

that is applied to the results of the query execution. If the constructor is for an entity class, the resulting

Jakarta Persistence (JPA) Method in jakarta.persistence.TypedQuery TypedQuery setFirstResult (    int startPosition ) Set the position of the first result to retrieve. Parameters: startPosition - position of the first result , numbered from 0 Returns: the same query instance. Throws

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery select (    Expression expression ) Specify the item that is to be returned as the subquery result ... the item that is to be returned as the subquery result Returns: the modified subquery. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.TypedQuery TypedQuery setMaxResults (    int maxResult ) Set the maximum number of results to retrieve. Parameters: maxResult - maximum number of results to retrieve Returns: the same query instance. Throws: IllegalArgumentException

.PROVIDER_DEFAULT selects the default behavior of the provider, which may or may not result in

of all entities in the persistence context which could potentially affect the result of the query

the persistence provider when a pessimistic locking conflict occurs that does not result in

constructor results will be in either the new or detached state, depending on whether a primary key

of the results of the given queries. Since: Jakarta Persistence (JPA) 3.2

the intersection of the results of the given queries. Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CollectionJoin CollectionJoin on (    Expression restriction ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery Set getRoots() Return the query roots. These are the roots that are defined for the CriteriaQuery or Subquery itself, including any subquery roots defined as a result of correlation. Returns an empty set if no roots

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CollectionJoin CollectionJoin on (    Predicate... restrictions ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CommonAbstractCriteria Subquery subquery (    Class type ) Create a subquery of the query. Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CommonAbstractCriteria Subquery subquery (    EntityType type ) Create a subquery of the query. Parameters: type - the subquery result type Returns: subquery. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaQuery createTupleQuery() Create a CriteriaQuery object that returns a tuple of objects as its result . Returns: criteria query object. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsLong (    Expression x ) Create an aggregate expression applying the sum operation to an Integer-valued expression, returning a Long result . Parameters: x - expression representing input

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder Expression sumAsDouble (    Expression x ) Create an aggregate expression applying the sum operation to a Float-valued expression, returning a Double result . Parameters: x - expression representing input

Jakarta Persistence (JPA) Enum Constant in jakarta.persistence.ParameterMode REF_CURSOR Stored procedure reference cursor parameter. Some databases use REF_CURSOR parameters to return result sets from stored procedures. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.TypedQueryReference Class getResultType() The result type of the query. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery groupBy (    List grouping ) Specify the expressions that are used to form groups over the query results . Replaces the previous specified grouping expressions, if any. If no grouping expressions

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery where (    Expression restriction ) Modify the subquery to restrict the result according to the specified boolean expression. Replaces the previously added restriction(s), if any. This method

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery where (    Expression restriction ) Modify the query to restrict the query results according to the specified boolean expression. Replaces the previously added restriction(s), if any. Parameters

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery where (    Predicate... restrictions ) Modify the subquery to restrict the result according to the conjunction of the specified restriction predicates. Replaces the previously added restriction(s), if any

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery where (    Predicate... restrictions ) Modify the query to restrict the query results according to the conjunction of the specified restriction predicates. Replaces the previously added

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery where (    List restrictions ) Modify the query to restrict the query result according to the conjunction of the specified restriction predicates. Replaces the previously added restriction(s), if any

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery where (    List restrictions ) Modify the query to restrict the query result according to the conjunction of the specified restriction predicates. Replaces the previously added restriction(s

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery groupBy (    Expression ... grouping ) Specify the expressions that are used to form groups over the subquery results . Replaces the previous specified grouping expressions, if any. If no grouping

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery groupBy (    Expression ... grouping ) Specify the expressions that are used to form groups over the query results . Replaces the previous specified grouping expressions, if any. If no grouping

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.SetJoin SetJoin on (    Expression restriction ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters: restriction

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.SetJoin SetJoin on (    Predicate... restrictions ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Subquery groupBy (    List grouping ) Specify the expressions that are used to form groups over the subquery results . Replaces the previous specified grouping expressions, if any. If no grouping expressions

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Subquery Expression getSelection() Return the selection expression. Returns: the item to be returned in the subquery result . Since: Jakarta Persistence (JPA) 1.0

: IllegalArgumentException - if alias does not correspond to an element in the query result tuple. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.Tuple Object[] toArray() Return the values of the result tuple elements as an array. Returns: tuple element values. Since: Jakarta Persistence (JPA) 1.0

correspond to an element in the query result tuple. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.ListJoin ListJoin on (    Expression restriction ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters

to an element in the query result tuple or element cannot be assigned to the specified type. Since: Jakarta Persistence (JPA) 1.0

of the join jt - join type Returns: the resulting join. Throws: IllegalArgumentException

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Join Join on (    Expression restriction ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters: restriction

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Join Join on (    Predicate... restrictions ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters: restrictions

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.MapJoin MapJoin on (    Expression restriction ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters: restriction

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.MapJoin MapJoin on (    Predicate... restrictions ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.ListJoin ListJoin on (    Predicate... restrictions ) Modify the join to restrict the result according to the specified ON condition and return the join object. Replaces the previous ON condition, if any. Parameters

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.Path Path get (    String attributeName ) Create a path corresponding to the referenced attribute. Note: Applications using the string-based API may need to specify the type resulting from the Path.get operation in order

.hummingbird.Action[endDate] locating all the Action (a) instances. [Step 1b] Filter the results of step 1a retaining only results that satisfy: (a.endDate=:1). [Step 1c] Retrieve fields in Action (a) instances. [Step 1d] Filter the results of step 1c retaining only results that satisfy: (a.state=3). [Step 1e

. Step 2: Process ObjectNode (v$1) instances   (for every result of step 1 ... ObjectNode (v$1) instances. [Step 2c] Filter the results of step 2b retaining only results that satisfy ... ) instances   (for every result tuple of the steps

-Query and fetching Entities afterwards from database. Expected result : Getting changed Entities from database - Actual result : No changes are visble. Scenario 2 : Disabled L2 Cache, updating elements ... . Expected result : Getting changed Entities from database - Actual result : Everything ok