All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class java.sql.DriverManager

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

deregisterDriver(Driver)

Drop a Driver from the DriverManager's list.

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.

getConnection(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.

getLogStream()

Get the logging/tracing PrintStream that is used by the DriverManager and all drivers.

getLoginTimeout()

Get the maximum time in seconds that all drivers can wait when attempting to log in to a database.

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.

setLogStream(PrintStream)

Set the logging/tracing PrintStream that is used by the DriverManager and all drivers.

setLoginTimeout(int)

Set the maximum time in seconds that all drivers can wait when attempting to log in to a database.

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.

public static synchronized java.sql.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.

public static synchronized java.sql.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.

public static synchronized java.sql.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.

public static java.sql.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.

public static java.util.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

public static java.io.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

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

public static void println(String message)

Print a message to the current JDBC log stream

Parameters:

message - a log or tracing message

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.

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

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

All Packages  Class Hierarchy  This Package  Previous  Next  Index