Home » Search

About COUNT

51-60 of 121Refresh
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
Forum
1

Date field Index is corrupted due to time change

.getTransaction().commit();         Query q = em.createQuery("SELECT COUNT(r) FROM DateTime AS r ... COUNT(r) FROM DateTime AS r");         em.getTransaction().begin();         r = (Long) q
Issue
1

Error 990 when querying a class with persistence-capable-superclass

.spiffymap.jdo.JdoDaoBase.count(JdoDaoBase.java:143) JdoDaoBase.java:143 is the last line of the following: Query query = pm.newQuery(); query.setResult("count(this)"); query.setClass(myClass); return
Forum
1

Group by date / time

DAY() in ODB. So, how to build queries similar to something like this: SELECT COUNT(id) FROM ... something like this: SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 GROUP BY DATE
Forum
1

Help with 'not like/lower' query

Criteria with a combination of LOWER/UPPER - NOT LIKE: SELECT COUNT($1.id) FROM User $1 WHERE ($1.owningCompany=:p1) AND LOWER($1.email) NOT LIKE :p2 So in essence, I'm trying to do a count
Forum
1

Index causes increased memory usage

) and query cache settings on Monday.  I'll have to take a look at the database file count Monday as ... .  The recommended thread count is "more than the number of cores but not too many