Internal Website Search

.createQuery("SELECT COUNT(r) FROM DateTime AS r");         Long r

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:

.channelNumber DESC   In both cases we limit the result count

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

;    + "COUNT(ord),"           

we suspect is the number of network connections to the database, initial count was 500 but it wasn’t

Hello, 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

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) <= 1 which doesn't work: "Unexpected query token 'SELECT'". Does ObjectDB support queries like

count: 33024 (expected 33152) Creating a database copy...............[ObjectDB 2.1.1_04

if you reduce the count (line: 31) to 20.000  or  if you switch to the modified query