I have 2 classes which has no reference relation between them (for some reason, I can not do any mapping in them)
For instance,



basically, Resource.name=Page.uuid. I can use such native SQL here:
select * from resource as r left outer join page as p on r.name = p.uuid where p.uid=1

In other words, I just want to use "on" keyword to declare joined fields. Is it possible in HSQL or others Hibernate format (except native SQL?)

Thanks

The reason I don't use native SQL is, I try to avoid hard-code table name in query string. So, it is good suggestion as well if it makes me to avoid table name hardcode (e.g, using class name instead).

HQL require the relation to be defined to use outer join.

so, it means impossible to avoid table name in hardcode in my case?

hi

try to use criteria


Amila
(Don't forget to rate if helps)