JDBC Class.forName vs DriverManager.registerDriver

by

Class.forName() is not directly related to JDBC at all. It simply loads a class.

Most JDBC Driver classes register themselves in their static initializers by calling registerDriver().

registerDriver() is the real call that you hardly ever need to call yourself (unless you write your own JDBC driver).

Note that in JDBC 4 you should not need either of those if your JDBC driver is up-to-date, as drivers can be found using the service location mechanisms instead (i.e. simply leave out that call and open your connection as usual). See the documentaton of DriverManager for details:

The DriverManager methods getConnection and getDrivers have been enhanced to support the Java Standard Edition Service Provider mechanism. JDBC 4.0 Drivers must include the file META-INF/services/java.sql.Driver. This file contains the name of the JDBC drivers implementation of java.sql.Driver. For example, to load the my.sql.Driver class, the META-INF/services/java.sql.Driver file would contain the entry:

my.sql.Driver

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

More Related Contents:

  1. How to get the insert ID in JDBC?
  2. To prevent a memory leak, the JDBC Driver has been forcibly unregistered
  3. Is java.sql.Timestamp timezone specific?
  4. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  5. Java ResultSet how to check if there are any results
  6. Retrieve column names from java.sql.ResultSet
  7. JDBC connection failed, error: TCP/IP connection to host failed
  8. How can I get the SQL of a PreparedStatement?
  9. Can we connect remote MySQL database in Android using JDBC? [closed]
  10. Is java.sql.Connection thread safe?
  11. JDBC MySql connection pooling practices to avoid exhausted connection pool
  12. right syntax to use near ‘?’
  13. Running a .sql script using MySQL with JDBC
  14. JDBC connection to MSSQL server in windows authentication mode
  15. Oracle JDBC intermittent Connection Issue
  16. How to execute .sql script file using JDBC [duplicate]
  17. JDBC driver throws “ResultSet Closed” exception on empty ResultSet
  18. Hibernate batch size confusion
  19. Passing parameters to a JDBC PreparedStatement
  20. JDBC character encoding
  21. Do you need a database transaction for reading data?
  22. Where to close java PreparedStatements and ResultSets?
  23. Lightweight JDBC helper library alternative to Apache Commons DbUtils [closed]
  24. Java JDBC – How to connect to Oracle using tnsnames.ora
  25. Is it a good idea to put jdbc connection code in servlet class?
  26. Java – Storing SQL statements in an external file [closed]
  27. Connection timeout for DriverManager getConnection
  28. How do I make a Java ResultSet available in my jsp? [duplicate]
  29. How to connect to a remote MySQL database with Java?
  30. How to get jdbc connection from hibernate session? [duplicate]

Leave a Comment