Hi , Please tell me what is the reason for using HQL , when the same thing can be done with the help of normal SQL query.

Sessions createSQLQuery()

How does an HQL will improve the performance as it will be internally converted to an SQL Query Itself.

Thanks in advance .

We can use SQL queries too in Hibernate... Some of the advantages of using HQL are:

1. HQL choses the best SQL statement from a set of SQL statetments for performing a task.
2. Using HQL will help in portability. ie: you can export your entire DB(from oracle i think u are workin on oracleDB) to some other DB with no much changes. You need to change the dialect and driver name in the config file.


Rate if found helpful

Thank you very much for your time .That was nice .