About query

forum_thread

JPA Query language support in OBjectDB / Sub query or nested Query

Hi Wanted to check with you on the exact level of support of JPA QL within the ObjectDB world. I have given a sample typed query below which fails to work with ObjectDB and it runs very well with the Hibernate/MySQL JPA. We are using Spring Data here. It looks like a problem with Sub query or nested queries where I am using IN clause like below. ... the ObjectDB world. I have given a sample typed query below which fails to work with ObjectDB and it runs very well with the ... Spring Data here. It looks like a problem with Sub query or nested queries where I am using IN clause like below. ...

 
forum_thread

Query problem after transaction commit

I have a machine running the objectdb server and the client on another machine connect to it. The client program can connect to the server and query to get all the records. However, after transaction.begin ... persist(p) .. commit of a new object, my client program can no longer retrieve the old records but only the latest stored record. I tried to run database explorer on the server machine and able to see all the records including the new stored record.... to it. The client program can connect to the server and query to get all the records. However, after transaction.begin ... persist(p) ... 02> Test_Connection: connected 03> UI: start query [query for all object Goods successfully] 04> SELECT u ...

 
manual

Paths and Types in JPQL and Criteria API

Explains how to use object expressions (path navigation, type) in JPA/JPQL.... Entity Type Expressions Criteria Query Paths and Types Navigation through Path ... Navigation through a NULL value The following query retrieves country names with their capital city names: SELECT ...

 
manual

Logical Operators in JPQL and Criteria API

Explains how to use AND, OR and NOT in JPQL queries.... Unary NOT (!) Operator Criteria Query Logical Operators Logical Operators ... its own notation (which is also in use by JDOQL, the JDO Query Language). ObjectDB supports both forms. Binary AND (&&) ...

 
manual

Index Definition

Describes how to define indexes in JPA entity classes and explains how indexes are used in JPQL queries.... understanding of how ObjectDB uses indexes to accelerate query execution. Indexes are especially efficient in lookup and range ... y BETWEEN 50 AND 80 For the second query above, the index order should be x first and y second. ...

 
manual

Comparison in JPQL and Criteria API

Explains how comparison operators can be used in JPQL queries, including in comparing null values.... Types [NOT] BETWEEN Criteria Query Comparison Comparison Operators ObjectDB ... its own notation (which is also in use by JDOQL, the JDO Query Language). ObjectDB supports both forms. Besides the different notation, ...

 
forum_thread

"Problem" with cross join

At first, this is my first JPA Projekt - and the code should work with Hibernate and JPA, using the specifc DAOs. Following query string returns no result using ObjectDB - using Hibernate, or EclipseLink this query works fine. select distinct c from CI c, CIstring s where c.name like :SSTR or (c.id = s.ci.id AND s.text like :SSTR) The class CI (Confiugration Item):...private String name;@OneToMany(mappedBy="ci") private List<CIdata> content;... and JPA, using the specifc DAOs. Following query string returns no result using ObjectDB - using Hibernate, or EclipseLink this query works fine. select distinct c from CI c, CIstring s where c.name ...

 
manual

[ODB1] Chapter 7 - JDOQL Queries

Explains how to use JDOQL, the Java/JDO Query Language.... When a more selective retrieval is needed, JDOQL (JDO Query Language) is used. JDOQL for JDO is like SQL for RDBMS. It provides ... to JDOQL 7.2  Query Filter Syntax 7.3  Query Parameters 7.4  Query Variables ...

 
faq

Is ObjectDB a NoSQL Database?

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

 
api-jpa

javax.persistence.criteria.Expression

Type for query expressions.(Interface of JPA)