ObjectDB Database Search

When am diagnosis my db it gave following report Global Value Errors ------------------- [1] Unexpected total page count : 512 (expected 449). On repair the db some of query are not working. can you please tell me what does the above error mean and how can i resolve this? Thanks   Manoj

Unexpected COUNT Results

- counting characters in a string The LENGTH (str) function returns the number of characters in

_LENGTH, BOTH, BY, CASE, CHAR_LENGTH, CHARACTER_LENGTH, CLASS, COALESCE, CONCAT, COUNT , CURRENT_DATE

do not support aggregate queries (max, min, count , sum and avg). ObjectDB supports rich queries

() Return the update count or -1 if there is no pending result or if the next result is not an update count . Returns: update count or -1 if there is no pending result or if the next result is not an update count . Throws: PersistenceException - if the query execution exceeds the query timeout value set

() Return the update count of -1 if there is no pending result or if the first result is not an update count . The provider will call execute on the query if needed. Returns: the update count or -1 if there is no pending result or if the next result is not an update count .. Throws: PersistenceException

.objectdb.com/database/issue/new com.objectdb.o.InternalException: Negative snapshot user count com.objectdb.o.InternalException: Negative snapshot user count at com.objectdb.o.SNP.D(SNP.java:344) at com ... , the "Negative snapshot user count " and the "mismatch client-server protocol" errors could be caused by

Hello! Attached you find a full stacktrace. The query was: SELECT COUNT (t) FROM Position t WHERE ((t.unit = :unit165w7ppbtu9ao AND t.receiveTime = :receiveTimes232ne30kd42) AND (t.latitude ... exception. Now back to the count query: SELECT COUNT (t) FROM Position t WHERE ((t.unit = :unit AND t

, " + " COUNT (o) as orderCount, " + "AVG(o.price) AS avgOrder " + "FROM Customer c, Orders o

SELECT count (e) FROM Meta e, ImageNet i, Page p WHERE e.idImage=i.id AND e.idPage=p.id; So simple ... can predict the time for such counting ? TIA gzdillon Lai Yang Now, after 2 hours ... variant of your query would be: SELECT count (e) FROM Meta e, ImageNet i, Page p WHERE e.image=i

"), @NamedQuery(name = "objdbTest.Singleton. count ", query = "SELECT COUNT (x) FROM Item x") }) public ... .createNamedQuery("objdbTest.Singleton. count ", Long.class); q.setFlushMode(FlushModeType.AUTO); try { return ... (name = "objdbTest.Singleton. count ", query = "SELECT COUNT (x) FROM objdbTest.Item x

PMImpl objects but with no  QPtBearbeiter instances? One direction forward is to count ... check it tomorow). Arne Arne Stocker create_cound and close_ count are identical. I made create_ count ++ and close_ count ++ each synchronized . And in the end, there was no memory leak at all. Removing

Jakarta Persistence (JPA) Method in jakarta.persistence.StoredProcedureQuery Object getOutputParameterValue (    int position ) Retrieve a value passed back from the procedure through an INOUT or OUT parameter. For portability, all results corresponding to result sets and update counts

counts must be retrieved before the values of output parameters. Parameters: parameterName - name

Jakarta Persistence (JPA) Method in jakarta.persistence.StoredProcedureQuery boolean execute() Return true if the first result corresponds to a result set, and false if it is an update count or if there are no results other than through INOUT and OUT parameters, if any. Returns: true if first

Jakarta Persistence (JPA) Method in jakarta.persistence.StoredProcedureQuery boolean hasMoreResults() Return true if the next result corresponds to a result set, and false if it is an update count or if there are no results other than through INOUT and OUT parameters, if any. Returns: true

. Now after the CDIs creation I'm running a count query and it returns 800 as expected, then I run ... PDIs I create the 800 Organisations I do a count on Organisations and get 800 and then I do "select $1 ... on the first query I'm getting back 0 objects, even though the count before it shows there are 800

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

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

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

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

"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