Register / Login
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?
It is sorta covered in the
JavaRanch Style Guide
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