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
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.