Differnce in using HQL , Criteria API and SQL

Neeraj · **Joined:** Tue Apr 22, 2008 9:03 am **Posts:** 2

Hi,

I am using Hibernate and want to evaluate which is the better mechanism for database interaction out of HQL, SQL and Criteria API.
I want to evaluate above three scenarios on below points.

1. Speed / execution time.
2. Ease of use
3. Complex queries suppport
4. Cache support.

Thanks in advance.

Neeraj Yadav.

Sukirtha · **Posted:** Wed Apr 30, 2008 1:46 am

Use criteria if your queries are complex and you require to build the query on runtime.

Neeraj · **Joined:** Tue Apr 22, 2008 9:03 am **Posts:** 2

Hi Sukirtha,

I found that for complex queries HQL is used, still i am not able to figure out the best approach for fetching data.
Can you please send me the difference in the 3 approaches.

Thanks in advance.

Regards,
Neeraj.