ObjectDB Database Search

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

(             em.createQuery("SELECT COUNT (e

and test cases,  I contest that it breaks the rules for JPA2 entities on at least 2 counts

in the last post regarding load we are running - the load is 120000 call per minute, counting

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

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

of entries is zero. - running the app a second time, the count is zero and the average is null

DESC, r.channelNumber DESC   In both cases we limit the result count to the first 50 records

Hello, I am learning ObjectDB now. I create a simple Dao method as below:   public boolean isJobExist(String name) { TypedQuery query = em.createQuery( "SELECT count (j) FROM MFJob j WHERE j.jobName = :name", Long.class); return query.setParameter("name", name).getSingleResult()0 ? true

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

count ( item0_.codigo ) from the col_0_0_ item item0_ Nov `` ` This may be occurring due to not doing

to the database, initial count was 500 but it wasn’t enough and we increased it to 5000

We are using ObjectDB 2.5.1_04. The following JPQL query causes an internal exception: SELECT COUNT (r) FROM RecordingMetaData AS r WHERE ((r.mapFromCli LIKE '192.168.10.13%' ESCAPE '\')) The exception: Caused by: java.lang.IllegalStateException: com.objectdb.o.InternalException: Unexpected

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

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

Hello. I have a query UPDATE Look l SET l.partlySold = FALSE WHERE (SELECT count (a) FROM l.things a WHERE a.thing.status != :status)

to count them). Much more efficient way is to replace setFirstResult with a constraint on the result

hey. i am a student. and we are learnning inheritance in JPA for my assiment i have 1 base class and 20 subclass in some kind of hierarchy (with all kind of mappings: SINGLE_TABLE, TABLE_PER_CLASS and JOINED). can i use the free version (it will count as 1 class?) or the 10 entity class limit

: Doing count (*) of MyEntity = 50000 entities Doing list(MyEntity) = 50000 entities Doing list

;         + " COUNT (ord),"      

WHERE e.pk = :pk or SELECT COUNT (e) FROM MyClass e WHERE e.pk = :pk   support Support

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

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

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

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

Hi, I need to work with Timestamp diff in two entity fields, but this queries SELECT count (p) FROM Player p WHERE p.loginAt.getTime()-p.registeredAt.getTime():value SELECT p.loginAt.getTime() FROM Player p fails with object is not an instance of declaring class or java.lang.ClassCastException

auto generated classes, which are not signed and may be counted against the 10 classes limit

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

smaller(it gets bigger) each hour as record count reduces. Trianglehead Json Error When objects

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

) [objectdb-2.4.4_05.jar:] ... 1 more   With this query: SELECT COUNT (DISTINCT $1) FROM com

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

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

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

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

if you analyse the sample. The example works if you reduce the count (line: 31) to 20.000  or 

.clear(); } }); em.getTransaction().commit(); Query q1 = em.createQuery("SELECT count (my) from MyEntity

"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

count , but still not completely fixes the issue and I'm not sure how scalable this and costly

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

Added support of file-size and object- count queries ( feature request #2968 ). Fixed issue #2964 part 2 (posts 15-...) - refresh after flush can fail.