wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes When we choose SQL,HQL and Criteria API of hibernate? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "When we choose SQL,HQL and Criteria API of hibernate?" Watch "When we choose SQL,HQL and Criteria API of hibernate?" New topic
Author

When we choose SQL,HQL and Criteria API of hibernate?

Murugesan Pitchandi
Greenhorn

Joined: Nov 19, 2008
Posts: 8

I have java application which is going use hibernate. My doubt is when we choose SQL,HQL and Criteria API of hibernate?
Bill Gorder
Bartender

Joined: Mar 07, 2010
Posts: 1680
    
    7

Short answer which gives some general guidelines but not necessarily right for every scenario:

- HQL - use this (preferably named) for most queries. They are easy to read and write.
- Criteria - use this for dynamic queries
- SQL - use this where the other 2 are not a good fit or you want to do something Hibernate either is not designed for, or does not do well. Often times this may be using straight JDBC for some stored procedure work, or batch jobs for example. While Hibernate can do these things it is not always the best choice.


[How To Ask Questions][Read before you PM me]
Murugesan Pitchandi
Greenhorn

Joined: Nov 19, 2008
Posts: 8

Thanks Bill for your reply.

SQL - use this where the other 2 are not a good fit or you want to do something Hibernate either is not designed for, or does not do well. Often times this may be using straight JDBC for some stored procedure work, or batch jobs for example. While Hibernate can do these things it is not always the best choice.

You mean to say, in case your application having stored procedure/batch process then HQL and Criteria API of hibernate work and it will support by SQL only. Please correct me if i am wrong.

Thanks and Regards,
Murugesab
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: When we choose SQL,HQL and Criteria API of hibernate?