ObjectDB ObjectDB

Internal Website Search

101-110 of 200 resultsRefresh

Fetching Collections Puzzle

this in a query. "select n from Node n left outer join fetch n.children

KEY() / VALUE() not recognized in JPQL??

Hi! Explorer says "unexpected token" on KEY(..: SELECT FROM individual.IndividualContact $1 LEFT OUTER JOIN $1.profile.title.name m WHERE (KEY(m) = 'deu' AND VALUE(m) LIKE '%Dr%') profile = embedded entity title = referenced entity name = Map<String, String> thanks, Alex quasado Alexander Adam

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

Performance issue with query

Hello, we have an issue with following query which needs with objectdb-2.7.6_07 only 15 - 30 milli seconds, but since objectdb-2.7.6_08 the query needs round about 3000 ms. I added a database example in a ticket. SELECT a FROM ArtifactImpl a LEFT OUTER JOIN a.tcSignal s WHERE a.endStep

ObjectDB 2.8.1

Improved query plan evaluation (including for selecting composite indexes). Fixed new statistics collection for queries. Fixed a bug in LEFT OUTER JOIN queries (issue #2438).

Weird issue with variable naming

is that we do a LEFT JOIN on an embedded property as well as ordering is involved in selection ... of our left join variable becomes $1. We're also adding a custom function expression in where clause ... ("embedded", JoinType.LEFT);   final Join<?, ?> join = from.join("map", JoinType.LEFT);   cq


a column for joining an entity association or element collection. If the JoinColumn annotation itself is defaulted, a single join column is assumed and the default values apply. Example: @ManyToOne ... @JoinColumn(name="CUST_ID") // join column is in table for Order public Set


) Specifies a mapping to an entity that is a map key. The map key join column is in the collection table, join table, or table of the target entity that is used to represent the map. If no MapKeyJoinColumn annotation is specified, a single join column is assumed and the default values apply. Example 1

Unexpected query token - AS

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

addSubquery(sub, variableDeclaration, candidateCollectionExpression)

to this Query variableDeclaration - the name of the variable in the outer query to bind the results ... terms of the outer query Since: JDO 2.1 See Also: addSubquery(Query sub, String variableDeclaration

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