Home » Search

About join

181-190 of 200Refresh
JPA Doc
3

PrimaryKeyJoinColumn.name

Annotation Element javax.persistence.PrimaryKeyJoinColumn String name (Optional) The name of the primary key column of the current table. Defaults to the same name as the primary key column of the primary table of the superclass (JOINED mapping strategy); the same name as the primary key column
JPA Doc
3

SecondaryTable.pkJoinColumns

Annotation Element javax.persistence.SecondaryTable PrimaryKeyJoinColumn[] pkJoinColumns (Optional) The columns that are used to join with the primary table. Defaults to the column(s) of the same name(s) as the primary key column(s) in the primary table. Default value: {} Since: JPA 1.0
JDO Doc
3

Value.generateForeignKey

Annotation Element javax.jdo.annotations.Value 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 foreign key constraint Default value: "" Since: JDO 2.1
Forum
3

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
Issue
3

Strange Error with Criteria API and Sorting

.Join; import javax.persistence.criteria.Root; public class Test_OrderBy { public static void ... root = query.from(TestEntity.class);   final Join otherJoin = root.join ... in thread "main" [ObjectDB 2.4.4_08] SELECT DISTINCT $1 FROM TestEntity $1 JOIN $1.other $2 ORDER
Forum
2

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

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

ODB IndexActivation NullPointerException

(e.g. by using join). We run still into a dead lock. I adding a few screenshots and I hope it help ... ]  ->  waiting for  Thread id:427  (ODB-IndexActivation)   the Thread.join() was called by ObjectDB ... ;     } } if (indexActivationThread != null) {     try {         indexActivationThread.join();     } catch (InterruptedException
Forum
2

@OneToOne query issue with OR and IS NULL

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 a FROM A a LEFT JOIN
Forum
2

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

[ObjectDB 2.5.5_03] Unexpected exception (Error 990)

JOIN t.lastGeocodedPosition l WHERE l IS NULL OR l.receiveTime < :last and since there is no t.lastGeocodedPosition there are no results. Maybe you should try: SELECT t FROM Unit t LEFT OUTER JOIN ... bit and now it does: SELECT t FROM Unit t LEFT OUTER JOIN t.lastGeocodedPosition l WHERE l