ObjectDB Database Search

Hi,   AFter the upgrade from 2.2.8_02 (not sure if it was build 03/04 as I skipped 03) - my LIKE queries have stopped working during a regression test. As an example output: Query : SELECT $1 ... The criteria query AND/OR fix in 2.2.8_04 caused this new problem. Please try build 2.2.8_05

Hi, I am trying query one of my DB - for all object types that implement a given interface.     TypedQuery query =         em.createQuery ... ; TypedQuery query =         em.createQuery("SELECT bk

Hi I would know if this type of query is supported By JPA: select sum(nb1), sum(nb2), sum(nb3) from table If yes I have this methode that return a list of Long: public List sommeClassesRep(Choix choix) { Query listClassRepHost = em.createQuery("SELECT SUM(h.nb1xx), SUM(h.nb2xx),SUM(h.nb3xx),SUM(h

UPDATE queries can only update existing fields, and old objects that do not have the fields are not ... , without using an UPDATE query . support Support A new issue was added to the issue tracking system based

].streetNo) : null any clue? I can't figure how to do it with regular JPA Query methodics ... this query : SELECT c, a FROM Customer INNER JOIN c.addresses a ORDER BY a.street WHERE a.active

simple codes(see attachment), failed.   gzdillon Lai Yang DELETE queries should not be run with getSingleResult ( which is for SELECT queries ). Use executeUpdate instead. See this manual page . support Support

I have a class that is persisting a Entity that holds remarks and a time. Then when I query for the latest remark I get a internal error when the remark is larger than 1966 chars. Here is a test class and entity that reproduces the problem on my system. @Entity @Table(name = "TestEntity", schema

we are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1.objectName,sum(p4.doubleValue),sum(p4.doubleValue*p5.doubleValue),0,p7.doubleValue,p3.name,count(o) from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2  INNER JOIN o

I am afraid it is not supported neither in JPQL nor in criteria queries . But does it make sense

Hi,   I would like to know why the query tokens OFFSET AND LIMIT are not available and if they will be in a near future. Is there any equivalent way to get, from the database, the object at given position i as well as a given number of objects that follow such object? Thanks you in advance

Problem with Criteria Querys

Bad Backups – Null Error when issuing simple query on backup via ObjectDB Explorer

How the sort order (in queries) works for non english letters?

"is not null"- queries are not working correctly for indexed fields. Following SSCCE creates 1000 entities. A null value is assigned to an indexed field for every second entity. When doing count- queries at the end, wrong results are fetched. import java.io.Serializable; import javax.jdo.annotations

we have since today exceptions on executing some queries like this: Failed to read from file 'F:\Hummingbird\Objectdb\db\coreSystemDb.odb' we are using objectdb 2.7.2_05 in the objectdb log ... of requests (including the queries ) are then received (what have been queued in the clients during down time

Hello, we found another query bug: SELECT a FROM ArtifactImpl a LEFT OUTER JOIN a.tcSignal s  WHERE a.startStep.stepNumber = 0  AND (s.name IN ('In1') OR a.tcSignal IS NULL) With 2.7.6_b6 we get the expected three result objects. But with 2.8.0 we get only two result objects

BTC EmbeddedSystems The stack trace indicates an unexpected state of the query result cache

ConstructorResult annotation to map a column of the SELECT list of a SQL query . The name element references ... can be included in the query result by specifying this annotation in the metadata. Example: Query q = em ... name (Required) The name of a column in the SELECT clause of a SQL query Since: Jakarta Persistence

the SELECT clause of a SQL query to an entity result. If this annotation is used, the SQL statement ... . Example: Query q = em.createNativeQuery( "SELECT o.id, o.quantity, o.item, " + "i.id, i.name, i ... by the SQL query . Default: LockModeType.OPTIMISTIC Since: Jakarta Persistence (JPA) 3.2 FieldResult

() Execute a SELECT query and return the query result as a typed Stream . By default, this method delegates ... if there are no results. Throws: IllegalStateException - if called for a Jakarta Persistence query ... and only the statement is rolled back. PersistenceException - if the query execution exceeds the query timeout value set

a SELECT query and return the query results as a typed List . Returns: a list of the results, each ... for a Jakarta Persistence query language UPDATE or DELETE statement. PessimisticLockException ... fails and only the statement is rolled back. PersistenceException - if the query execution exceeds

;  LockModeType lockMode ) Set the lock mode type to be used for the query execution. Parameters: lockMode - lock mode Returns: the same query instance. Throws: IllegalStateException - if the query is found not to be a Jakarta Persistence query language SELECT query or a CriteriaQuery query . Since: Jakarta Persistence (JPA) 1.0

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 ... - if the query execution exceeds the query timeout value set and only the statement is rolled

() Retrieve the list of results from the next result set. The provider will call execute on the query ... was registered with the query . Returns: a list of the results or null is the next item is not a result set. Throws: PersistenceException - if the query execution exceeds the query timeout value set

getSingleResult() Retrieve a single result from the next result set. The provider will call execute on the query ... was registered with the query . Returns: the result or null if the next item is not a result set. Throws ... - if more than one result. PersistenceException - if the query execution exceeds the query timeout value set

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: the result or null if the next item is not a result set or ... - if more than one result. PersistenceException - if the query execution exceeds the query timeout value set

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

union (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the union of the given queries . Returns: a new criteria query which returns the union of the results of the given queries . Since: Jakarta Persistence (JPA) 3.2

unionAll (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the union of the given queries , without elimination of duplicate results. Returns: a new criteria query which returns the union of the results of the given queries . Since: Jakarta Persistence (JPA) 3.2

intersect (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the intersection of the given queries . Returns: a new criteria query which returns the intersection of the results of the given queries . Since: Jakarta Persistence (JPA) 3.2

intersectAll (    CriteriaSelect left ,    CriteriaSelect right ) Create a query which is the intersection of the given queries , without elimination of duplicate results. Returns: a new criteria query which returns the intersection of the results of the given queries . Since: Jakarta Persistence (JPA) 3.2

result corresponds to result set. Throws: PersistenceException - if the query execution exceeds the query timeout value set and the transaction is rolled back. QueryTimeoutException - if the query execution exceeds the query timeout value set and only the statement is rolled back. Since: Jakarta Persistence (JPA) 1.0

if next result corresponds to result set. Throws: PersistenceException - if the query execution exceeds the query timeout value set and the transaction is rolled back. QueryTimeoutException - if the query execution exceeds the query timeout value set and only the statement is rolled back. Since: Jakarta Persistence (JPA) 1.0

an update count. Throws: PersistenceException - if the query execution exceeds the query timeout value set and the transaction is rolled back. QueryTimeoutException - if the query execution exceeds the query

count. The provider will call execute on the query if needed. Returns: the update count or -1 ... - if the query execution exceeds the query timeout value set and the transaction is rolled ... to the transaction. QueryTimeoutException - if the statement execution exceeds the query timeout

Jakarta Persistence (JPA) Annotation Type jakarta.persistence.NamedNativeQueries Implemented Interfaces: Annotation Target: Type Declares multiple native SQL named queries . Query names are scoped to the persistence unit. The NamedNativeQueries annotation can be applied to an entity or mapped

to map the SELECT clause of a SQL query to a constructor. Applies a constructor for the target class ... is retrieved for the constructed object. Example: Query q = em.createNativeQuery( "SELECT c.id, c.name

of the entity class. This name is used to refer to the entity in queries . The name must not be a reserved literal in the Jakarta Persistence query language. Default: "" Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Annotation Type jakarta.persistence.FieldResult Implemented Interfaces: Annotation Used in conjunction with the EntityResult annotation to map columns specified in the SELECT list of a SQL query to the properties or fields of an entity class. Example: Query q = em

distinct (    boolean distinct ) Specify whether duplicate query results are eliminated. A true ... - boolean value specifying whether duplicate results must be eliminated from the query result or whether they must be retained Returns: the modified query . Since: Jakarta Persistence (JPA) 1.0

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 ... have been defined. Modifications to the set do not affect the query . Returns: the set of query roots. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CommonAbstractCriteria 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

;  String hintName ,    Object value ) Set a query property or hint. The hints elements may be used to specify query properties and hints. Properties defined by this specification ... : the same query instance. Throws: IllegalArgumentException - if the second argument is not valid for the implementation. Since: Jakarta Persistence (JPA) 1.0

;  Integer timeout ) Set the query timeout, in milliseconds. This is a hint, and is an alternative to setting the hint jakarta.persistence. query .timeout . Parameters: timeout - the timeout, in milliseconds, or null to indicate no timeout Returns: the same query instance. Since: Jakarta Persistence (JPA) 3.2

;  FlushModeType flushMode ) Set the flush mode type to be used for the query execution. The flush mode type applies to the query regardless of the flush mode type in use for the entity manager. Parameters: flushMode - flush mode Returns: the same query instance. Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery where (    Expression restriction ) Modify the query to restrict the query results according ... : restriction - a simple or compound boolean expression Returns: the modified query . Since: Jakarta Persistence (JPA) 1.0

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery where (    Predicate... restrictions ) Modify the query to restrict the query results according ... removed. Parameters: restrictions - zero or more restriction predicates Returns: the modified query . Since: Jakarta Persistence (JPA) 1.0

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 ... - a list of zero or more restriction predicates Returns: the modified query . Since: Jakarta Persistence (JPA) 3.2

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.AbstractQuery AbstractQuery where (    List restrictions ) Modify the query to restrict the query result according ... . Parameters: restrictions - a list of zero or more restriction predicates Returns: the modified query . Since: Jakarta Persistence (JPA) 3.2