About INNER JOIN

171-180 of 200Refresh
Issue
1

each 1-2 days objects on some objectdb level lock/block each other

:   select o from ObjectNode o join o.properties p1 join o.linkedObjects c1 where o.classIdentifier ... join o.properties p1 join o.properties p2 where (o.classIdentifier = "(OP)" and o.linkedObjects ... .doubleValue = 0)))   select distinct o from ObjectNode o join o.properties p1  join o.linkedObjects c1
Forum
1

how to query by properties of onetomany relations? (Error 990)

JOIN to define a variable that will iterate over the collection elements. This specific query should be rewritten as follows: select f from Foo f join f.bars b where b.name = ?1 More details ... sql joins :) in my last projects i have been using mongodb and such a query was possible for embedded
Issue
1

queries under 2.7.6_4 significantly slower than under 2.7.6

(you have our test db) select distinct o from ObjectNode o join o.properties p1 where o.classIdentifier = "(OP ... .ObjectNode locating ObjectNode (v$1) instances that satisfy:    (o.linkedObjects join v$1). [Step 2b ... $2) instances that satisfy:    (o.properties join v$2). [Step 3b] Evaluate fields in ObjectProperty
JDO Doc
1

Element.generateForeignKey

Annotation Element javax.jdo.annotations.Element String generateForeignKey Generate or assume a foreign key constraint exists on the column or columns associated with this join. Specify "true" or "false". Returns: whether to generate or assume a primary key constraint Default value: "" Since: JDO 2.1
JPA Doc
1

getModel()

Method javax.persistence.criteria.CollectionJoin CollectionAttribute getModel() Return the metamodel representation for the collection attribute. Returns: metamodel type representing the Collection that is the target of the join Since: JPA 2.0
JPA Doc
1

getModel()

Method javax.persistence.criteria.ListJoin ListAttribute getModel() Return the metamodel representation for the list attribute. Returns: metamodel type representing the List that is the target of the join Since: JPA 2.0
JPA Doc
1

getModel()

Method javax.persistence.criteria.MapJoin MapAttribute getModel() Return the metamodel representation for the map attribute. Returns: metamodel type representing the Map that is the target of the join Since: JPA 2.0
JPA Doc
1

getModel()

Method javax.persistence.criteria.SetJoin SetAttribute getModel() Return the metamodel representation for the set attribute. Returns: metamodel type representing the Set that is the target of the join Since: JPA 2.0
JPA Doc
1

javax.persistence.criteria.AbstractQuery

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

javax.persistence.criteria.Expression

javax.persistence.criteria Interface Expression Superinterfaces: Selection, TupleElement Subinterfaces: CollectionJoin, Case, Coalesce, In, SimpleCase, From, Join, ListJoin, MapJoin, ParameterExpression, Path, PluralJoin, Predicate, Root, SetJoin, Subquery Type for query expressions