ObjectDB ObjectDB

Internal Website Search

61-70 of 77 resultsRefresh

Query in JPA2 with LEFT JOIN on INNER JOIN

and actionprof8_.ID=7 and actionprof9_.ID=9 while my query is select distinct (a.description

How to use JOIN FETCH?

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

An InternalException occurs when gets an result list

yet? support Support it is actually a simple query: select distinct m from ArchitectureImpl m

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

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

ObjectDB 2.2.4

JOIN FETCH with DISTINCT. Fixed Metamodel API's getTypeId method to support single ID field.

ObjectDB 2.1.0

enabled (issue #142). Fixed a bug in distinct queries (duplicates due to bad optimization). Fixed

Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct)

, because without any relationships there is no way of demonstrating the distinction between a Guest

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


Hi, Query: SELECT DISTINCT $1, UPPER($1.name) AS $O0, UPPER($2.lastName) AS $O1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.profile $2 WHERE (($1.getClass().getName()='com.lexware.vereinsverwaltung.verein.api.model.mitglied.Mitglied')) ORDER BY $O0, $O1

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