File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

advantage of JDBC drivers over JDBC-ODBC bridge

 
Rao Nadella
Greenhorn
Posts: 16
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13974
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Peter Tran
Bartender
Posts: 783
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 16
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks very much Peter and Tom.
It's really helpful to get it cleared.
-Rao
 
Anand Joshi
Greenhorn
Posts: 12
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Rani Mukherjee
Greenhorn
Posts: 24
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Canyone please tell me with an example how memory leakage takes place with JDBC-ODBC bridge
Rani
 
Thomas Paul
mister krabs
Ranch Hand
Posts: 13974
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 783
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic