ObjectDB Database Search

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

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

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

------------------- [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

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

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

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

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

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

() 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

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

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

; 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

(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

. 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

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

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

. 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

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

(); 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

.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

. 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

we are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1.objectName,sum(p4.doubleValue),sum(p4.doubleValue*p5.doubleValue),0,p7.doubleValue,p3.name, count (o) from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2  INNER JOIN o

count increase much. It would be good to natively add into ObjectDB like me shown on top.That helps

ObjectDB database. The 2 tables for these entities are empty, but the tables exist, so they count

; getRowCount() with a SELECT COUNT query. Implement  getValueAt() with an ORDER BY query. support

we are using version 2.6.7. On running the doctor we have message like free page list broken ... unexpected total page count ... what could be the reason for this ?   hgzwicker Hans-Georg Zwicker Unfortunately these are critical errors that indicate a corrupted database file. Please provide

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

and from remote clients via RMI after the update. For example SELECT COUNT (*) ..., or SELECT r FROM

am comparing 2 dates which should be equal because they are showing exactly same inner millisecond count

with this issue. Query: select hour(ov.created), count (ov) from ObjectView ov group by hour(ov.created) order by

COUNT (a) 5,l4-38}" transactionId="-1" / throws this exception: com.objectdb.o.UserException

ORDER BY (m.approveEmail + m.approvePhoneNumber + ... + ( count (likedPersons) 0)) galandor Orlov Sergey

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

& 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

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

.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

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

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

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

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) 

"is not null"-queries are not working correctly for indexed fields. Following SSCCE creates 1000 entities. A null value is assigned to an indexed field for every second entity. When doing count -queries at the end, wrong results are fetched. import java.io.Serializable; import javax.jdo.annotations

ObjectDB classes. The count of byte arrays grows after flush and clear, although we start the GC

a NullPointerException in query compilation. Fixed a memory leak (Negative snapshot user count ) in

The following query: SELECT count (m) FROM Message m WHERE m.attachments.original=:template is generating this exception: [ObjectDB 2.5.1_05] Unexpected exception (Error 990)   Generated by Java HotSpot(TM) 64-Bit Server VM 1.6.0_32 (on Windows 7 6.1). Please report this error on http://www

have to do this for inserting: @NamedQuery( name="isExistName", query="SELECT count (c) FROM Student c WHERE c

------------------- [1] Page #10 entry 5 has unexpected field count (1 instead of 12)   se.firstinsurance

Hi, Assuming those queries which are all the same except the UPPER calls: # Case (1) SELECT COUNT ($1) FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.mitgliedschaft $2 LEFT JOIN $1.profile $3 LEFT JOIN $3.organisation $4 LEFT JOIN $1.postalAddresses $5 LEFT JOIN $1