About jpql

issue

ObjectDB BIRT Driver Update

The ObjectDB BIRT/ODA driver is an extension of the open source Business Intelligence and Reporting Tools (BIRT) that adds support of ObjectDB as a data source and JPQL as a data set query language. ... (BIRT) that adds support of ObjectDB as a data source and JPQL as a data set query language. In the current implementation ...

 
api-jpa

JPA Annotations for SQL Queries

Reference (JavaDoc) of JPA 2 sql query annotations.... ObjectDB supports only the preferred JPA query language, JPQL, and silently ignores all the above annotations. ...

 
forum_thread

ObjectDB data migration/extraction

Hi What is the way to extract data from ObjectDB to relational databases (Oracle). We need to feed an Oracle database with data for reporting/datawarehosing. Should JPQL be used or is there some tools to do it. Thanks. ... with data for reporting/datawarehosing. Should JPQL be used or is there some tools to do it. Thanks. ...

 
forum_thread

Handling "is null" in where clause

Greetings, I was playing aroung with JPQL and have found that there is a problem with "is null" queries. When you use "is null" in where clause, query runs correctly, but results are incorrect. Let me show you an example: - entity @Entity public class EntityA { @Id Integer id; Integer simpleField; (getters and setters here) - populating database... Greetings, I was playing aroung with JPQL and have found that there is a problem with "is null" queries. When you ...

 
api-jpa

getFirstResult()

The position of the first result the query object was set to retrieve.(Method of javax.persistence.Query)

 
forum_thread

ObjectDB version 2.3 has been released

ObjectDB 2.3 has been released and it includes important additions and fixes: ... Added support of IN operator in JPQL queries. Added support of ";drop" database url ...

 
forum_thread

Navigation through Path to evaluate collection

Hello, I need to evaluate a field ("identifier") which is situated in a collection, within an entity. As stated in the documentation it is not possible to navigate there with the dot operator since its a collection. Is it there a way to evaluate this field? Here is the query, the entity and the related embeddable class. Thanks ... . sku DESC You may also try this (not valid JPQL but may be supported by ObjectDB): SELECT item FROM ...

 
forum_thread

Multi-Threading/Distributed-Database Questions...

Greetings ObjectDB team, All below questions assume a very large database (~1,000,000,000 objects): Q1: In what cases would ObjectDB utilize multi-threading ? how about in JOIN operations ? Q2: Is it true that two read-only JPQL queries accessing the same database file actually run simultaneously if placed into two independent threads ? no I/O synchronization bottlenecks ?... operations ? Q2: Is it true that two read-only JPQL queries accessing the same database file actually run simultaneously if ...

 
forum_thread

using objectdb.jar in writing data to mariadb or mysql db

Hello All, ... or mysql using native java JPA API and in some cases JPQL or must i store to an Objectdb unique database? Moreso, does Objectdb have ...

 
forum_thread

selecting objects that have a particular key/value in persistant HashMap

Hi, First post here and exploring ObjectDB.  I have an class Person which has a HashMap<String, String> called 'pMap' as a persistable field.  I am able to create Person objects and persist them as expected. ... = 'California' This is not a valid JPQL query but an extension that ObjectDB should support. If you need a ...