Types of JDBC Drivers
1. Four Types (beginner map — exam MUST!)
Bridge (old!) → Native (part Java!) → Middleware (pure!) → Pure Java/Direct (best!). Number = layers to DB!
2. Table + Diagram (memorize!)
Type 1: Java → JDBC-ODBC Bridge → ODBC → DB (many layers!)
Type 2: Java → Native API (C!) → DB (part Java!)
Type 3: Java → Middleware Server → DB (pure Java client!)
Type 4: Java → DB directly! (pure Java, best!)
| Type | Name | Java? | Speed | Use today? |
|---|---|---|---|---|
| 1 | JDBC-ODBC Bridge | part (ODBC!) | slowest | NO (removed Java 8!) |
| 2 | Native-API | part (C lib!) | medium | rare (needs install!) |
| 3 | Network/Middleware | pure! | medium | cloud/proxy! |
| 4 | Thin/Direct | pure! | fastest | YES (MySQL Connector/J!) |
3. Code Proof (only URL changes!)
// Type 4 MySQL (pure — just jar!):
Connection c = DriverManager.getConnection("jdbc:mysql://localhost:3306/college", "u", "p");
// Type 1 old (bridge — dead!):
// Connection c = DriverManager.getConnection("jdbc:odbc:mydsn", "u", "p");
4. Exam One-Liners
- Best/portable? Type 4 (pure, direct, no install!).
- Removed? Type 1 (Java 8+ gone!).
- Needs C lib? Type 2. Needs middleware? Type 3.
5. Exam Points
- Four-type table + diagram — 7 marks, very frequent.
- Best + removed + needs-install rows — 5 marks, favourite.