Difference between JDBC Driver type numbers

java sql database jdbc drivers
gmhk picture gmhk · Mar 4, 2010 · Viewed 9k times · Source

I noticed that JDBC has different Drivers like:

  1. Type 1 Driver
  2. Type 2 Driver etc.. to Type 4

Why did they get the name like Type 1, Type 2 etc.? Is there any logic?

Answer

BalusC picture BalusC · Mar 4, 2010

The type number tells something about how the driver actually communicates with the database.

  1. Via ODBC API.
  2. Via DB vendor specific API (using JNI calls on e.g. a DLL file in Windows).
  3. Via generic network protocol (using sockets with e.g. TCP/IP protocol).
  4. 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.

Related questions

Can I have H2 autocreate a schema in an in-memory database?

(I've already seen the H2 database In memory - Init schema via Spring/Hibernate question; it is not applicable here.) I'd like to know if there's a setting in H2 that will allow me to auto-create a schema upon connecting …

Read More
Java sql delete row

Hello I am trying to delete a row from my database. I am getting no errors but it is doing nothing, any help or advice would be great! public static void DeleteRow(String name) { try { Class.forName("com.mysql.jdbc.…

Read More
How to use a contract class in android?

I'm a little bit confused because I don't know how I should interpret the tutorial here: http://developer.android.com/training/basics/data-storage/databases.html#DbHelper My code until now looks like this: public final class DatabaseContract { // To prevent someone …

Read More