{"id":699,"date":"2005-07-31T21:56:54","date_gmt":"2005-08-01T01:56:54","guid":{"rendered":"http:\/\/wordpress.cephas.net\/?p=699"},"modified":"2005-07-31T21:56:54","modified_gmt":"2005-08-01T01:56:54","slug":"java-classfornamestring-classname-and-jdbc","status":"publish","type":"post","link":"https:\/\/cephas.net\/blog\/2005\/07\/31\/java-classfornamestring-classname-and-jdbc\/","title":{"rendered":"Java Class.forName(String className) and JDBC"},"content":{"rendered":"

A reader asked a question via a comment a couple months ago that I didn’t really have an answer for (and had always kind of wondered the same thing). In the original post<\/a> (which showed how to use JDBC with ColdFusion), I used the following snippet of code:
\n
\nClass.forName(\"jdbc.DriverXYZ\");
\nConnection con = DriverManager.getConnection(url,
\n  \"myLogin\", \"myPassword\");
\n<\/code>
\nand the reader wanted to know what the Class.forName(..)<\/code> method did. The most common answer you’ll hear is that it loads the database driver, which, while technically true, is shallow. Where does it get loaded? How does it happen? And why?<\/p>\n

To answer the question I started with the JavaDoc for the Class.forName() method<\/a>. According to the documentation, the method:<\/p>\n

… attempts to locate, load, and link the class or interface<\/p><\/blockquote>\n

I wasn’t perfectly clear on what “locate, load, and link” meant, so I did a little digging through the Java Language Specification<\/a>. According to chapter 12 of the JLS<\/a>: <\/p>\n

Loading refers to the process of finding the binary form of a class or interface type with a particular name, perhaps by computing it on the fly, but more typically by retrieving a binary representation previously computed from source code by a compiler, and constructing, from that binary form, a Class object to represent the class or interface.<\/p><\/blockquote>\n

Next, again according to the JLS, it must be transformed from it’s binary representation to something the Java virtual machine can use, this process is called linking. Finally, the class is initialized, which is the process that executes the static initializer and the initializers for static fields declared in the class. <\/p>\n

So then back to the original problem, when Class.forName() is called with an argument like this:
\n
\nClass.forName(\"org.gjt.mm.mysql.Driver\");
\n<\/code>
\nthe classloader attempts to load and link the Driver<\/code> class in the “org.gjt.mm.mysql” package and if successful, the static initializer is run. The MySQL Driver<\/code> (download the source code<\/a>) static initializer looks like this:
\n
\nstatic {
\n  try {
\n    java.sql.DriverManager.registerDriver(new Driver());
\n  } catch (SQLException E) {
\n    throw new RuntimeException(\"Can't register driver!\");
\n  }
\n}
\n<\/code>
\nSo it calls a static method in the java.sql.DriverManager<\/a> class which apparently registers a copy of itself when it loads.<\/p>\n

So now I understand the where and the how, what about why? To understand the why you have to look at the next line in the initial code example:
\n
\nConnection con = DriverManager.getConnection(url,
\n  \"myLogin\", \"myPassword\");
\n<\/code>
\nThe DriverManager<\/code> class (view DriverManager source here<\/a>) returns a database connection given a JDBC URL string, a username and a password. In order to create that connection, the DriverManager class has to know which database driver you want to use. It does that by iterating over the array (internally a Vector) of drivers that have registered with it (ie: the registerDriver(Driver driver)<\/code> method illustrated above) and calls the acceptsURL(url))<\/code> method on each driver in the array, effectively asking the driver to tell it whether or not it can handle the JDBC URL. <\/p>\n

So there you have it. Class.forName explained.<\/p>\n","protected":false},"excerpt":{"rendered":"

A reader asked a question via a comment a couple months ago that I didn’t really have an answer for (and had always kind of wondered the same thing). In the original post (which showed how to use JDBC with ColdFusion), I used the following snippet of code: Class.forName(“jdbc.DriverXYZ”); Connection con = DriverManager.getConnection(url,   “myLogin”, “myPassword”); … Continue reading Java Class.forName(String className) and JDBC<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,3,2],"tags":[],"_links":{"self":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/posts\/699"}],"collection":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/comments?post=699"}],"version-history":[{"count":0,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/posts\/699\/revisions"}],"wp:attachment":[{"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/media?parent=699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/categories?post=699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cephas.net\/blog\/wp-json\/wp\/v2\/tags?post=699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}