About COUNT

61-70 of 126Refresh
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
Issue
1

Issues with JDO Casting & Full Qualified Names

COUNT(e) FROM MyEntity e WHERE ((com.test.F328.EmbeddedB)e.embeddeds.get('test2')).superB = '123 ... HERE         String query = "SELECT COUNT(e) FROM MyEntity e " +             "WHERE ((com.test.EmbeddedB)e
Forum
1

Items in list are doubled, when the entity class is not enhanced

); System.out.println("Item count = "+c.getItemList().size()); em.close(); emf.close(); } } The result is "Item count = 2". Is this another bug
Forum
1

Listing large number of complicated objects with paging.

.setFirstResult(start).setMaxResults(count).getResultList(); is quite slow. Well, after first request ... .hplxtool.dao.impl.ProductDAOImpl - Start: 250, count: 50 2011-11-15 19:31:03.219 [http-bio-8080-exec-3
Forum
1

Optimistic Locking

int count; void increase() { count++; } } } For optimistic locking to work
Forum
1

Out of memory

) [2] Unexpected last type ID: 7882821588231142770 (expected 113) [3] Unexpected total object count: 3624395444842555492 (expected 3096704) [4] Unexpected total page count: 2753444525736026431