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

 
page

Consulting and Training

... and goes to exploring design alternatives, advanced JPQL, using ObjectDB with JEE (EJB) and with Spring, and ObjectDB production ...

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

 
issue

[Explorer] Editing Database Files

Some features of ObjectDB 1 Explorer have not been implemented yet in the new Explorer of ObjectDB 2. The new Explorer of ObjectDB 2 is currently a viewer rather than editor, and database files are always opened in read only mode. The ability to create new database objects and edit existing database object has to be reimplemented in the ObjectDB 2.... for the explorer: Allow the user to run an ad-hoc JPQL query, and then browse/edit the results. This would be incredibly useful. ...

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