ObjectDB ObjectDB

Internal Website Search

51-60 of 76 resultsRefresh

In version 2.5.2_05 does not work greatest by Date

In earlier versions this query worked fine. In version 2.5.2_05 does not work .orderBy(cb.desc(cb.greatest(root.get("createDate").as(Date.class)))).distinct(true) Thank you for your help. galandor Orlov Sergey Please try build 2.5.2_06 that should fix this regression (of casting to Date). support Support

ObjectDB version 2.1 has been released

). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed a bug in viewing TreeSet

How to use JOIN FETCH?

duplication then this is normal for JOIN FETCH and you can remove duplication by using SELECT DISTINCT

Why the internal error was thrown?

            .getModelElementsByQuery("select distinct m from " + PoolImpl.class.getName() + " m", PoolImpl

ObjectDB 2.3.7

and issue #634). Fixed a bug in using JPQL operations (e.g. UPPER) in DISTINCT results. Fixed an exception

several times a day queries take several minutes

we have queries like (see the database that we handed over to you for other issues) select distinct o from ObjectNode o join o.properties p1 join o.properties p2 where o.classIdentifier = "(OP)" and (o.linkedObjects.classIdentifier = "(TC)" and o.linkedObjects.objectNameUpper = "MILLING-EL" and o

Critical error:: com.objectdb.o.InternalException: Unexpected internal exception with query

This is the query on the attached db (run in explorer): SELECT DISTINCT $1 FROM com.quasado.foundation.warehouse.payment.Payment $1 LEFT JOIN $1.receivable $2 WHERE (( ((($2 IS NOT NULL) AND ($2.receiver.qubletId=22))))) and this is the result: [ObjectDB 2.4.4] Unexpected exception (Error 990

Problem with JOIN and inheritance

Hello, Please run this query on the attached DB: SELECT DISTINCT $1 FROM com.quasado.serviceplaza.customer.VendorCustomer $1 JOIN $1.qubletFRAGMENTMAP $2, com.quasado.foundation.warehouse.contract.customer.CustomerContractsFragment $3 WHERE ((NOT (($2=$3) AND ($3.contracts IS EMPTY

Multiple MEMBER OF query

been tested): SELECT DISTINCT item FROM Item item JOIN item.labels label1 JOIN item.labels label2

Internal Exception

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

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