I must make joined sql in hql.

below code success execute in sqlplus.

but, can't make hql.. didn't understand hql reference.

several modification all failed.



please show me above sql to hql.

thanks in advance.

got the same question,

is there any way to outer join entities which are not related in mappings using HQL?

No. Either add a relation to your mapping file or use Native-SQL.
Regards,
Georg

due to my poor english, I don't exactly understand you two guys said.

In my example code, table1 and table3 all have mapping file.

just I can't make hql from native sql.

Hmm.. my mistake in example code.

success native sql(oralce) is like this..



I make hql from above code like this..



hibernate hql reference can be understand by me..

serveral modification fails..

so, please someone show me correct hql.

thanks in advance..

Asssuming the mappings have the association between the two tables using the serialNo and the 'id' is renamed to something else as its reserved in HQL.
Something like the following


It is likely you will need to use a native query here but hopefully this gives you an idea.

I think what you said "Asssuming the mappings have the association between the two tables using the serialNo..." means they must have explicit association statement in their mapping files or others.

I just have mapping files contain their table schema only.
Primary key of table1 is serial_no, and table3 have serial_no and object_id.
So, table3 has composite key "id" contains serialNo and objectId.

If I need explict "join" statement or something in their mapping files to use "join" in hql.
That means I don't have primary(or base) knowledge about hibernate.

Hmm.. poor english and only one man( no other people around me interesting about hibernate). It takes long time to have practical skill even after used 9month!ㅡㅡ;

even I can't catch what you said " 'id' is renamed to something else..".

and your example code..


maybe incorrect. 'sld1.table3' what means? you mean like this?



sorry..as still newbie after nine month.. for can't understand what you said.

Add a mapping like this to your mapping file for table1:



Furthermore I assume the mapping for table3 looks like this:


After restarting your application you can execute a HQL query like this:
from table1 as sld1
left join sld1.table3Set
where sld3.idval.objectId = 'KKK' or sld3.idval.objectId is null

idval is the name of the composite-id in table3
table3Set is the name of the association from table1 to table 3

Regards,
Georg

Georg!

You completly helped me understand that david wrote.

thank you very much.

It is very helpful!