Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC-ODBC bridge

 
Frank Hale
Ranch Hand
Posts: 230
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can I use the JDBC to ODBC bridge to connect to a Sybase database? If so are there any drawbacks to doing so?
Thanks,
Frank
 
John Bateman
Ranch Hand
Posts: 320
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use the JDBC/ODBC bridge to connect to ANY ODBC compliant database. This I beleive includes Sybase, Ms-Sql, Oracle, Poet, Informix, Access, Foxpro, MySql, msSql etc etc.
As for the drawbacks when using JDBC:ODBC, there are MANY. It's slow, it's sluggish and it does not offer the full JDBC2 package. Alot of methods are just plain inaccessible with this driver.
Most documentation I have found claim (in my opinion, wisely) that the JDBC:ODBC bridge driver should ONLY be used for testing and developement.
I actually take this one step further and ONLY use it for my prototypes.
Look for a cheap/free Type 3 or Type 4 driver for your system.
Info: http://java.sun.com/products/jdbc/index.html
Vendors of Drivers: http://industry.java.sun.com/products/jdbc/drivers
Hope this helps.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!