Question { TCS, 10959 }

what are advantages of HQL?
what are advantages of Native SQL?
what are advantages of Criteria API?

Answer

find a persisted user by user id which was primary key in
that case. What if we want to search a user by user name,age
or email and none of these attributes is a primary key.
Hibernate provides a query language similar to the standard
SQL to perform operations on the Hibernate objects. The
advantage of using HQL instead of standard SQL is that SQL
varies as different databases are adopted to implement
different solutions,but HQL remain the same as long as you
are within the domain of Hibernate; no matter which database
you are using