ObjectDB ObjectDB

Internal Website Search

111-120 of 138 resultsRefresh

Wrong data stored in time only fields

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

com.objectdb.o.NLV cannot be cast to com.objectdb.o.CMV

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 '' ESCAPE '\')) The exception: Caused by: java.lang.IllegalStateException: com.objectdb.o.InternalException: Unexpected

100% CPU when using multiple BETWEEN

.startDate DESC, r.startTime DESC, r.channelNumber DESC In both cases we limit the result count

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

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

" + "ord.getCountry()," + "COUNT(ord)," + "SUM(ord.getAmountPaid()) " + "FROM OrderData ord " + "WHERE ord

Exceeding max connections and crashing

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

createQuery method error

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 = :name", Long.class); return query.setParameter("name", name

A nested SELECT

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 this? Thanks. Vladiator Vlad Myachikov Nested queries (issue #11

Doctor - high memory usage

------------------- [1] Unexpected total page count: 33024 (expected 33152) Creating a database copy

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

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support