• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Devaka Cooray
  • Ron McLeod
  • paul wheaton
Saloon Keepers:
  • Tim Moores
  • Piet Souris
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Frits Walraven
  • Scott Selikoff

Hibernate Use Cases

 
Ranch Hand
Posts: 441
2
Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am thinking if we need to decide whether we should go for Hibernate or not, then what are the decision criteria? Is hibernate always a good choice to build the DAO layer or there are some scenarios where Hibernate should be avoided?
 
Saloon Keeper
Posts: 26267
186
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
If you're doing very simple database operations or running at low scale, the complexity and overhead of an ORM system such as Hibernate may not be cost-effective.

However, as your needs get more and more demanding, the benefits of an ORM really begin to shine. First of all, junior developers only really need to know Java and not the kinks of raw SQL, secondly, it's easier to get data into a form that the rest of the app can deal with without doing a lot of grunt work (Hibernate + Spring is even better for that). Third, you can often define a set of standard modules for database interfacing, which can save a lot of time and effort thanks to re-usable code and standard practices.

And finally, as the volume and complexity of your database operations scale up, Hibernate can actually run more efficiently than hand-coded SQL JDBC.

SQL, like assembly language is, in theory, the most efficient way of doing things, because it directly addresses the underlying hardware (or database, in this case). However, the sheer magnitude of work involved to manually re-tune everything based on application changes and measured workload becomes too expensive. Hibernate, being an automated system can do such things with relative ease, and so can out-perform hand-coded SQL in such cases. Benchmarks have measured as much as twice the throughput in some cases. But, returning to my first statement, that depends on your workload. At the lower ends, Hibernate's own overhead would cost more than simple SQL JDBC code.
 
Fire me boy! Cool, soothing, shameless self promotion:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic