Where Am I? Class Hierarchy (JDK) All Classes (JDK) All Fields and Methods (JDK)

Class java.sql.DriverManager

java.lang.Object
   |
   +----java.sql.DriverManager

public class DriverManager
extends Object

The DriverManager provides a basic service for managing a set of JDBC drivers.

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 A program can also explicitly load JDBC drivers at any time. For example, the my.sql.Driver is loaded with the following statement: Class.forName("my.sql.Driver");

When 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.

See Also:
Driver, Connection

Method Index

deregisterDriver(Driver)
Drop a Driver from the DriverManager's list.
getConnection(String)
Attempt to establish a connection to the given database URL.
getConnection(String, Properties)
Attempt to establish a connection to the given database URL.
getConnection(String, String, String)
Attempt to establish a connection to the given database URL.
getDriver(String)
Attempt to locate a driver that understands the given URL.
getDrivers()
Return an Enumeration of all the currently loaded JDBC drivers which the current caller has access to.
getLoginTimeout()
Get the maximum time in seconds that all drivers can wait when attempting to log in to a database.
getLogStream()
Get the logging/tracing PrintStream that is used by the DriverManager and all drivers.
println(String)
Print a message to the current JDBC log stream
registerDriver(Driver)
A newly loaded driver class should call registerDriver to make itself known to the DriverManager.
setLoginTimeout(int)
Set the maximum time in seconds that all drivers can wait when attempting to log in to a database.
setLogStream(PrintStream)
Set the logging/tracing PrintStream that is used by the DriverManager and all drivers.

Methods

getConnection
 public static synchronized Connection getConnection(String url,
                                                     Properties info) throws SQLException
Attempt 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: SQLException
if a database-access error occurs.
getConnection
 public static synchronized Connection getConnection(String url,
                                                     String user,
                                                     String password) throws SQLException
Attempt 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.
getConnection
 public static synchronized Connection getConnection(String url) throws SQLException
Attempt 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.
getDriver
 public static Driver getDriver(String url) throws SQLException
Attempt to locate a driver that understands the given 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 Driver that can connect to the URL
Throws: SQLException
if a database-access error occurs.
registerDriver
 public static synchronized void registerDriver(Driver driver) throws SQLException
A newly loaded driver class should call registerDriver to make itself known to the DriverManager.

Parameters:
driver - the new JDBC Driver
Throws: SQLException
if a database-access error occurs.
deregisterDriver
 public static void deregisterDriver(Driver driver) throws SQLException
Drop a Driver from the DriverManager's list. Applets can only deregister Drivers from their own classloader.

Parameters:
driver - the JDBC Driver to drop
Throws: SQLException
if a database-access error occurs.
getDrivers
 public static Enumeration getDrivers()
Return an Enumeration of all the currently loaded JDBC drivers which the current caller has access to.

Note: The classname of a driver can be found using d.getClass().getName()

Returns:
the list of JDBC Drivers loaded by the caller's class loader
setLoginTimeout
 public static void setLoginTimeout(int seconds)
Set the maximum time in seconds that all drivers can wait when attempting to log in to a database.

Parameters:
seconds - the driver login time limit
getLoginTimeout
 public static int getLoginTimeout()
Get the maximum time in seconds that all drivers can wait when attempting to log in to a database.

Returns:
the driver login time limit
setLogStream
 public static void setLogStream(PrintStream out)
Set the logging/tracing PrintStream that is used by the DriverManager and all drivers.

Parameters:
out - the new logging/tracing PrintStream; to disable, set to null
getLogStream
 public static PrintStream getLogStream()
Get the logging/tracing PrintStream that is used by the DriverManager and all drivers.

Returns:
the logging/tracing PrintStream; if disabled, is null
println
 public static void println(String message)
Print a message to the current JDBC log stream

Parameters:
message - a log or tracing message

Where Am I? Class Hierarchy (JDK) All Classes (JDK) All Fields and Methods (JDK)