What is the purpose of ‘Class.forName(“MY_JDBC_DRIVER”)’?

by

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.

More Related Contents:

  1. PreparedStatement with list of parameters in a IN clause [duplicate]
  2. Using setDate in PreparedStatement
  3. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  4. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  5. ResultSet exception – before start of result set
  6. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  7. Handling MySQL datetimes and timestamps in Java
  8. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  9. java.sql.SQLException: Column count doesn’t match value count at row 1
  10. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  11. JDBC ResultSet get columns with table alias
  12. How to start a transaction in JDBC?
  13. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  14. Driver JDBC PostgreSQL with Android [duplicate]
  15. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  16. oracle.jdbc.driver.OracleDriver ClassNotFoundException
  17. Call an Oracle function from Java
  18. Populating jTable using database data
  19. How to simulate a DB for testing (Java)?
  20. is there a standard way to define a JDBC Datasource for Java EE containers?
  21. I’m getting a java.lang.classnotfoundexception: com.mysql.jdbc.Driver
  22. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  23. How to get *everything* back from a stored procedure using JDBC
  24. Using a prepared statement and variable bind Order By in Java with JDBC driver
  25. How do I unit test jdbc code in java? [closed]
  26. Java 7 Automatic Resource Management JDBC (try-with-resources statement)
  27. How to map a ResultSet with unknown amount of columns to a List and display it in a HTML table?
  28. UCanAccess Initializer Error (compile/run without IDE)
  29. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  30. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?

Leave a Comment