About expression

manual

UPDATE SET Queries in JPA/JPQL

Explains how to apply server side bulk update using a JPA/JPQL query. Existing entity objects can be updated, as explained in chapter 2 , by: Retrieving the entity objects into an EntityManager . Updating the relevant entity object fields within an active transaction. ...

 
release

2.4.7

Release date: 2013-02-25 Download (5.42 MB) Binary:  objectdb-2.4.7.zip You should start by following a  tutorial or reading the manual ...

 
forum_thread

Problems down-casting in WHERE clause

I have a family of related types, like this: @Entity class Base { String val1; String val2; }; @Entity class Derived1 extends Base { String val3; }; @Entity class Derived2 extends Base { String val4; };  I'm trying to implement a query which will return all Base objects which have a given string within any of their String-typed fields.  The query I'm using looks somewhat like this: ... ((Practice)e).messageList.message  is an invalid expression in JPQL because  messageList is a List and navigation from a ... ((Practice)e).messageList is not a valid FROM/JOIN range expression. Apparently there is no support for your query in JPQL or ...

 
forum_thread

Optimization of Map Queries

hi! I am having loads and loads of occurrences of something like ((com.test.MyEntity) $1.map.get('com.test.MyEntity')).someProperty ... ((com.test.MyEntity) $1.map.get('com.test.MyEntity')).someOtherProperty .. ((com.test.MyEntity) $1.map.get('com.test.MyEntity')).someMoreProperties I need to use full qualified names for casting as well as for the map keys because same entity simple names may occur multiple times. Now I've got two questions: ... introducing a variable using JOIN that is bound to the expression could help (at least the method will be invoked once). ... Binding a variable to a complex expression is an ObjectDB extension, so it might not be available in criteria ...

 
forum_thread

How to query for list of lists ?

Hi, I have a problem with constructing query, that gets only embedded list of integers from Entity. Here's the example : Query query = em.createQuery("SELECT i.filterDescription FROM Inspiration i"); List<List<Integer>> result = query.getResultList(); where Inspiration is like this : ... Caused by: com.objectdb.o.UserException: Invalid result expression 'java.util.List' for an aggregate query at ...   I get the same error: "Invalid result expression 'java.util.List' for an aggregate query" Class: ...

 
release

2.2.5

Release date: 2011-05-20 Download (5.1 MB) Binary:  objectdb-2.2.5.zip You should start by following a  tutorial or reading the manual ...

 
release

2.4.5

Release date: 2012-12-13 Download (5.41 MB) Binary:  objectdb-2.4.5.zip You should start by following a  tutorial or reading the manual ...

 
forum_thread

ORDER BY problem, when String starts with language specific character

Dear all, I have a problem with ORDER BY clause. I have a simple query: select u from User u order by u.name When the name starts with "normal/english" character, records are ordered correctly. But when it starts with language specific character like 'Č', these records are placed after records with normal charaters. So records with 'Č' are after 'Z', but this is not correct, because 'Č' is between 'C' and 'D'. ... to JPQL and JDOQL) you can use the Normalizer expression directly in the query ORDER BY clause. However, if you ...   I've tried to add the normalizer expression into order by clause, but it thorws this exception: ...

 
release

2.4.6

Release date: 2013-01-16 Download (5.42 MB) Binary:  objectdb-2.4.6.zip You should start by following a  tutorial or reading the manual ...

 
release

2.4.4

Release date: 2012-10-13 Download (5.4 MB) Binary:  objectdb-2.4.4.zip You should start by following a  tutorial or reading the manual ...