About COUNT

91-100 of 121Refresh
Forum
1

errors on repair

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 ?   Unfortunately these are critical errors that indicate a corrupted database file. Please provide more information. Can you reproduce
Forum
1

Exceeding max connections and crashing

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

Failed to read the value of field using reflection

can manipulate the object fine. Then I saved, quitted and reloaded the database. Then I try to count
Forum
1

find repeated records by JPQL

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
Forum
1

Getting sales quantity per country with a query, an idea anyone?

(),"                                                                + "COUNT(ord
Forum
1

Grouping by date()

), count(ov) from ObjectView ov group by hour(ov.created) order by hour(ov.created) ASC where ov
Forum
1

How to check if an entity exists in a Database without loading it?

without loading the entity? Thanks   You can use a query: SELECT e.pk FROM MyClass e WHERE e.pk = :pk or SELECT COUNT(e) FROM MyClass e WHERE e.pk = :pk   EKK
Forum
1

How to convert a boolean to an int in the query?

.approvePhoneNumber + ... + (count(likedPersons) > 0)) Following your request we added support
Issue
1

Internal Exception

.HND.run(HND.java:132) [objectdb-2.4.4_05.jar:] ... 1 more   With this query: SELECT COUNT
Issue
1

Internal Exception: null

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