About COUNT

faq

Is ObjectDB better than competitive object databases?

... products do not support aggregate queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate ...

 
release

2.6.5

... Fixed a memory leak (Negative snapshot user count) in UPDATE queries on uncommitted changes ( issue #224 ). ... optional. Fixed the "Negative snapshot user count" bug ( issue #83 ). Fixed a page cache purge deadlock ( ...

 
release

2.6.6

... Fixed a memory leak (Negative snapshot user count) in UPDATE queries on uncommitted changes ( issue #224 ). ... optional. Fixed the "Negative snapshot user count" bug ( issue #83 ). Fixed a page cache purge deadlock ( ...

 
forum_thread

Conflicting modifiers .... (javax.persistence.Id, javax.persistence.ManyToOne)

I have two classes a Container type class and another class that is 'contained' by that class. The contained class, CompoundKeyMapItem, represents an alternate implementation of an object held in a Map, and uses a Compound Primary Key. The contained class therefore uses an @IdClass. This all works fine on Eclipselink. However when I try and run this in ObjectDb I get the following error; ... name = "numberOfMapItems" , query = "SELECT COUNT(x) FROM CompoundKeyMapItem x" ) } ) public ...

 
forum_thread

How to convert a boolean to an int in the query?

How to convert a boolean to an int in the query? I have five parameters of type boolean in the entity object - approveEmail, approvePhoneNumper, ... I can not sort them ORDER BY approveEmail, approvePhoneNumper, .... because the parameters equivalent. I want to sort them in the query by their sum ORDER BY (approveEmail + approvePhoneNumper + ... ) But I get an exception com.objectdb.o._PersistenceException: Invalid operand type boolean for operator + ... + m . approvePhoneNumber + ... + ( count ( likedPersons ) > 0 ) ) ...

 
release

2.6.4

... Fixed a memory leak (Negative snapshot user count) in UPDATE queries on uncommitted changes ( issue #224 ). ... optional. Fixed the "Negative snapshot user count" bug ( issue #83 ). Fixed a page cache purge deadlock ( ...

 
issue

Internal Exception

Critical error:: com.objectdb.o.InternalException: Unexpected internal exception at com.objectdb.o.JPE.h(JPE.java:165) [objectdb-2.4.4_05.jar:] at com.objectdb.o.ERR.f(ERR.java:70) [objectdb-2.4.4_05.jar:] at com.objectdb.o.OBC.onObjectDBError(OBC.java:1505) [objectdb-2.4.4_05.jar:] at com.objectdb.jpa.JpaQuery.getSingleResult(JpaQuery.java:723) [objectdb-2.4.4_05.jar:] ... Caused by: java.lang.NullPointerException at com.objectdb.o.WVP.q(WVP.java:539) [objectdb-2.4.4_05.jar:] at com.objectdb.o.WVP.l(WVP.java:220) [objectdb-2.4.4_05.jar:] at com.objectdb.o.WV...   With this query: SELECT COUNT ( DISTINCT $1 ) FROM com . lexware . ...

 
forum_thread

100% CPU when using multiple BETWEEN

Hi, we are evaluating ObjectDB 2.5.1_03 in embedded mode. We have a DB of about 2800 instances of a class that has two java.lang.String members: toExtension and fromExtension. There are other members in the class, but not relevant to the problem.   A query like this cause the java process to start running at 100% CPU (endless loop) and it never recovers: ...   In both cases we limit the result count to the first 50 records with Query.setMaxResults(...).   ...

 
release

2.3.5

... optional. Fixed the "Negative snapshot user count" bug ( issue #83 ). Fixed a page cache purge deadlock ( ...

 
forum_thread

10 classes limit

hey. i am a student. and we are learnning inheritance in JPA for my assiment i have 1 base class and 20 subclass in some kind of hierarchy (with all kind of mappings: SINGLE_TABLE, TABLE_PER_CLASS and JOINED). can i use the free version (it will count as 1 class?) or the 10 entity class limit won't allow it?   thank you, Liran. ... and JOINED). can i use the free version (it will count as 1 class?) or the 10 entity class limit won't allow it? ...