About ORDER BY

release

2.6.7

... Fixed a bug in ordering query result by an expression that is used in IN operator. Fixed a bug in ... bugs. Fixed a performance issue with mapped by fetch. Fixed the ObjectDB Maven repository and Maven examples ...

 
forum_thread

Modifying something with Explorer -> app JPQL with Enum doesn't work anymore

Hi! Scenario: Copy attached DB into localhost ObjectDB server (I'm running 2.5.1_03). Open attached project JavaEE Maven with NetBeans (7.4 beta in my case). Start ObjectDB on localhost as server. Run project on Apache Tomee 1.5.2 standard. Take a look at NetBeans' output to see how many entities are found with field type GOOD. There are 2 ways generate the bug: ... the number of entities with field "type" GOOD found by the the NamedQuery does not correspond with the actual data present in the ... current report and web application, but addressing this by our support team is expected to take much more time. Images in the ...

 
forum_thread

java.sql.Time field off by 30 minutes

Hihi, I'm wondering if this is a bug. I have a simple entity with java.sql.Time field. On writing and readback, the field is found to be 30 minutes off. It is observed on objectdb explorer as well. Timestamp works perfectly fine. Ps. dont think its a UTC issue. My system is set at far off UTC+30min time.   ... I see the problem on my machine now by running #6 with  -Duser.timezone=Asia/Singapore : 22:40:13 ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ...

 
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 ... MEMBER OF :item.apiId.identifier " + "ORDER BY item.sku DESC" ,ProductData. class ) . ... . sku = : KEY OR id = :id ORDER BY item . sku DESC You may also try this (not valid JPQL but ...

 
manual

Literals in JPQL and Criteria Queries

Describes literals in JPQL, including null, false, true, numbers, strings, dates enums and types.... , 077L ), a feature that is not currently supported by all JPA implementations. String Literals JPQL follows the ... ) and a single quote character in a string is represented by two single quotes (e.g. 'Adam''s' ). ObjectDB ...

 
manual

Paths and Types in JPQL and Criteria API

Explains how to use object expressions (path navigation, type) in JPA/JPQL.... classes and embeddable classes) are represented in JPQL by the following types of expressions: Variables - FROM ... for strings and for numbers ), they can be compared by all six comparison operators , and they can be used in ordering . ...

 
forum_thread

Restrict by class in query

I have the following bit of code: ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ... names) with the code style (can be applied by ctrl + D). Long stack traces (> 50 lines) and complex ...

 
release

2.6.6

... Fixed a bug in ordering query result by an expression that is used in IN operator. Fixed a bug in ... bugs. Fixed a performance issue with mapped by fetch. Fixed the ObjectDB Maven repository and Maven examples ...

 
forum_thread

java 8 LocalDateTime is not working in query

My entity class has a field of type java.time.LocalDateTime. I'm able to persist entities and I'm able to query without datetime field in where clause, but with datetime in where clause doesn't return anything and not exception.   ... Test t WHERE t.date BETWEEN :startDate AND :endDate ORDER BY t.date" ) ; query. setParameter ( "startDate" , ... New Java 8 date/time types are not supported by JPA yet. ObjectDB Support ObjectDB - Fast ...

 
forum_thread

A lot of ENT and SIV instances which are not cleared by GC

Hello. I have a JSF application (Glassfish 4, Java 8, ObjectDB 2.6.0). In some time the heap is getting 95% full with java.lang.OutOfMemoryError: GC overhead limit exceeded.  The first screenshot from VisualVM shows used heap during a 1000 requests stress test. The second shows that after this test there are many com.objectdb.o.ENT and com.objectdb.o.SIV instances. Why isn't it cleaned? I use simple EJB managers containing EntityManagers. On bean's PreDestroy and in servlet's i make entityManager.clear(); ... build 2.6.1_01) a bug in cascading detach through mapped by to-many relationships. Please check the new build. If you still get ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ...