ObjectDB Database Search

1-50 of 104 results

getting "Unexpected total page count" error when diagnosis mu db by ObjectDB doctor.

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

Processing thread count for 8-core server

In reference to the information here:  https://www.objectdb.com/java/jpa/setting/database#The_processing_element _   We are working with an 8-core processor.  The recommended thread count is "more than the number of cores but not too many."  What would be an appropriate number

Unexpected COUNT Results

Unexpected COUNT Results

Running JPA Queries

the database: TypedQuery query = em. createQuery ( "SELECT COUNT (c) FROM Country c", Long.class); long ... is straightforward: Query query = em. createQuery ("SELECT COUNT (c) FROM Country c"); long countryCount = (Long)query. getSingleResult (); By definition, an aggregate COUNT query always returns one result. In

Strings in JPQL and Criteria Queries

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

FROM clause (JPQL / Criteria API)

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

Is ObjectDB better than competing object databases?

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

JPA Query Structure (JPQL / Criteria)

) Criteria WHERE ( where ) Criteria GROUP BY / HAVING ( groupBy , having , count , sum , avg , min

Numbers in JPQL and Criteria Queries

Numeric values can appear in JPQL queries in several forms: As numeric literals , such as 123 and -12.5 . As parameters that are bound to numeric arguments. As path expressions that navigate to persistent numeric fields. As aggregate expressions , such as COUNT . As collection functions

Privacy Policy

gifs) that permit the Company, for example, to count users who have visited those pages or opened

jakarta.persistence.criteria.CriteriaBuilder

array-valued selection item. Since: Jakarta Persistence (JPA) 1.0 Expression count ( Expression x ) Create an aggregate expression applying the count operation. Parameters: x - expression representing input value to count operation Returns: count expression. Since: Jakarta Persistence (JPA) 1.0

Negative snapshot user count

I finally hit an instance of the "Negative snapshot user count " exception 1) [ObjectDB 2.3.2_01 ... .InternalException: Negative snapshot user count com.objectdb.o.InternalException: Negative snapshot user count at com.objectdb.o.SNP.z(SNP.java:292) at com.objectdb.o.SFL.Z(SFL.java:765) at com.objectdb

Negative snapshot user count exception

.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

ClassCastException thrown when running count query

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

jakarta.persistence.StoredProcedureQuery.getUpdateCount()

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

jakarta.persistence.StoredProcedureQuery.executeUpdate()

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

jakarta.persistence.ConstructorResult

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

Join performance in Objectdb

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

Duplicate Entity class names causes Exception in Query

"), @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

Memory Leak in EntityManagerFactory ?

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

EntityManagerFactory Fails To Swtich Over To Slave When Master Is Unavailable

back over to the master (10,000). COUNT = 9 Entity manager is: ObjectManager of /10.9.2.15:10001 [2013-05-08 ... : 5000 Average X: 499.5 COUNT = 10 Entity manager is: ObjectManager of /10.9.2.15:10000 [2013-05-08 11 ... only to the slave, I get the following exception. COUNT = 0 Failed to create entity manager. COUNT = 1 [ObjectDB 2.5

Query Method NullPointerException on List iteration

: categoryId categoryName   Expected query outcome: SupplierName Category1_ Count Category2_ Count ... count = 0; for (Product p : products) { if (p.getCategory().getCategoryName().equals(categoryName)) { count ++; } } return count ; }   Problem: I get a NullPointerException on List products

jakarta.persistence.StoredProcedureQuery.getOutputParameterValue(int)

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

jakarta.persistence.StoredProcedureQuery.getOutputParameterValue(String)

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

jakarta.persistence.StoredProcedureQuery.execute()

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.StoredProcedureQuery.hasMoreResults()

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

Exception on creation when running multithreaded

. 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

OEM licencing limitation

how is the number of persistent objects counted . We unfortunately don't have the objectdb file anymore ... (); } Could you please confirm us, how the licencing works in this case? Are only internal entities counted to limited number or ... and instances of unsigned classes are counted . In this case, if test is enhanced with an OEM activation

Internal exception when updating date filed (TemporalType.DATE)

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

Bulk Delete and Update - best practice?

the following test I'm expecting the second row count to be 0 if the database is dropped  ... .createQuery("SELECT COUNT (d) from CacheData d", Long.class); long rows = q.getSingleResult ... .createEntityManager(); q = em.createQuery("SELECT COUNT (d) from CacheData d", Long.class); rows = q.getSingleResult

composite index not used in query

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

Speeding up reporting queries with size() on list

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

Database corrupted after schema change

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

@ElementCollection query returning extra result per element in collection

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

Optimistic Locking

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

Getting the database file size

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

Date field Index is corrupted due to time change

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

Queries are slow on a large database

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

Group by date / time

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

EmbeddedId with Generated field value

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

DBDoctor BTree Errors

.pool.PoolImpl   - Unexpected page count : 958 (actual 1)   - Unexpected object count : 9043 ... count : 8 (actual 1)   - Unexpected object count : 392 (actual 1) [3] com.btc.ep.base.bl.internal.dmos.licensing.LicensingInfoImpl   - Unexpected object count : 4 (actual 1) [4] com.btc.ep.base

Out of Memory - Slow leak?

. It seems that there is a problem with some heavy objects that ObjectDB manages using reference counting . Somehow in an unknown situation the reference count drops to -1 and then the objects are pinned ... . It should solve the problem by blocking an attempt to decrease the reference count below 0. In addition

Doctor bug?

count : 1 (actual 0) [2] net.pocketservices.athene.objects.persistent.HotUser - Unexpected object count : 1 (actual 0) [3] net.pocketservices.athene.objects.persistent.Person - Unexpected object count : 2 (actual 0) [4] net.pocketservices.athene.objects.persistent.ReadPointer - Unexpected object count

Corrupt database page

------------------ [1] com.btc.ep.base.bl.internal.dmos.message.MessageImpl   - Unexpected object count ... field count (12 instead of 6)   com.btc.ep.base.bl.internal.dmos.message.MessageImpl(375 ... ] Page #11436 entry 2 has unexpected field count (44 instead of 6)   com.btc.ep.base.bl.internal

Unexpected exception (Error 990) on find

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

Unexpected Exception (Error 990) with ArrayIndexOutOfBoundsException

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 & remove in same transaction

& 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

Querying error - java.lang.ClassCastException: com.objectdb.o.STV

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

Issues with JDO Casting & Full Qualified Names

= "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

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

.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