Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What is ODBC

 
Rashmi Pant
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please tell me what is Open Database Connectivity(ODBC).
In case of Type1 driver we say that this driver cponverts jdbc call to odbc function calls what is the meaning of this statement.What type of conversion is this.
Thanks
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15485
43
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try Google:
http://www.tech-faq.com/odbc.shtml
http://www.webopedia.com/TERM/O/ODBC.htm
http://en.wikipedia.org/wiki/Open_Database_Connectivity

ODBC is an interface that software can use to interact with a database. Java has its own database API, JDBC. Sun has a JDBC driver which connects to a database via ODBC:

Java program <--> JDBC <--> ODBC <--> Database
 
Kamal Sharif
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
But for SQL Server 2005,is it preferred to use ODBC bridge or using the native JDBC driver by Microsoft? I have done many tests and in all the tests ODBC seems faster and I am confused as why bothering with JDBC Driver at all?
Thanks
Kamal
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When you are communicating with MSSql directly in an all-windows environment, ODBC may be faster.

JDBC can't talk directly to ODBC and therefore needs a bridge, so then you have

Java app -> JDBC -> JDBC-ODBC Bridge -> ODBC -> MSSql

You don't need to talk via the bridge, and the JDBC-ODBC Bridge is not great - it was never meant to be. Instead (when using Java) it is better to use the Type-4 (native dtaabase) driver if available, giving you:

Java app -> JDBC -> Native driver -> MSSql
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Kamal Sharif:
But for SQL Server 2005,is it preferred to use ODBC bridge or using the native JDBC driver by Microsoft? I have done many tests and in all the tests ODBC seems faster and I am confused as why bothering with JDBC Driver at all?
Thanks
Kamal


You might try jTDS. I've no idea about perfomance (it has never been an issue for me using a type 4 driver against any database), but it is generally a better product that MS's own driver.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic