• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database Independency

 
Vishal Dhingreja
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All

Does Hibernate provide us with Database Independency. What I mean to ask is whatever client calls on Hibernate API's will it totally database independent i.e. will the same calls will be reused irrespective of the underlying database (oracle, sqlserver or Db2).
Is it that Hibernate takes all the headache of resolving database specific sql as well as database access

Rgrds
Vishal
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes.
 
Pradeep bhatt
Ranch Hand
Posts: 8927
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul,

Does Hibernate work with all databases for which there are JDBC drivers?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It works with all DB's for which there are both JDBC drivers and Dialects which are Hibernate specific classes which handle stuff like converting between HQL and platform specific flavours of "SQL". There's a page on their web site (here) which lists all supported DB's. As you'll see it supports the major ones. If you are using an odd DB, you can always write a Dialect and submit it to the project.
 
Pradeep bhatt
Ranch Hand
Posts: 8927
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Paul
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic