This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes HQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "HQL" Watch "HQL" New topic


Cloey Tan
Ranch Hand

Joined: Feb 03, 2009
Posts: 60
Does HQL cater for any type of database? be it mysSQL or postgres? and does mysql has this kind of function?
Vikas Kapoor
Ranch Hand

Joined: Aug 16, 2007
Posts: 1374
Hello Cloey,

I am unable to understand your question. Provide more details. If you are looking for supported database by Hibernate then have a look at

HQL stands for Hibernate Query Language. It means it can be successfully executed on all supported databases. Other types are native queries means, it can be executed for particular database only. HQL gives portability.
Manjit Johal

Joined: Mar 16, 2009
Posts: 2
I agree with Vishal - HQL is only concerned with the domain objects that you have mapped out in your configuration, and operates at a higher level of abstraction. The Hibernate Dialect you have specified (be it mysql or postgres) is used to generate the actual sql that gets executed at runtime.
I agree. Here's the link:
subject: HQL
Similar Threads
how to use UNION function in HQL?
hibernate subqueries
subquery sql to hql
HQL Tutorial?
Classcast exception