About JPQL

release

2.0.4

... Fixed a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
forum_thread

Reporting Engine?

New to java and objectdb - I am looking for a reporting engine to use with objectdb. Would birt work or is there something better matched? I am ideally looking for something template based with external template designer to customize the template.    ... Basic support of JPQL / EJB QL is available for both Birt (using an external extension) ...

 
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 ...

 
forum_thread

Is named-query supported in orm.xml

I prefer to keep custom JPQL named queries in an external file, e.g. orm.xml, rather than in the entity classes, for example: <named-query name= "DataValue.deleteByCapabilityAndCreationtime"> <query>delete from DataValue d where d.capabilityId = :capabilityId and d.creationtime &lt;= :creationtime </query> </named-query> This works fine with e.g. eclipseLink and postgres, but objectDB complains with an error like: ... I prefer to keep custom JPQL named queries in an external file, e.g. orm.xml, rather than in the entity ...

 
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 ...

 
api-jpa

javax.persistence.Parameter

Type for query parameter objects.(Interface of JPA)

 
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

How do I achieve a Deep Fetch using JOIN FETCH?

I have an Entity type which is contains a collection of Embeddable objects, which in turn themselves contain a collection of Embeddable objects: @Embeddable class A { String val; }; @Embeddable class B { List<A> aList; }; @Entity class C { @Id long id; List<B> bList; };   Usually I'm content to have the B's and A's be lazily loaded, but I have a circumstance where I need to be able to work with the whole C object, with all its parts, as a detached object. ... I know that I can express one level of eager fetch in JPQL as follows: SELECT c FROM C JOIN FETCH c . bList ...

 
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 ...