About COUNT

forum_thread

Wrong data stored in time only fields

This may be related to the fix for the problem described in this thread: Wrong data stored in date only fields. The object and its date and time fields are the same as in the referenced thread. Except we are using ObjectDB 2.6.4_08, the system time zone is set to EST and both the OS and JVM are using the 2015g time zone data. ... Query q = em. createQuery ( "SELECT COUNT(r) FROM DateTime AS r" ) ; Long r = ( Long ...

 
release

2.4.0

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

 
manual

FROM clause (JPQL / Criteria API)

Explains how to use the FROM clause and JOIN expressions in a JPA/JPQL query.... CHAR_LENGTH, CHARACTER_LENGTH, CLASS, COALESCE, CONCAT, COUNT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP,DELETE, DESC, DISTINCT, ...

 
release

2.4.1

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

 
forum_thread

Left join fetch behaviour doesn't retrieve children?

Hello support, I'm a little bit confused about a left join fetch behaviour. In this test case, i try to fetch my 3 children using a left join fetch. But my collection is null after closing the em. It was expected to be fetched before closing the em, no ? In fact, that is the objective of the fetch purpose (i guess ?). ... than no left join fetch. Example : Doing count(*) of MyEntity => 50000 entities Doing list(MyEntity) => 50000 ...

 
forum_thread

Out of memory

Hi, Today in the middle of the night ODB just crashed leaving this on console screen: ... 113 ) [ 3 ] Unexpected total object count: 3624395444842555492 ( expected 3096704 ) [ 4 ] Unexpected total page count: 2753444525736026431 ( expected 463488 ) is quite ...

 
forum_thread

LazyInitialization / join fetch

I have a survey that carries the tabla Items . A company has several items , a user charge and technical user also . A specialty has several technical users . Area A has a charge . What happens : When I click the Items table hibernate does all these other queries without me asking . I have a survey that carries the tabla Items . Being a company that has multiple items , a user charge and technical user also . A specialty has several technical users . Area A has a charge . What happens : ... where usuario0_.codigo = ? Hibernate : select count ( item0_.codigo ) from the col_0_0_ item item0_ Nov `` ` ...

 
issue

InternalException when using MEMBER OF on a large list in a query

Hello, we get when executing a query with MEMBER OF on a large list the following InternalException: Caused by: com.objectdb.o.InternalException: merge2 com.btc.ep.coverage.bl.internal.dmos.CoverageRecordImpl:null => merger[2850057]-missing:223 at com.objectdb.o.PBI.B(PBI.java:124) at com.objectdb.o.PBI.q(PBI.jave:97) at com.objectdb.o.OBI.Vp(OBI.java:244) (... more see attached Image) Our query looks like this: ... the sample. The example works if you reduce the count (line: 31) to 20.000  or  if you switch to the modified query ...

 
forum_thread

ClassCastException on SELECT NEW ... after UPDATE over Java RMI

Hi, we are using ObjectDB 2.5.4_04 on Linux. Our application, which uses ObjectDb as a DB, exposes a Java RMI interface which allows remote RMI clients to run JPQL queries on the DB. The application internally runs SELECT NEW ... queries. For example: ... clients via RMI after the update. For example SELECT COUNT(*) ..., or SELECT r FROM ... all work fine.   DB ...

 
forum_thread

Doctor - high memory usage

Hi, Is it possible to reduce Doctor memory usage? Right now for recovering 67MB database, I need to set heap space to at least 450MB. Even then whole process takes ages. Optimal setting for this database is about 650MB. It's about ten times of size of database. ... Value Errors ------------------- [1] Unexpected total page count: 33024 (expected 33152) Creating a database copy...............[ObjectDB ...