All Packages  Class Hierarchy  This Package  Previous  Next  Index

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

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

Methods

 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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.
 o 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
 o 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
 o 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
 o 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
 o 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
 o println
 public static void println(String message)
Print a message to the current JDBC log stream

Parameters:
message - a log or tracing message

All Packages  Class Hierarchy  This Package  Previous  Next  Index