Register / Login
Win a copy of
Java 9 Revealed
this week in the
Features new in Java 9
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
Object Relational Mapping
From SQL to HQL
posted 7 years ago
Do you know how can I translate a join with two clauses from SQL to HQL ?
Something like this..
SELECT * FROM t1 LEFT OUTER JOIN t2 ON t1.t_id = t2.t_id LEFT OUTER JOIN t3 ON (t3.t_id = t2.t_id OR t3.t_id = t1.t_id) WHERE t3.val = '123'
I've been hitting my head against the wall to convert the 3rd line to HQL, is it possible?
rocket mass heater
Boost this thread!
sql syntax question
JPA JPQL - How to Order the Joins
Explain Join() method of Thread
No Dialect mapping for JDBC type: -9
org.hibernate.MappingException: No Dialect mapping for JDBC type: -9