About ORDER BY

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

 
forum_thread

Issue with alias

Hi, This query works and correctly casts and selects my entity into the tuplet: SELECT $1, ((com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedDebitorenKontoFragment)$1.qubletFRAGMENTMAP.get('com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedDebitorenKontoFragment')) AS DEB FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE DEB.debitor=true however, trying to access "DEB" in the where clause causes an "unexpected token" error? Alex ... A result alias can only be used in the ORDER BY clause of the query (and after query execution in managing result elements ...     FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER BY and you cannot use an ...

 
release

2.6.8

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

 
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

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

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

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

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