ODBC and JDBC

1
ODBC and JDBC

• Aggie Hoversten
• CSCI 397-16
• Fall 1999

2
Overview

• ODBC and JDBC
• Why was there a need?
• Introduction
• Architecture
• Examples in use
• Pros and Cons

3
Why the need for ODBC/JDBC?

• DataBase Management Systems (DBMS)
• Access to multiple DBMSs
• Client/Server computing

4
ODBC/JDBC
ODBC/JDBC
SQL
User
Client Machine
5
Introduction to ODBC

• Open DataBase Connectivity (ODBC)
• Microsoft created in 1992
• Different programming languages use ODBC to
  access different DBMSs.

6
ODBC Architecture
Generic
Vertical
Client Application
Custom
ODBC Driver Manager
SQL Server ODBC Driver
Oracle ODBC Driver
DB2 ODBC Driver
Informix ODBC Driver
SQL Server Data Source
Oracle Data Source
DB2 Data Source
Informix Data Source
7
ODBC Example
Insurance company
DB2
ODBC
Oracle
ODBC
ODBC
Financial company
8
Introduction to JDBC

• Java DataBase Connectivity (JDBC)
• Sun Microsoft created in 1996
• JDBC is similar to ODBC
• Java uses JDBC to connect to different DBMSs.

9
JDBC Architecture
Client Application with JDBC API
JDBC Driver Manager
JDBC to ODBC Driver
Driver to Sybase
Driver to DB2
Driver to Oracle
MS SQL Server
Sybase SQL Server
DB2 Data Source
Oracle Database
10
JDBC Driver Quartet
Client Application
JDBC Driver Manager
JDBC Drivers
Type 1
Type 2
Type 3
Type 4
ODBC Driver
Native Database API
Net Protocol
Data
Data
Data
Data
11
ODBC Pros and Cons

• Pros
• Highly efficient performance
• No excessive memory
• Understands many different programming languages
• Drivers available for 55 DBMSs
• Most widely used
• The standard
• Cons
• Difficult to learn and code
• Few comands, but complex options

12
JDBC Pros and Cons

• Pros
• Methods are simple and intuitive
• Codes is easy to learn and program
• Automatically installable
• Portable
• Cons
• Only for Java

13
Sumarry

• ODBC and JDBC allow the client machine to connect
  to any DBMS on any platform.
• Developers are not restricted.
• Users and businesses have more control and
  choices of DBMSs.

14
References

• The Microsoft Corporation, lthttp//www.microsoft.c
  om/data/odbcgt
• Microsoft ODBC 3.0 Software Development Kit and
  Programmers Reference. Microsoft Press 1997
• B. Whiting, B. Morgan, and J. Perkins, ODBC
  Programming. Sams Publishing
• Sun Microsystem Corporation, lthttp//www.javasoft.
  com/products/jdbc/index.html/gt
• C. Horstmann, and G. Cornell, Core Java - Volume
  II Advanced Features. Sun Microsystems Press 1998
• K Siyan, and J. Weaver, Inside Java. New Riders
  Publishing 1997