JPA Multiple Entity with Collection Query

Question

I have the following in SQL:

SELECT * FROM table2 t2, table1 t1 WHERE t1.id=1 AND t2.t1_id IN(1, 2);

How would I do that in JPA?

I tried:

SELECT t2 FROM Table2 t2, Table1 t1 WHERE t1.id = :t1_id AND t2.t1 IN (t1.t1Collection)

With pseudo classes:

Table1
  private int id;
  private Collection<Table1> t1Collection;

Table2
  private int t2;
  private Table1 t1_id;

But I get:

org.hibernate.exception.SQLGrammarException: could not execute query; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

driangle · Accepted Answer · 2012-09-07 20:17:20Z

3

Try the elements keyword:

SELECT t2 FROM Table2 t2, Table1 t1 WHERE t1.id = :t1_id AND t2.t1 IN elements(t1.t1Collection)

answered Sep 7, 2012 at 20:17

driangle

11.8k6 gold badges50 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Steve Ebersole Over a year ago

Just a clarification: IN elements is a Hibernate-specific syntax. The JPA corollary is member of:

Collectives™ on Stack Overflow

JPA Multiple Entity with Collection Query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related