• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

advantage of JDBC drivers over JDBC-ODBC bridge

 
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
mister krabs
Posts: 13974
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Bartender
Posts: 783
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks very much Peter and Tom.
It's really helpful to get it cleared.
-Rao
 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 13974
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 73
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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).]
 
Don't mess with me you fool! I'm cooking with gas! Here, read this tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic