About COUNT

51-60 of 126Refresh
Forum
2

Bulk Delete and Update - best practice?

count to be 0 if the database is dropped  but that doesnt seem to be the case. Could you advise ... (); em.clear(); TypedQuery q = em.createQuery("SELECT COUNT(d) from CacheData d", Long ... .createEntityManager(); q = em.createQuery("SELECT COUNT(d) from CacheData d", Long.class); rows = q
Forum
2

composite index not used in query

count(a) from Action a JOIN a.objectsInCharge a1 WHERE ((a1.classIdentifier = '(OP)' and (a1 ... : count(a). Step 5: Apply selection ----------------------- Apply selection and prepare ... , removing all unnecessary components. For example, try this query: SELECT count(a) FROM Action
Forum
2

JPQL keyword in entity - what to do?

.type.name, count(p.id)) from Product as p group by p.type.name I got this exception: com.objectdb ... q = em.createQuery( "select new pl.hplxtool.model.ResultData(p.type.name, count(p.id ... .createQuery( "select new pl.hplxtool.model.ResultData(p.type.name, p.done, count(p.id)) from
Issue
2

Persist & remove in same transaction

& persist a simple entity object, EntityManager is flushed, Transaction is not committed Count ... Remove the entity object, EntityManager is flushed & cleared, Transaction is not committed Count the number of simple entity objects in the database Commit the transaction The count operations in step 3
Issue
2

Unexpected exception (Error 990) on find

% Global Value Errors ------------------- [1] Unexpected total object count: 850986 (expected 850977) [2] Unexpected total page count: 206592 (expected 206563) BTree Value Errors ------------------ [1] local.jpa.entity.ebene1a.MyEntity - Unexpected object count: 850986 (actual 850977
Issue
2

Unexpected Query Token / Casting in Query

Hi! Please find the attached database. Doing a simple query with casting SELECT COUNT(DISTINCT $1 ... COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER ... another casting: SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact
Forum
1

@ElementCollection query returning extra result per element in collection

is that the 'count' of the records is different to the actual retrieval (both using the same queries). THe distinct condition is easy to add to my entities, but not so easy to add with the 'count
Issue
1

[ObjectDB 2.6.9] Unexpected exception (Error 990)

] Unexpected total object count: 189979358 (expected 189979356) BTree Value Errors ------------------ [1] cl.intelidata.jpaodb.Movil - Unexpected object count: 142351618 (actual 142351616) Page
Forum
1

Clarification on free license restrictions

unrestricted numbers of embeddable classes?  Do embeddable classes count as part of the ten?  I assume not ... am very impressed with what I’m seeing, great work guys. Thanks Craig Embeddable classes are count as
Issue
1

Database access error , Doctor hanging on trying to repair, production shutdown at our biggest customer

count: 56960598 (expected 56960597) BTree Value Errors ------------------ [1] com.agile.hummingbird.ObjectProperty   - Unexpected object count: 49830620 (actual 49830619) Page Content Errors