ObjectDB Database Search

Hi,    I've got a simple JPA2 Criteria query which fails when doing an object equality ... ; .     @Id    private Long id; } and the query :    @Override public ... I get is: Caused by: com.objectdb.o.UserException: Unsupported query operator '@' at com.objectdb.o

Running two different separate queries and merging the results (e.g. into a Java set, maybe ... c2.original.events AS event WHERE c1.id=?1 OR c2.id=?1 Unfortunately this query returns no events at all, removing the SharedCalendar from the query works as expected. How can I achieve this? Thanks

with query option: query .setHint("objectdb. result -fetch", "LAZY"); btc_es BTC EmbeddedSystems The exception ... more information, including details about the query ? The stack trace indicates an unexpected query variable. Are there non entity variables in the query or an entity class with no instances in the database

Hello, I got a realy strange SELECT problem. In explorer query "select p  from Player p where p.confirmed==false", given me some results with p.confirmed==TRUE. And when I try to do (see image) "select p, p.confirmed  from Player p where p.confirmed==false", I getting p-confirmed-true

When I try to execute the following criteria query CriteriaBuilder builder = em.getCriteriaBuilder(); CriteriaQuery criteria = builder.createQuery(relationshipClass); Root root = criteria.from ... .toArray(new Predicate[predicates.size()])); List results = em.createQuery(criteria).getResultList

We are working with objectDB version 2.5.5.b01. (we also tried to use the latest version 2.6.1) We have several issues with queries that can be seen with the attached database and using ObjectDB explorer: 1.       Using ObjectDB explorer a.    

You can start an online backup by executing a special query on an EntityManager ( em ) instance ... ").getSingleResult(); The backup query string is always "objectdb backup" . The backup is created in the backup ... a custom backup root directory by setting the target parameter before you execute the backup query

: the resulting fetch join. Since: Jakarta Persistence (JPA) 1.0 Fetch fetch ( SingularAttribute ... Returns: the resulting fetch join. Since: Jakarta Persistence (JPA) 1.0 Fetch fetch ( PluralAttribute ... . Inherited from FetchParent Parameters: attribute - target of the join Returns: the resulting join

join. Parameters: attribute - target of the join Returns: the resulting fetch join. Since: Jakarta ... attribute - target of the join Returns: the resulting fetch join. Since: Jakarta Persistence (JPA) 1.0 ... attribute using an inner join. Parameters: attribute - target of the join Returns: the resulting join

the SELECT clause of a SQL query to an entity result . If this annotation is used, the SQL statement ... columns to related entities. The results obtained when insufficient data is available are undefined. Example: Query q = em.createNativeQuery( "SELECT o.id, o.quantity, o.item, " + "i.id, i.name, i

of all entities in the persistence context which could potentially affect the result of the query ... Enumerates flush modes recognized by the EntityManager . When queries are executed within a transaction, if AUTO is set on the Query or TypedQuery object, or if the flush mode setting

of NoSQL technology, which are weak query capabilities and lack of ACID (atomicity, consistency, isolation, durability). Unlike other NoSQL solutions, ObjectDB provides full support of rich complex queries , using two standard Java query languages: JPQL (Java Persistence Query Language) and JDOQL (JDO

() Retrieve the list of results from the next result set. The provider will call execute on the query if needed. A REF_CURSOR result set, if any, is retrieved in the order the REF_CURSOR parameter was registered with the query . Returns: a list of the results or null is the next item is not a result set

ConstructorResult annotation to map a column of the SELECT list of a SQL query . The name element references the name of a column in the SELECT list — i.e., column alias, if applicable. Scalar result types can be included in the query result by specifying this annotation in the metadata. Example: Query q = em

: - an upper bound on the result type of the query A reference to a named query declared via the NamedQuery ... .0 String getName () The name of the query . Since: Jakarta Persistence (JPA) 1.0 Class getResultType () The result type of the query . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.EntityManager Query createNativeQuery (    String sqlString ) Create an instance of Query for executing a native SQL statement, e.g., for update or delete. If the query is not an update or delete query , query execution will result

do not support aggregate queries (max, min, count, sum and avg). ObjectDB supports rich queries , including aggregate queries , as part of its support of JPQL (JPA Query Language) and JDOQL (JDO Query Language). ObjectDB is faster than other products.

and provide better support for automatic change tracking. UPDATE queries UPDATE queries provide an alternative way to update entities in the database. Using an UPDATE query is useful, especially when you must modify many entities in a single operation. The UPDATE Queries in JPA/JPQL section in Chapter 4 explains how to use JPA UPDATE queries .

a SELECT query that returns a single result . Returns: the result , of type X . Throws: IllegalStateException - if called for a Jakarta Persistence query language UPDATE or DELETE statement ... back. NonUniqueResultException - if more than one result . QueryTimeoutException - if the query execution exceeds the query

() Execute a SELECT query that returns a single untyped result . Returns: the result , of type X , or null if there is no result . Throws: IllegalStateException - if called for a Jakarta Persistence query ... and only the statement is rolled back. NonUniqueResultException - if more than one result . QueryTimeoutException

results . Returns: a new criteria query which returns the result of subtracting the results of the second query from the results of the first query . Since: Jakarta Persistence (JPA) 3.2 ... exceptAll (    CriteriaSelect left ,    CriteriaSelect right ) Create a query by

refresh() ), or to Query .setLockMode or TypedQuery.setLockMode . Optimistic locks are specified using ... attempting to update the entity data. A lock with LockModeType.PESSIMISTIC_READ can be used to query ... with LockModeType.PESSIMISTIC_WRITE can be used when querying data and there is a high likelihood of deadlock or

: - the type of the expression Super Interfaces: Selection , TupleElement Type for query expressions. Since: Jakarta Persistence (JPA) 2.0 The JPA Query Expressions (JPQL / Criteria) article explains ... changed. Warning: may result in a runtime failure. Parameters: type - intended type

() Return true if the first result corresponds to a result set, and false if it is an update count or if there are no results other than through INOUT and OUT parameters, if any. Returns: true if first result corresponds to result set. Throws: PersistenceException - if the query execution exceeds

hasMoreResults() Return true if the next result corresponds to a result set, and false if it is an update count or if there are no results other than through INOUT and OUT parameters, if any. Returns: true if next result corresponds to result set. Throws: PersistenceException - if the query execution exceeds

() Execute a SELECT query and return the query result as a typed Stream . By default, this method delegates ... to provide additional capabilities. Returns: a stream of the results , each of type X , or an empty stream if there are no results . Throws: IllegalStateException - if called for a Jakarta Persistence query

a SELECT query and return the query results as a typed List . Returns: a list of the results , each of type X , or an empty list if there are no results . Throws: IllegalStateException - if called for a Jakarta Persistence query language UPDATE or DELETE statement. PessimisticLockException

. Parameters: name - the name of a query defined in metadata resultClass - the type of the query result ... with the given name or if the query string is found to be invalid or if the query result is found ... for executing a Jakarta Persistence query language named query . The select list of the query must contain

except (    CriteriaSelect left ,    CriteriaSelect right ) Create a query by (setwise) subtraction of the second query from the first query . Returns: a new criteria query which returns the result of subtracting the results of the second query from the results of the first query . Since: Jakarta Persistence (JPA) 3.2

The class of each query result . If a result set mapping is specified, the specified result class must agree with the type inferred from the result set mapping. If a resultClass is not explicitly specified ... [] . The query result class may be overridden by explicitly passing a class object to EntityManager

is not changed. Warning: may result in a runtime failure. Inherited from Expression Parameters: type ... to the specified type, returning a new expression object. Unlike Expression.as , this method does result in ... the string-based API may need to specify the type resulting from the get operation in order to avoid

Specifies the precedence of null values within query result sets. See Also: CriteriaBuilder.asc ... Constants FIRST Null values occur at the beginning of the result set. Since: Jakarta Persistence (JPA) 1.0 LAST Null values occur at the end of the result set. Since: Jakarta Persistence (JPA) 1.0

() Return the update count or -1 if there is no pending result or if the next result is not an update count. Returns: update count or -1 if there is no pending result or if the next result is not an update count. Throws: PersistenceException - if the query execution exceeds the query timeout value set

() Return the update count of -1 if there is no pending result or if the first result is not an update count. The provider will call execute on the query if needed. Returns: the update count or -1 if there is no pending result or if the next result is not an update count.. Throws: PersistenceException

select (    Selection selection ) Specify the item that is to be returned in the query result ... and the query result type is specified. For example: CriteriaQuery q = cb.createQuery(String.class); Root ... ")); Parameters: selection - selection specifying the item that is to be returned in the query result

resulting from mechanical transformation or translation of a Source form, including but not limited ... , incidental, or consequential damages of any character arising as a result of this License or

and recording files and attempts to apply all the recorded operations. The resulting database file ... and applies all operations up to transaction 1000, the resulting file is named 1000.odb .

and eliminates the ORM layer. The result is better performance and faster applications, especially when the object data model is complex. See JPA benchmark results ...   Reduce development time. Improve

, and if a court requires any other Contributor to pay any damages as a result , the Commercial ... arose. Each party waives its rights to a jury trial in any resulting litigation.

a result of either a global or local setting) during a persist operation. The on-commit attribute specifies whether to apply cascading (as a result of either a global or local setting) during commit

: the runtime type is not changed. Warning: may result in a runtime failure. Inherited from Expression ... result in a runtime type conversion. Providers are required to support casting scalar expressions ... . Modifications to the list do not affect the query . Inherited from Selection Returns: list

: may result in a runtime failure. Inherited from Expression Parameters: type - intended type of the expression ... expression object. Unlike Expression.as , this method does result in a runtime type conversion. Providers ... the query . Inherited from Selection Returns: list of selection items. Throws: IllegalStateException

, query facilities, metamodel details, configuration options, annotations, and exception information ... the fundamental classes and interfaces for entity management and persistence operations. Covers the query API, criteria queries , and JPQL for data retrieval and manipulation. Describes the metamodel and graph APIs

processes JPQL (JPA Query Language) and JDOQL (JDO Query Language) queries directly, where ORM tools first convert these queries to SQL and then transition the SQL to the DBMS for execution through a JDBC

. Parameters: qlString - a Jakarta Persistence query string resultClass - the type of the query result ... to be invalid or if the query result is found to not be assignable to the specified type. Since: Jakarta Persistence (JPA) 2.0 ... for executing a Jakarta Persistence query language statement. The select list of the query must contain

() Return the result type of the query or subquery. If a result type was specified as an argument to the createQuery or subquery method, that type is returned. If the query was created using the createTupleQuery method, the result type is Tuple . Otherwise, the result type is Object . Returns: result type. Since: Jakarta Persistence (JPA) 1.0

distinct (    boolean distinct ) Specify whether duplicate query results are eliminated. A true ... . If distinct has not been specified, duplicate results must be retained. Parameters: distinct - boolean value specifying whether duplicate results must be eliminated from the query result or

distinct (    boolean distinct ) Specify whether duplicate query results are eliminated. A true ... specifying whether duplicate results must be eliminated from the query result or ... . If distinct has not been specified, duplicate results must be retained. This method only overrides

Thrown by the persistence provider when Query .getSingleResult or TypedQuery.getSingleResult is executed and there is more than one result from the query . This exception does not cause the current transaction, if one is active, to be marked for rollback. See Also: Query .getSingleResult() TypedQuery

showing the query result in indexTest.xhtml. The problems is illustrated by running the attached JavaEE ... many Element objects gives expected results , but the same query performed later form a served JSF page ... (null) There is also a copy of the indexTest.xhtml output with a table of the query results attached