How To Use Database Driver

In this tutorial you will learn how to use a MySql database driver.

 
 

Share on Google+Share on Google+

How To Use Database Driver

Ads

In this tutorial you will learn how to use a MySql database driver.

How To Use Database Driver

Database driver is a component (Software component) that enables the user application to interact with database. In JDBC there are four types Database driver

Type 1: JDBC-ODBC Bridge driver
Type 2: Native-API/partly Java driver
Type 3: AllJava/Net-protocol driver
Type 4: All Java/Native-protocol driver

Each database driver have there advantages and disadvantage. Type 4 driver is widely used today.

Driver Manager keeps track of all the database drivers available today and connection between database and driver. It maintains a list of driver classes that has registered them self by calling a method DriverManager.registerDriver.

Every database application have their own database driver. In order to connect to an application to database using type 4 driver you must need to load a database driver of that particular database. Loading a driver means loading appropriate class that makes driver instance and register it with JDBC driver manager. If the the class/driver you are loading not found then it throws a ClassNotFoundException. To load a database driver Class.forName("DriverName") method is used. This method takes string as argument which is fully qualified class name and loaded that class.

Example-

try {
    Class.forName("com.mysql.jdbc.Driver"); //MySql Driver
    //Class.forName("oracle.jdbc.driver.OracleDriver"); Oracle driver
    //Class.forName("com.sybase.jdbc.SybDriver"); Sybase driver
    } catch(ClassNotFoundException e) {
    System.err.println(e.toString());
}

Advertisements

Ads

Posted on: October 20, 2010 If you enjoyed this post then why not add us on Google+? Add us to your Circles