Kanagavelu Sugumar Kanagavelu Sugumar - 2 years ago 70
Java Question

What is the purpose of 'Class.forName("MY_JDBC_DRIVER")'?

I understand that class loading is useful for load the class at runtime with its class name.

However while using JDBC in our project we know which driver we are going to use and mostly driver manager string is hard coded.

My question is: Why are we loading driver using


Why can't we go ahead adding the driver in class path? since we know which driver jar we are going to use.

I believe
will load the Driver into
. Is it the only reason?

Edit 1:

API doc
states that

As part of its(DriverManager) initialization, the DriverManager class will attempt to load the driver classes referenced in the "jdbc.drivers" system property.

Applications no longer need to explictly load JDBC drivers using
. Existing programs which currently load JDBC drivers using
will continue to work without modification.

Then when I use other than oracle driver; do I need to change the driver name string in system property?

Answer Source

First of: with modern JDBC drivers and a current JDK (at least Java 6) the call to Class.forName() is no longer necessary. JDBC driver classes are now located using the service provider mechanism. You should be able to simply remove that call and leave the rest of the code unchanged and it should continue to work.

If you're not using a current JDK (or if you have a JDBC driver that does not have the appropriate files set up to use that mechanism) then the driver needs to be registered with the DriverManager using registerDriver. That method is usually called from the static initializer block of the actual driver class, which gets triggered when the class is first loaded, so issuing the Class.forName() ensures that the driver registers itself (if it wasn't already done).

And no matter if you use Class.forName() or the new service provider mechanism, you will always need the JDBC driver on the classpath (or available via some ClassLoader at runtime, at least).

tl;dr: yes, the only use of that Class.forName() call is to ensure the driver is registered. If you use a current JDK and current JDBC drivers, then this call should no longer be necesary.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download