On class.forname() in JDBC

[par dhar]

Hi All,

I have below questions on class.forname() statement in JDBC connecion

1. If we write the code like class.forname("com.a.b.c");class.forname("com.p.q.r");...
then will JVM load all classes or it will load only first one (or last one) and will ignore all others?

2. Also after using class.forname(("com.a.b.c"); we get connection as DriverManager.getConnection("jdbc:mysql:///test",user,pass) so then how exactly database url finds its corrosponding class which has been loaded using class.forname(). (if it uses reflextion, then can anybody pls tell me how it exactly works).

Regards

[Ulf Dittmer]

#1) The JVM will load all classes. Why would it ignore code statements?

#2) During class initialization (which happens when Class.forName is called), the driver register itself with JDBC, specifically stating for which JDBC URLs it can be used. From the javadocs of DriverManager:

When the method getConnection is called, the DriverManager will attempt to locate a suitable driver from amongst those loaded at initialization and those loaded explicitly using the same classloader as the current applet or application.