How can I join entities with criteria?

Question

I have two entity classes which don't contain any association in their mappings.

@Entity
@Table(schema = "mailing", name = "recipient_code_statistics")
public class RecipientCodeStatistics {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private int id;

    @Column(name = "recipient_code_id", unique = true)
    private long recipientCodeId;

    //GET, SET
}

and

@Entity
@Table(schema = "mailing", name = "recipient_code")
public class RecipientCode {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private long id;

    @Column(name = "code")
    private String code;

    //GET ,SET
}

Is it possible to write a criteria query, similar to the following:

SELECT * 
FROM recipient_code_statistic 
LEFT OUTER JOIN recipient_code
ON recipient_code_statistic.recipient_code_id = recipient_code.id
WHERE recipient_code.code = '123'

Whitout declaring association with @OneToMany annotation in the mapping explicitly?

score 1 · Accepted Answer · edited May 23 '17 at 12:20

1

It isn't possible to write an explicit join without mapping the two entity objects. But you could do a subquery.

Here is a reference to a similiar question.

And here the link to the answer containing a subquery example

edited May 23 '17 at 12:20

Community

1
1

answered Feb 26 '15 at 13:24

BeWu

1,941
1
16
22

score 1 · Answer 2 · answered Feb 26 '15 at 13:28

1

try using a native query @NativeQuery()

answered Feb 26 '15 at 13:28

Andre Coetzee

1,260
3
20
34

NativeQuery looks as I should write sql-query. But I'm interested in a criteria-like solution. – user3663882 Feb 26 '15 at 13:30

How can I join entities with criteria?

2 Answers2