File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Object Relational Mapping
From SQL to HQL
Joined: Sep 09, 2009
Sep 09, 2009 13:33:31
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?
I agree. Here's the link:
subject: From SQL to HQL
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
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014