JPA - left join 2 tables without association

Question

I have 2 tables/entities with no association. I can go for cross joins in JPA

FROM A as a, B as b WHERE b.col1=a.col1

How Can I perform a left-join?

I want all values from A and fill them up with B values where possible and leave NULL where there is no B.

Does not work:

FROM A as a LEFT JOIN B as b WHERE b.col1=a.col1

Path expected for join!

Invalid path: 'b.col1'

Answer 1

Apparently you can now do this as of Hibernate 5.1

Answer 2

You cannot do that in JPA, as long as there is no relationship between the entities.

Solutions:

1. Use Native queries.
2. Add a relationship between them (eventually an indirect lazy one). With indirect I mean something like : A knows PseudoEntity, PseudoEntity knows B (but the relationship owner is entity B), B knows PseudoEntity.