ObjectDB ObjectDB

Internal Website Search

191-200 of 200 resultsRefresh
14

query hint

: SELECT DISTINCT o from ObjectNode o join o.properties p1 join o.properties p2 join o.properties p3 join o.properties p4 where o.classIdentifier = '(OP)' and o.linkedObjects.classIdentifier = '(TC ... <ObjectNode>(); the query is: SELECT DISTINCT o from ObjectNode o join o.properties p1 join o.properties p2
13

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
12

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
11

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
10

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
10

@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
2

javax.persistence.criteria.AbstractQuery

entities (which may in turn own joins). All queries may have: a conjunction of restrictions
2

Strange Error with Criteria API and Sorting

; import javax.persistence.criteria.Join; import javax.persistence.criteria.Root; public class ... .createQuery(TestEntity.class);   Root<TestEntity> root = query.from(TestEntity.class);   final Join<?, ?> otherJoin = root.join("other");   query.orderBy(cb.asc(cb.upper((Expression<String
2

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
1

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