This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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.