aspose file tools*
The moose likes JDBC and the fly likes advantage of JDBC drivers over  JDBC-ODBC bridge Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "advantage of JDBC drivers over  JDBC-ODBC bridge " Watch "advantage of JDBC drivers over  JDBC-ODBC bridge " New topic
Author

advantage of JDBC drivers over JDBC-ODBC bridge

Rao Nadella
Greenhorn

Joined: Jan 19, 2001
Posts: 16
Hi,
Would anyone please explain the advantage of JDBC drivers over JDBC-ODBC bridge ?
Appreciate your response,
Thank you,
-Rao
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
The JDBC-ODBC bridge adds an additional layer of overhead so that it will be slower than a JDBC solution. There has also been some evidence that the JDBC-ODBC contains memory leaks. If a driver is available for a particular database, it should always be used.


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Peter Tran
Bartender

Joined: Jan 02, 2001
Posts: 783
The JDBC-ODBC bridge is just a reference implementation. It's missing a lot of functionality that is in the JDBC 2.0 specification. I couldn't get a metadata object using the bridge driver. You should only use the JDBC-ODBC bridge to try out simple JDBC commands. Once you start doing some serious stuff with JDBC, then you should look into getting a driver implemented for your particular database engine.
Thomas' advice is a good one. Once you're comfortable or know that you'll be using a particular database, then get the JDBC drivers for that database engine.
Rao Nadella
Greenhorn

Joined: Jan 19, 2001
Posts: 16
Thanks very much Peter and Tom.
It's really helpful to get it cleared.
-Rao
Anand Joshi
Greenhorn

Joined: Dec 06, 2000
Posts: 12
Yes! Speed is the most important factor. And also I found that native JDBC drivers to be more flexible and poweful that JDBC-ODBC Bridge


<A HREF="mailto:anandjoshi@india.com" rel="nofollow">anandjoshi@india.com</A>
Rani Mukherjee
Greenhorn

Joined: Jan 14, 2001
Posts: 24
Hi,
Canyone please tell me with an example how memory leakage takes place with JDBC-ODBC bridge
Rani
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
It is a defect in the JDBC-ODBC code apparently. See the sun site: http://java.sun.com for more information.
Michael Mendelson
Ranch Hand

Joined: Dec 19, 2000
Posts: 73
Originally posted by Peter Tran:
I couldn't get a metadata object using the bridge driver.

Peter, this shouldn't be a problem. I do agree on avoiding the Bridge if it can be avoided, though.
Peter Tran
Bartender

Joined: Jan 02, 2001
Posts: 783
Michael,
When I tried get a metadata object, the JDBC-ODBC bridge threw me an exception. I'll try again, but I swore it was *not* working for me.
-Peter
[This message has been edited by Peter Tran (edited January 30, 2001).]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: advantage of JDBC drivers over JDBC-ODBC bridge