6 | Wrong data stored in time only fields(); Query q = em.createQuery("SELECT COUNT(r) FROM DateTime AS r"); Long r = (Long |
6 | com.objectdb.o.NLV cannot be cast to com.objectdb.o.CMVWe 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 |
6 | 100% CPU when using multiple BETWEEN.startDate DESC, r.startTime DESC, r.channelNumber DESC In both cases we limit the result count |
6 | find repeated records by JPQLHi, 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 |
6 | Getting sales quantity per country with a query, an idea anyone? " + "ord.getCountry()," + "COUNT(ord)," + "SUM(ord.getAmountPaid()) " + "FROM OrderData ord " + "WHERE ord |
6 | Exceeding max connections and crashing to the database, initial count was 500 but it wasn’t enough and we increased it to 5000 |
6 | createQuery method errorHello, I am learning ObjectDB now. I create a simple Dao method as below: public boolean isJobExist(String name) { TypedQuery<Long> query = em.createQuery( "SELECT count(j) FROM MFJob j WHERE j.jobName = :name", Long.class); return query.setParameter("name", name |
6 | A nested SELECTHello. I have a query UPDATE Look l SET l.partlySold = FALSE WHERE (SELECT count(a) FROM l.things a WHERE a.thing.status != :status) <= 1 which doesn't work: "Unexpected query token 'SELECT'". Does ObjectDB support queries like this? Thanks. Vladiator Vlad Myachikov Nested queries (issue #11 |
6 | Doctor - high memory usage ------------------- [1] Unexpected total page count: 33024 (expected 33152) Creating a database copy |
1 | InternalException when using MEMBER OF on a large list in a query if you reduce the count (line: 31) to 20.000 or if you switch to the modified query "queryString_Ok |
