Register / Login
this forum made possible by our volunteer staff, including ...
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?
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
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