Thread: JDBC Drivers

I have learned that there are four types of Driver which are JDBC ODBC Bridge , JDBC Native Api , JDBC-Net Pure Java and 100% pure Java.When I searched for there implementation I came across only one way of registering the driver i.e. using Class.forName().Is this the way to register all four type of Driver.

Yes. We can register the drivers using Class.forName()
There is one more way, which is long and creates tight coupling.
1. Create an object of driver given by DB vendor and register that object with java.sql.DriverManager which is a class and a part of JDBC API.
e.g
Driver driver= new Driver();
DriverManager.registerDriver(driver);
Here, Driver is a class in com.mysql.jdbc.Driver

2. Any driver class given by DB vendor must inherit java.sql.Driver interface (for obvious reasons).

3. The DB vendor in the Driver class must write a static block and inside the static block the driver object should be created and registered with driver manager.
e.g
com.mysql.jdbc.Driver implements java.sql.Driver
{
{
DriverManager.registerDriver(new Driver());
}
}

Welcome to the forum! Please read this topic to learn how to post code in code or highlight tags and other useful info for new members.

Please post your code correctly using code or highlight tags per the above link.

Thread moved.