Difference between JDBC Driver type numbers
database, drivers, java, jdbc, sql
Solution
The type number tells something about how the driver actually communicates with the database.
- Via ODBC API.
- Via DB vendor specific API (using JNI calls on e.g. a DLL file in Windows).
- Via generic network protocol (using sockets with e.g. TCP/IP protocol).
- Via DB vendor specific network protocol (still with sockets).
In general (just by coincidence), how higher the type number, how better the JDBC driver performs.
Problem
I noticed that JDBC has different Drivers like: - Type 1 Driver - Type 2 Driver etc.. to Type 4 Why did they get the name like Type 1, Type 2 etc.? Is there any logic?