About COUNT

31-40 of 126Refresh
Issue
4

Issue with UPPER ?

COUNT($1) FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.mitgliedschaft $2 ... LIKE '%81%'))))) # Case (2) SELECT COUNT($1) FROM com.lexware.vereinsverwaltung.verein.mitglied ... %')))))) # Case (3) SELECT COUNT($1) FROM com.lexware.vereinsverwaltung.verein.mitglied
Issue
3

Issue with cascade delete & add/remove

) {         int Address_1_Count = ((Long) em.createQuery(             "SELECT COUNT(a) FROM Address a WHERE street = '1'")             .getSingleResult()).intValue();         int Address_2_Count = ((Long) em.createQuery(             "SELECT COUNT(a) FROM Address a WHERE street = '2
Forum
3

Internal exception when updating date filed (TemporalType.DATE)

GENERATE_PERSONS_COUNT = 1000;         private EntityManagerFactory entityManagerFactory ... ) {                 createPersons(GENERATE_PERSONS_COUNT);             }         }         public ... ();         }         private void createPersons(long count) {             try
Forum
3

Queries are slow on a large database

to get the object with the highest Id. I tried a query like "count(this.Id)" or "max(this.Id)" but I get an exception: [ObjectDB 2.5.0_01]  ==> count <== (this.Id) javax.jdo.JDOUserException Invalid context for aggregate 'count' (error 743) (position 0) at com.objectdb.jdo.JdoQuery.execute0(JdoQuery.java:840
Forum
2

Duplicate Entity class names causes Exception in Query

FROM Item o WHERE o.cachedKey = :cachedKey"), @NamedQuery(name = "objdbTest.Singleton.count", query = "SELECT COUNT(x) FROM Item x") }) public class Singleton implements Serializable { public ... .Singleton.count", Long.class); q.setFlushMode(FlushModeType.AUTO); try { return q
Issue
2

Out of Memory - Slow leak?

. It seems that there is a problem with some heavy objects that ObjectDB manages using reference counting. Somehow in an unknown situation the reference count drops to -1 and then the objects are pinned. Unfortunately ... the problem by blocking an attempt to decrease the reference count below 0. In addition on such attempt
Issue
2

stress test -> com.objectdb.o.InternalException: null

.InternalException: Negative snapshot user count com.objectdb.o.InternalException: Negative snapshot user count ... will not be used anymore by its previous owner. The "Negative snapshot user count" error and a memory ... count" exception and the consequent memory leak. The bug can be reproduced now by the following
Issue
2

Doctor bug?

- Unexpected object count: 1 (actual 0) [2] net.pocketservices.athene.objects.persistent.HotUser - Unexpected object count: 1 (actual 0) [3] net.pocketservices.athene.objects.persistent.Person - Unexpected object count: 2 (actual 0) [4] net.pocketservices.athene.objects.persistent.ReadPointer
Forum
2

how to query by properties of onetomany relations? (Error 990)

(             "select count(f) from Foo f where f.bars.name = :name");         query.setParameter("name", "aaa");         System.out.println("Count: " + query.getSingleResult());         em.close ... . The following 2 queries are now equivalent: select count(f) from Foo f where f.bars.name = :name
Forum
2

Possible issue with timestamps

().commit();              TypedQuery query = em.createQuery("SELECT count(c) FROM CDI c", Long ... ());                 query = em.createQuery("SELECT count(c) FROM CDI c where c.creationDate > {ts ... = em.createQuery("SELECT count(c) FROM CDI c where c.creationDate > :startdate and c.creationDate