Hi,

I am very new to Hibernate and has been struggling for weeks.
After reading the documentation of Hibernate, I realised that there are many methods to be used. Eg, Criteria, Named SQL, HQL... etc

I would like to know what is the best method to use when comes to very complicated SQL queries. I need to use one method to do a complicated SQL queries in Hibernate and I am lost in the direction.

Please do give me your kind advise!!
Appreciate it!!

For the complex query, it's better if you use HQL instead of Criteria.
Criteria has a limitation such as cannot join 2 tables or more that don't have any direct association.

Sorry, I would like to know more.

Why not named sql but HQL?? To my understanding, HQL is createSQL inside the code. So if my sql queries is very long, then isnt my code very ugly? I may be wrong. Please do advise me.

Appreciate it!!

Sorry, I would like to know more.

Why not named sql but HQL?? To my understanding, HQL is createSQL inside the code. So if my sql queries is very long, then isnt my code very ugly? I may be wrong. Please do advise me.

Appreciate it!!

Sorry, I would like to know more.

Why not named sql but HQL?? To my understanding, HQL is createSQL inside the code. So if my sql queries is very long, then isnt my code very ugly? I may be wrong. Please do advise me.

Appreciate it!!

Hi,

If you use SQL instead of HQL, maybe some queries will be dependent on particular database.

for example in pagination


So it's better using HQL rather than native SQL.

Thank you so much. I will focus on using HQL.
Thank you!!!