ObjectDB Database Search

GENERATE_PERSONS_ COUNT = 1000;         private EntityManagerFactory ... _PERSONS_ COUNT );             }     ... ; }         private void createPersons(long count ) {   

objectsInCharge = new ArrayList (); on running a query like select count (a) from Action a JOIN ... results --------------------- Evaluate aggregate expressions: count (a). Step 5: Apply selection ... components. For example, try this query: SELECT count (a) FROM Action a WHERE a.state = 3 AND a.subType = 3

(); } @PersistenceCapable static class Counter { private int count ; void increase() { count ++; } } } For optimistic

. Anyway, one of my methods in DAO looks like this:  public List list(int start, int count , String ... .setFirstResult(start).setMaxResults( count ).getResultList();    logger.debug("Query executed

(); em.refresh(c); System.out.println("Item count = "+c.getItemList().size()); em.close(); emf.close(); } } The result is "Item count = 2". Is this another bug? Michael   anaq x I've found out a new

. This is using 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

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

my app is that the ' count ' of the records is different to the actual retrieval (both using the same ... with the ' count ' while re-using the same predicates.   This is indeed, not a bug Willks William

; TypedQuery q = em.createQuery("SELECT COUNT (x) FROM Item x", Long.class);   try {    ... You are right! I was doing a count with the flush mode auto on... If I don't I can't see any

.setFirstResult(start).setMaxResults( count ).getResultList(); is quite slow. Well, after first request and "warming ... .impl.ProductDAOImpl - Start: 250, count : 50 2011-11-15 19:31:03.219 [http-bio-8080-exec-3] DEBUG pl

use unrestricted numbers of embeddable classes?  Do embeddable classes count as ... pricecap72 Craig A Price Embeddable classes are count as entity classes but other serializable classes

500ms and 1.2 sec. The same query without counting products runs in 15-30ms each time. My question is - how to speed this type of queries, where you have to count objects on some lists?   lwalkowski

(page) and query cache settings on Monday.  I'll have to take a look at the database file count ... , we are working with an 8-core processor.  The recommended thread count is "more than the number

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

It's a good suggestion. But this way how objectDB would count each object instances? Would it be 1 or 2 ... Ornano Every object is count once even if it is an instance of a class with a deep inheritance

example, I want 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

;  Query q = em.createQuery("SELECT COUNT (r) FROM DateTime AS r");       ... ; q = em.createQuery("SELECT COUNT (r) FROM DateTime AS r");        

However, it appears that the super classes in the explorer count toward the ten (10) table limit for the free ... , DataNucleus, etc.). Accordingly, a mapped superclass is counted as an entity class.   support Support

thread for every DB Connection (using JDO and PersistenceManager) and not closing any of it. I've counted the DB connections during whole run of the application and it was +- the same as count of live

------------------- [1] Page #19753 entry 0 has unexpected field count (7 instead of 5) 0. oid = '567651' 1. deleted ... #33279 entry 1 has unexpected field count (7 instead of 5) 0. oid = '559770' 1. deleted = false 2

. However it could still help in certain cases (e.g., a count query, as part of a composite index ... that such an index would be useful. For example, an index on a gender field can be helpful in count queries

- count ", Long.class).getSingleResult(); System.out.printf("Object Count : %d%n", objectCount); } } support Support

count , String sortColumn, boolean isAscending) I have to prepare correct query as a String using

------------------- [1] Unexpected total page count : 33024 (expected 33152) Creating a database copy

;     return db.createQuery("SELECT count (p) = 0 FROM Player p", Boolean.class

Point and Line objects (as per the tutorial) to the master database and then attempts to count

; System.out.println(" count : " + query.getResultList().size());         em

;              int count = 1000000;  

I move on to testing the multi threaded part of ObjectDB. From the same code (MyMain.java), I set the thread count from 1 to 4 and not only do I found it's slower overall (each thread only needs to insert 250K entities) but the threads are stuck with a deadlock. All threads share the same

of @Embeddable objects? ie. Suppose I want to query: SELECT count (a) FROM A a WHERE a.setOfB.value

), click Validate Plugin-ins button (third on right from below, counting vertically from the "Close

table" or "truncate" can clear the id counting . Any idea? gzdillon Lai Yang Resetting generated ID

Hi, I know a single command in MySQL can find repeated records: Select * from TTT t where id in (select id from TTT s group id having count (id)1) I dont know how to do this using JPQL, but I use query from 430,000 records and put them into hashmap, finally it cost one hour and failed: Exception in

= "numberOfMapItems", query = "SELECT COUNT (x) FROM CompoundKeyMapItem x") }) public class Container { public

= "SELECT COUNT (x) FROM ECompoundKeyMapItem x WHERE x.container = :container") }) public class

------------------- [1] Unexpected total object count : 850986 (expected 850977) [2] Unexpected total page count ... - Unexpected object count : 850986 (actual 850977) Page Relation Errors -------------------- [1] Page

em) { synchronized (mutex) { final Query count = em.createQuery("SELECT COUNT (p) FROM EventLogPersistEntry p"); long rows = 0; try { rows = (long) count .getSingleResult(); } catch (final

ID: 7221069219291554102 (expected 11) [4] Unexpected total object count : 3691044274576634723 (expected 1378) [5] Unexpected total page count : 8719319783396618851 (expected 2816) Page Relation Errors

= "SELECT COUNT (e) FROM MyEntity e WHERE ((com.test.F328.EmbeddedB)e.embeddeds.get('test2')).superB ... ; // FAIL WITH EXCEPTION HERE         String query = "SELECT COUNT (e

Hi! Please find the attached database. Doing a simple query with casting SELECT COUNT (DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER(((com.quasado ... .model.account.contact.IndividualContactDebitorAccountFragment': Identifier is expected SELECT COUNT

.execute(JdoQuery.java:720) at com.spiffymap.jdo.JdoDaoBase. count (JdoDaoBase.java:143) JdoDaoBase.java:143 is the last line of the following: Query query = pm.newQuery(); query.setResult(" count

------------------- [1] Unexpected total object count : 1041631 (expected 1041630) BTree Value ... count : 773 (actual 772) Page Relation Errors -------------------- [1] Page #442580 unexpected exception

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

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

ok: SELECT COUNT (item.sysID) FROM CUIT item WHERE  ( (item.sysStatus.sysID=1)  AND  ... .NullPointerException SELECT COUNT (item.sysID) FROM Nosis item WHERE  ( (item.sysStatus.sysID=1) 

open databases do you use concurrently? Following the thread dump I count about 9 open databases

The query SELECT COUNT (t) FROM TrackerUser t WHERE NOT t.username = :username with :username - "admin" leads to the following exception: com.objectdb.o.InternalException: null com.objectdb.o.InternalException at com.objectdb.o.InternalException.f(InternalException.java:236) at com.objectdb.o.WSP.h

the "Negative snapshot user count " error ( Issue #556 ). Please try build 2.3.3_04 that should solve

Added OSGi support. Added support of MEMBER OF for inverse (mapped by) collections. Changed logging of incomplete recovery records from WARNING to TRACE  ( issue #565 ). Changed main configuration elements from required to optional. Fixed the "Negative snapshot user count " bug ( issue #556

.createQuery("SELECT COUNT (c) FROM Chapter c");         System.out.println