File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
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).]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: advantage of JDBC drivers over JDBC-ODBC bridge
 
Similar Threads
Any alternative to JDBC???
Does JDBC works on all ODBC
Driver supporting connection pooling
JDBC Drivers
JdbcOdbc Connection