aspose file tools*
The moose likes Object Relational Mapping and the fly likes Database Independency Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Database Independency" Watch "Database Independency" New topic
Author

Database Independency

Vishal Dhingreja
Greenhorn

Joined: Nov 19, 2004
Posts: 15
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

Joined: Apr 14, 2004
Posts: 10336

Yes.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

Paul,

Does Hibernate work with all databases for which there are JDBC drivers?


Groovy
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

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

Joined: Feb 27, 2002
Posts: 8919

Thanks Paul
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database Independency