ObjectDB ObjectDB

Internal Website Search

191-200 of 200 resultsRefresh

Performance issues on aggregate query

) from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2 INNER JOIN o.properties p3 INNER JOIN o.properties p4 INNER JOIN o.properties p5 INNER JOIN o.properties p6 INNER JOIN o.properties p7 join o.linkedObjects c1 where o.classIdentifier = '(OP)' and (o.linkedObjects

Problem with distinct select, order by and equivalent alias/attribute path

distinct s_location "             + "from Street s "             + "left join s.location as s_location ... "             + "left join s.location as s_location "             + "order by s.location.id asc ... "             + "from Street s "             + "left join s.location as s_location "             + "order by

ODB IndexActivation NullPointerException

embedded mode and delay closing the database until its completion (e.g. by using join). support ... (ODB-IndexActivation) the Thread.join() was called by ObjectDB. The [pool-5-thread-3] is our thread ... != null) {     try {         indexActivationThread.join();     } catch (InterruptedException e

@OneToOne query issue with OR and IS NULL

another.counter = 0 is a short form of the this equivalent query: SELECT a FROM A a JOIN a.another b ... through a relationship is implemented using JOIN (i.e. INNER JOIN), and only the A instance that has another passes the FROM clause, which precedes the WHERE clause. Try LEFT OUTER JOIN: SELECT

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

Hello! This query is working fine SELECT DISTINCT $1 FROM ChatHistoryItem $1 JOIN $1.recipient $2 JOIN $1.sender $3 WHERE ($2.id='22afeafe-363f-4397-8553-cc5688ba142d') OR ($3.id='22afeafe ... ChatHistoryItem $1 JOIN $1.recipient $2 WHERE ($2.id='22afeafe-363f-4397-8553-cc5688ba142d') ORDER BY MAX

TypedQuery implementation problems

, at.debitSign, at.creditSign, at.reportTypeId)" + " from Account acct" + " left outer join AccountTransaction att on acct.id = att.accountId" + " left outer join Transaction trans on att.transactionId = trans.id" + " left outer join AccountGroup ag on acct.accountGroupId = ag.id

Cast in typed query

: SELECT o FROM OtherType o JOIN o.types t WHERE t instanceof MySpecificType But how can I cast ... JOIN o.types t WHERE t instanceof MySpecificType AND t.value = :value itsme Martin Petzold The solution is a Java-like cast: SELECT o FROM OtherType o JOIN o.types t WHERE t instanceof MySpecificType AND ((MySpecificType)t).value = :value itsme Martin Petzold

Multiple MEMBER OF query

OF is implemented using JOIN with a new synthetic variable for iteration over the collection. In ... due to the conversion to JOIN). However, using separate variables may sometimes make the query more complex ... . As a quick solution, you may replace AND of MEMBER OF with 2 explicit JOIN variables for iteration

[ObjectDB 2.5.5_03] Unexpected exception (Error 990)

FROM Unit t INNER JOIN t.lastGeocodedPosition l WHERE l IS NULL OR l.receiveTime < :last ... LEFT OUTER JOIN t.lastGeocodedPosition l WHERE l.receiveTime < :last See also this paragraph in ... work but I modified it a little bit and now it does: SELECT t FROM Unit t LEFT OUTER JOIN t

Unexpected query token - AS

, artifact FROM com.btc.ep.engine.bl.internal.dmos.EngineInstanceImpl AS instance JOIN instance ... artifact LEFT JOIN artifact.activatedGoals AS artifactActivatedGoals LEFT JOIN artifact.activatedAssumptions AS artifactActivatedAssumptions LEFT JOIN artifact.activatedCalibrations AS

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