java.sql

Class DriverManager

public class DriverManager extends Object

This class manages the JDBC drivers in the system. It maintains a registry of drivers and locates the appropriate driver to handle a JDBC database URL.

On startup, DriverManager loads all the managers specified by the system property jdbc.drivers. The value of this property should be a colon separated list of fully qualified driver class names. Additional drivers can be loaded at any time by simply loading the driver class with class.forName(String). The driver should automatically register itself in a static initializer.

The methods in this class are all static. This class cannot be instantiated.

Method Summary
static voidderegisterDriver(Driver driver)
This method de-registers a driver from the manager.
static ConnectiongetConnection(String url, Properties properties)
This method attempts to return a connection to the specified JDBC URL string using the specified connection properties.
static ConnectiongetConnection(String url, String user, String password)
This method attempts to return a connection to the specified JDBC URL string using the specified username and password.
static ConnectiongetConnection(String url)
This method attempts to return a connection to the specified JDBC URL string.
static DrivergetDriver(String url)
This method returns a driver that can connect to the specified JDBC URL string.
static Enumeration<Driver>getDrivers()
This method returns a list of all the currently registered JDBC drivers that were loaded by the current ClassLoader.
static intgetLoginTimeout()
This method returns the login timeout in use by JDBC drivers systemwide.
static PrintStreamgetLogStream()
This method returns the log stream in use by JDBC.
static PrintWritergetLogWriter()
This method returns the log writer being used by all JDBC drivers.
static voidprintln(String message)
This method prints the specified line to the log stream.
static voidregisterDriver(Driver driver)
This method registers a new driver with the manager.
static voidsetLoginTimeout(int seconds)
This method set the login timeout used by JDBC drivers.
static voidsetLogStream(PrintStream stream)
This method sets the log stream in use by JDBC.
static voidsetLogWriter(PrintWriter out)
This method sets the log writer being used by JDBC drivers.

Method Detail

deregisterDriver

public static void deregisterDriver(Driver driver)
This method de-registers a driver from the manager.

Parameters: driver The Driver to unregister.

Throws: SQLException If an error occurs.

getConnection

public static Connection getConnection(String url, Properties properties)
This method attempts to return a connection to the specified JDBC URL string using the specified connection properties.

Parameters: url The JDBC URL string to connect to. properties The connection properties.

Returns: A Connection to that URL.

Throws: SQLException If an error occurs.

getConnection

public static Connection getConnection(String url, String user, String password)
This method attempts to return a connection to the specified JDBC URL string using the specified username and password.

Parameters: url The JDBC URL string to connect to. user The username to connect with. password The password to connect with.

Returns: A Connection to that URL.

Throws: SQLException If an error occurs.

getConnection

public static Connection getConnection(String url)
This method attempts to return a connection to the specified JDBC URL string.

Parameters: url The JDBC URL string to connect to.

Returns: A Connection to that URL.

Throws: SQLException If an error occurs.

getDriver

public static Driver getDriver(String url)
This method returns a driver that can connect to the specified JDBC URL string. This will be selected from among drivers loaded at initialization time and those drivers manually loaded by the same class loader as the caller.

Parameters: url The JDBC URL string to find a driver for.

Returns: A Driver that can connect to the specified URL.

Throws: SQLException If an error occurs, or no suitable driver can be found.

getDrivers

public static Enumeration<Driver> getDrivers()
This method returns a list of all the currently registered JDBC drivers that were loaded by the current ClassLoader.

Returns: An Enumeration of all currently loaded JDBC drivers.

getLoginTimeout

public static int getLoginTimeout()
This method returns the login timeout in use by JDBC drivers systemwide.

Returns: The login timeout.

getLogStream

public static PrintStream getLogStream()

Deprecated: Use getLogWriter() instead.

This method returns the log stream in use by JDBC.

Returns: The log stream in use by JDBC.

getLogWriter

public static PrintWriter getLogWriter()
This method returns the log writer being used by all JDBC drivers. This method should be used in place of the deprecated getLogStream method.

Returns: The log writer in use by JDBC drivers.

println

public static void println(String message)
This method prints the specified line to the log stream.

Parameters: message The string to write to the log stream.

registerDriver

public static void registerDriver(Driver driver)
This method registers a new driver with the manager. This is normally called by the driver itself in a static initializer.

Parameters: driver The new Driver to add.

Throws: SQLException If an error occurs.

setLoginTimeout

public static void setLoginTimeout(int seconds)
This method set the login timeout used by JDBC drivers. This is a system-wide parameter that applies to all drivers.

Parameters: seconds The new login timeout value.

setLogStream

public static void setLogStream(PrintStream stream)

Deprecated: Use setLogWriter instead.

This method sets the log stream in use by JDBC.

Parameters: stream The log stream in use by JDBC.

setLogWriter

public static void setLogWriter(PrintWriter out)
This method sets the log writer being used by JDBC drivers. This is a system-wide parameter that affects all drivers. Note that since there is no way to retrieve a PrintStream from a PrintWriter, this method cannot set the log stream in use by JDBC. Thus any older drivers may not see this setting.

Parameters: out The new log writer for JDBC.