# DriverManager

public class **DriverManager** extends [Object](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html)  
<br />

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](https://developers.google.com/j2objc/javadoc/jre/technotes/guides/jar/jar.html#Service%20Provider) 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

- `https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Driver.html`
- `https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Connection.html`

### Public Method Summary

|---|---|
| synchronized static void | [deregisterDriver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#deregisterDriver(java.sql.Driver))([Driver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Driver.html) driver) Drops a driver from the `DriverManager`'s list. |
| static [Connection](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Connection.html) | [getConnection](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getConnection(java.lang.String))([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) url) Attempts to establish a connection to the given database URL. |
| static [Connection](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Connection.html) | [getConnection](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getConnection(java.lang.String,%20java.lang.String,%20java.lang.String))([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) url, [String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) user, [String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) password) Attempts to establish a connection to the given database URL. |
| static [Connection](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Connection.html) | [getConnection](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getConnection(java.lang.String,%20java.util.Properties))([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) url, [Properties](https://developers.google.com/j2objc/javadoc/jre/reference/java/util/Properties.html) info) Attempts to establish a connection to the given database URL. |
| static [Driver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Driver.html) | [getDriver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getDriver(java.lang.String))([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) url) Attempts to locate a driver that understands the given URL. |
| static [Enumeration](https://developers.google.com/j2objc/javadoc/jre/reference/java/util/Enumeration.html)\<[Driver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Driver.html)\> | [getDrivers](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getDrivers())() Retrieves an Enumeration with all of the currently loaded JDBC drivers to which the current caller has access. |
| static [PrintStream](https://developers.google.com/j2objc/javadoc/jre/reference/java/io/PrintStream.html) | [getLogStream](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getLogStream())() *This method is deprecated. Use `getLogWriter` instead.* |
| static [PrintWriter](https://developers.google.com/j2objc/javadoc/jre/reference/java/io/PrintWriter.html) | [getLogWriter](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getLogWriter())() Retrieves the log writer. |
| static int | [getLoginTimeout](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getLoginTimeout())() Gets the maximum time in seconds that a driver can wait when attempting to log in to a database. |
| static void | [println](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#println(java.lang.String))([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) message) Prints a message to the current JDBC log stream. |
| synchronized static void | [registerDriver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#registerDriver(java.sql.Driver))([Driver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Driver.html) driver) Registers the given driver with the `DriverManager`. |
| static void | [setLogStream](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#setLogStream(java.io.PrintStream))([PrintStream](https://developers.google.com/j2objc/javadoc/jre/reference/java/io/PrintStream.html) out) *This method is deprecated. Use `setLogWriter` instead.* |
| static void | [setLogWriter](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#setLogWriter(java.io.PrintWriter))([PrintWriter](https://developers.google.com/j2objc/javadoc/jre/reference/java/io/PrintWriter.html) out) Sets the logging/tracing `PrintWriter` object that is used by the `DriverManager` and all drivers. |
| static void | [setLoginTimeout](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#setLoginTimeout(int))(int seconds) Sets the maximum time in seconds that a driver will wait while attempting to connect to a database. |

### Inherited Method Summary

From class [java.lang.Object](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html)

|---|---|
| [Object](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html) | [clone](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#clone())() Creates and returns a copy of this `Object`. |
| boolean | [equals](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#equals(java.lang.Object))([Object](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html) obj) Compares this instance with the specified object and indicates if they are equal. |
| void | [finalize](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#finalize())() Invoked when the garbage collector has detected that this instance is no longer reachable. |
| final [Class](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Class.html)\<?\> | [getClass](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#getClass())() Returns the unique instance of `https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Class.html` that represents this object's class. |
| int | [hashCode](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#hashCode())() Returns an integer hash code for this object. |
| final void | [notify](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#notify())() Causes a thread which is waiting on this object's monitor (by means of calling one of the `wait()` methods) to be woken up. |
| final void | [notifyAll](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#notifyAll())() Causes all threads which are waiting on this object's monitor (by means of calling one of the `wait()` methods) to be woken up. |
| [String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) | [toString](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#toString())() Returns a string containing a concise, human-readable description of this object. |
| final void | [wait](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#wait(long,%20int))(long timeout, int nanos) Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method of this object or until the specified timeout expires. |
| final void | [wait](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#wait(long))(long timeout) Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method of this object or until the specified timeout expires. |
| final void | [wait](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/Object.html#wait())() Causes the calling thread to wait until another thread calls the `notify()` or `notifyAll()` method of this object. |

## Public Methods

#### public static synchronized void
**deregisterDriver**
([Driver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Driver.html) 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](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/SQLException.html) | if a database access error occurs |
|---|---|

#### public static [Connection](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Connection.html)
**getConnection**
([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) 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](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/SQLException.html) | if a database access error occurs |
|---|---|

#### public static [Connection](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Connection.html)
**getConnection**
([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) url, [String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) user, [String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) 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](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/SQLException.html) | if a database access error occurs |
|---|---|

#### public static [Connection](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Connection.html)
**getConnection**
([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) url, [Properties](https://developers.google.com/j2objc/javadoc/jre/reference/java/util/Properties.html) 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

| [SQLException](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/SQLException.html) | if a database access error occurs |
|---|---|

#### public static [Driver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Driver.html)
**getDriver**
([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) url)

Attempts 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` object representing a driver that can connect to the given URL

##### Throws

| [SQLException](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/SQLException.html) | if a database access error occurs |
|---|---|

#### public static [Enumeration](https://developers.google.com/j2objc/javadoc/jre/reference/java/util/Enumeration.html)\<[Driver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Driver.html)\>
**getDrivers**
()

Retrieves an Enumeration with all of the currently loaded JDBC drivers
to which the current caller has access.

**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 [PrintStream](https://developers.google.com/j2objc/javadoc/jre/reference/java/io/PrintStream.html)
**getLogStream**
()


**This method is deprecated.**   
Use `getLogWriter` instead.
Retrieves the logging/tracing PrintStream that is used by the `DriverManager`
and all drivers.

##### Returns

- the logging/tracing PrintStream; if disabled, is `null`

##### See Also

- `https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#setLogStream(java.io.PrintStream)`

#### public static [PrintWriter](https://developers.google.com/j2objc/javadoc/jre/reference/java/io/PrintWriter.html)
**getLogWriter**
()

Retrieves the log writer.

The `getLogWriter` and `setLogWriter`
methods should be used instead
of the `get/setlogStream` methods, which are deprecated.

##### Returns

- a `java.io.PrintWriter` object

##### See Also

- `https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#setLogWriter(java.io.PrintWriter)`

#### public static int
**getLoginTimeout**
()

Gets the maximum time in seconds that a driver can wait
when attempting to log in to a database.

##### Returns

- the driver login time limit in seconds

##### See Also

- `https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#setLoginTimeout(int)`

#### public static void
**println**
([String](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/String.html) message)

Prints a message to the current JDBC log stream.

##### Parameters

| message | a log or tracing message |
|---|---|

#### public static synchronized void
**registerDriver**
([Driver](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/Driver.html) driver)

Registers the given driver with the `DriverManager`.
A newly-loaded driver class should call
the method `registerDriver` to make itself
known to the `DriverManager`.

##### Parameters

| driver | the new JDBC Driver that is to be registered with the `DriverManager` |
|---|---|

##### Throws

| [SQLException](https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/SQLException.html) | if a database access error occurs |
|---|---|

#### public static void
**setLogStream**
([PrintStream](https://developers.google.com/j2objc/javadoc/jre/reference/java/io/PrintStream.html) out)


**This method is deprecated.**   
Use `setLogWriter` instead.
Sets the logging/tracing PrintStream that is used
by the `DriverManager`
and all drivers.


In the Java 2 SDK, Standard Edition, version 1.3 release, this method checks
to see that there is an `SQLPermission` object before setting
the logging stream. If a `SecurityManager` exists and its
`checkPermission` method denies setting the log writer, this
method throws a `java.lang.SecurityException`.

##### Parameters

| out | the new logging/tracing PrintStream; to disable, set to `null` |
|---|---|

##### Throws

| [SecurityException](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/SecurityException.html) | if a security manager exists and its `checkPermission` method denies setting the log stream |
|---|---|

##### See Also

- `https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/SecurityManager.html#checkPermission(java.security.Permission)`
- `https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getLogStream()`

#### public static void
**setLogWriter**
([PrintWriter](https://developers.google.com/j2objc/javadoc/jre/reference/java/io/PrintWriter.html) out)

Sets the logging/tracing `PrintWriter` object
that is used by the `DriverManager` and all drivers.


There is a minor versioning problem created by the introduction
of the method `setLogWriter`. The
method `setLogWriter` cannot create a `PrintStream` object
that will be returned by `getLogStream`---the Java platform does
not provide a backward conversion. As a result, a new application
that uses `setLogWriter` and also uses a JDBC 1.0 driver that uses
`getLogStream` will likely not see debugging information written
by that driver.


Starting with the Java 2 SDK, Standard Edition, version 1.3 release, this method checks
to see that there is an `SQLPermission` object before setting
the logging stream. If a `SecurityManager` exists and its
`checkPermission` method denies setting the log writer, this
method throws a `java.lang.SecurityException`.

##### Parameters

| out | the new logging/tracing `PrintStream` object; `null` to disable logging and tracing |
|---|---|

##### Throws

| [SecurityException](https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/SecurityException.html) | if a security manager exists and its `checkPermission` method denies setting the log writer |
|---|---|

##### See Also

- `https://developers.google.com/j2objc/javadoc/jre/reference/java/lang/SecurityManager.html#checkPermission(java.security.Permission)`
- `https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getLogWriter()`

#### public static void
**setLoginTimeout**
(int seconds)

Sets the maximum time in seconds that a driver will wait
while attempting to connect to a database.

##### Parameters

| seconds | the login time limit in seconds; zero means there is no limit |
|---|---|

##### See Also

- `https://developers.google.com/j2objc/javadoc/jre/reference/java/sql/DriverManager.html#getLoginTimeout()`