DriverManager

public class DriverManager extends Object

The basic service for managing a set of JDBC drivers.
NOTE: The DataSource interface, new in the JDBC 2.0 API, provides another way to connect to a data source. The use of a DataSource object is the preferred means of connecting to a data source.

As part of its initialization, the DriverManager class will attempt to load the driver classes referenced in the "jdbc.drivers" system property. This allows a user to customize the JDBC Drivers used by their applications. For example in your ~/.hotjava/properties file you might specify:

 jdbc.drivers=foo.bah.Driver:wombat.sql.Driver:bad.taste.ourDriver
 

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.

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.

Starting with the Java 2 SDK, Standard Edition, version 1.3, a logging stream can be set only if the proper permission has been granted. Normally this will be done with the tool PolicyTool, which can be used to grant permission java.sql.SQLPermission "setLog".

See Also

Public Method Summary

synchronized static void
deregisterDriver(Driver driver)
Drops a driver from the DriverManager's list.
static Connection
getConnection(String url)
Attempts to establish a connection to the given database URL.
static Connection
getConnection(String url, String user, String password)
Attempts to establish a connection to the given database URL.
static Connection
getConnection(String url, Properties info)
Attempts to establish a connection to the given database URL.
static Driver
getDriver(String url)
Attempts to locate a driver that understands the given URL.
static Enumeration<Driver>
getDrivers()
Retrieves an Enumeration with all of the currently loaded JDBC drivers to which the current caller has access.
static PrintStream
getLogStream()
This method was deprecated. Use getLogWriter instead.
static PrintWriter
getLogWriter()
Retrieves the log writer.
static int
getLoginTimeout()
Gets the maximum time in seconds that a driver can wait when attempting to log in to a database.
static void
println(String message)
Prints a message to the current JDBC log stream.
synchronized static void
registerDriver(Driver driver)
Registers the given driver with the DriverManager.
static void
setLogStream(PrintStream out)
This method was deprecated. Use setLogWriter instead.
static void
setLogWriter(PrintWriter out)
Sets the logging/tracing PrintWriter object that is used by the DriverManager and all drivers.
static void
setLoginTimeout(int seconds)
Sets the maximum time in seconds that a driver will wait while attempting to connect to a database.

Inherited Method Summary

Public Methods

public static synchronized void deregisterDriver (Driver driver)

Drops a driver from the DriverManager's list. Applets can only deregister drivers from their own classloaders.

Parameters
driver the JDBC Driver to drop
Throws
SQLException if a database access error occurs

public static Connection getConnection (String url)

Attempts to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers.

Parameters
url a database url of the form jdbc:subprotocol:subname
Returns
  • a connection to the URL
Throws
SQLException if a database access error occurs

public static Connection getConnection (String url, String user, String password)

Attempts to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers.

Parameters
url a database url of the form jdbc:subprotocol:subname
user the database user on whose behalf the connection is being made
password the user's password
Returns
  • a connection to the URL
Throws
SQLException if a database access error occurs

public static Connection getConnection (String url, Properties info)

Attempts to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers.

Parameters
url a database url of the form jdbc:subprotocol:subname
info a list of arbitrary string tag/value pairs as connection arguments; normally at least a "user" and "password" property should be included
Returns
  • a Connection to the URL
Throws