- java.lang.Object
-
- java.sql.DriverManager
-
public class DriverManager extends Object
The basic service for managing a set of JDBC drivers.
NOTE: TheDataSource
interface, new in the JDBC 2.0 API, provides another way to connect to a data source. The use of aDataSource
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
methodsgetConnection
andgetDrivers
have been enhanced to support the Java Standard Edition Service Provider mechanism. JDBC 4.0 Drivers must include the fileMETA-INF/services/java.sql.Driver
. This file contains the name of the JDBC drivers implementation ofjava.sql.Driver
. For example, to load themy.sql.Driver
class, theMETA-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 usingClass.forName()
will continue to work without modification.When the method
getConnection
is called, theDriverManager
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:
Driver
,Connection
-
-
Method Summary
Methods Modifier and Type Method and Description static void
deregisterDriver(Driver driver)
Drops a driver from theDriverManager
's list.static Connection
getConnection(String url)
Attempts to establish a connection to the given database URL.static Connection
getConnection(String url, Properties info)
Attempts to establish a connection to the given database URL.static Connection
getConnection(String url, String user, String password)
Attempts to establish a connection to the given database URL.static Driver
getDriver(String url)
Attempts to locate a driver that understands the given URL.static Enumeration<Driver>
getDrivers()
Retrieves an Enumeration with all of the currently loaded JDBC drivers to which the current caller has access.static int
getLoginTimeout()
Gets the maximum time in seconds that a driver can wait when attempting to log in to a database.static PrintStream
getLogStream()
Deprecated.static PrintWriter
getLogWriter()
Retrieves the log writer.static void
println(String message)
Prints a message to the current JDBC log stream.static void
registerDriver(Driver driver)
Registers the given driver with theDriverManager
.static void
setLoginTimeout(int seconds)
Sets the maximum time in seconds that a driver will wait while attempting to connect to a database.static void
setLogStream(PrintStream out)
Deprecated.static void
setLogWriter(PrintWriter out)
Sets the logging/tracingPrintWriter
object that is used by theDriverManager
and all drivers.
-
-
-
Method Detail
-
getLogWriter
public static PrintWriter getLogWriter()
Retrieves the log writer. ThegetLogWriter
andsetLogWriter
methods should be used instead of theget/setlogStream
methods, which are deprecated.- Returns:
- a
java.io.PrintWriter
object - Since:
- 1.2
- See Also:
setLogWriter(java.io.PrintWriter)
-
setLogWriter
public static void setLogWriter(PrintWriter out)
Sets the logging/tracingPrintWriter
object that is used by theDriverManager
and all drivers.There is a minor versioning problem created by the introduction of the method
setLogWriter
. The methodsetLogWriter
cannot create aPrintStream
object that will be returned bygetLogStream
---the Java platform does not provide a backward conversion. As a result, a new application that usessetLogWriter
and also uses a JDBC 1.0 driver that usesgetLogStream
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 aSecurityManager
exists and itscheckPermission
method denies setting the log writer, this method throws ajava.lang.SecurityException
.- Parameters:
out
- the new logging/tracingPrintStream
object;null
to disable logging and tracing- Throws:
SecurityException
- if a security manager exists and itscheckPermission
method denies setting the log writer- Since:
- 1.2
- See Also:
SecurityManager.checkPermission(java.security.Permission)
,getLogWriter()
-
getConnection
public static Connection getConnection(String url, Properties info) throws SQLException
Attempts to establish a connection to the given database URL. TheDriverManager
attempts to select an appropriate driver from the set of registered JDBC drivers.- Parameters:
url
- a database url of the formjdbc: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 Connection getConnection(String url, String user, String password) throws SQLException
Attempts to establish a connection to the given database URL. TheDriverManager
attempts to select an appropriate driver from the set of registered JDBC drivers.- Parameters:
url
- a database url of the formjdbc:subprotocol:subname
user
- the database user on whose behalf the connection is being madepassword
- the user's password- Returns:
- a connection to the URL
- Throws:
SQLException
- if a database access error occurs
-
getConnection
public static Connection getConnection(String url) throws SQLException
Attempts to establish a connection to the given database URL. TheDriverManager
attempts to select an appropriate driver from the set of registered JDBC drivers.- Parameters:
url
- a database url of the formjdbc: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
Attempts to locate a driver that understands the given URL. TheDriverManager
attempts to select an appropriate driver from the set of registered JDBC drivers.- Parameters:
url
- a database URL of the formjdbc:subprotocol:subname
- Returns:
- a
Driver
object representing a driver that can connect to the given URL - Throws:
SQLException
- if a database access error occurs
-
registerDriver
public static void registerDriver(Driver driver) throws SQLException
Registers the given driver with theDriverManager
. A newly-loaded driver class should call the methodregisterDriver
to make itself known to theDriverManager
.- Parameters:
driver
- the new JDBC Driver that is to be registered with theDriverManager
- Throws:
SQLException
- if a database access error occurs
-
deregisterDriver
public static void deregisterDriver(Driver driver) throws SQLException
Drops a driver from theDriverManager
's list. Applets can only deregister drivers from their own classloaders.- Parameters:
driver
- the JDBC Driver to drop- Throws:
SQLException
- if a database access error occurs
-
getDrivers
public static Enumeration<Driver> 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
-
setLoginTimeout
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:
getLoginTimeout()
-
getLoginTimeout
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:
setLoginTimeout(int)
-
setLogStream
public static void setLogStream(PrintStream out)
Deprecated.Sets the logging/tracing PrintStream that is used by theDriverManager
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 aSecurityManager
exists and itscheckPermission
method denies setting the log writer, this method throws ajava.lang.SecurityException
.- Parameters:
out
- the new logging/tracing PrintStream; to disable, set tonull
- Throws:
SecurityException
- if a security manager exists and itscheckPermission
method denies setting the log stream- See Also:
SecurityManager.checkPermission(java.security.Permission)
,getLogStream()
-
getLogStream
public static PrintStream getLogStream()
Deprecated.Retrieves the logging/tracing PrintStream that is used by theDriverManager
and all drivers.- Returns:
- the logging/tracing PrintStream; if disabled, is
null
- See Also:
setLogStream(java.io.PrintStream)
-
println
public static void println(String message)
Prints a message to the current JDBC log stream.- Parameters:
message
- a log or tracing message
-
-
Nederlandse vertaling
U hebt gevraagd om deze site in het Nederlands te bezoeken. Voor nu wordt alleen de interface vertaald, maar nog niet alle inhoud.Als je me wilt helpen met vertalingen, is je bijdrage welkom. Het enige dat u hoeft te doen, is u op de site registreren en mij een bericht sturen waarin u wordt gevraagd om u toe te voegen aan de groep vertalers, zodat u de gewenste pagina's kunt vertalen. Een link onderaan elke vertaalde pagina geeft aan dat u de vertaler bent en heeft een link naar uw profiel.
Bij voorbaat dank.
Document heeft de 11/06/2005 gemaakt, de laatste keer de 04/03/2020 gewijzigd
Bron van het afgedrukte document:https://www.gaudry.be/nl/java-api-rf-java/sql/DriverManager.html
De infobrol is een persoonlijke site waarvan de inhoud uitsluitend mijn verantwoordelijkheid is. De tekst is beschikbaar onder CreativeCommons-licentie (BY-NC-SA). Meer info op de gebruiksvoorwaarden en de auteur.
Referenties
Deze verwijzingen en links verwijzen naar documenten die geraadpleegd zijn tijdens het schrijven van deze pagina, of die aanvullende informatie kunnen geven, maar de auteurs van deze bronnen kunnen niet verantwoordelijk worden gehouden voor de inhoud van deze pagina.
De auteur Deze site is als enige verantwoordelijk voor de manier waarop de verschillende concepten, en de vrijheden die met de referentiewerken worden genomen, hier worden gepresenteerd. Vergeet niet dat u meerdere broninformatie moet doorgeven om het risico op fouten te verkleinen.