Sql java driver manager

Class DriverManager

NOTE: The DataSource interface, 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.

• The jdbc.drivers system property which contains a colon separated list of fully qualified class names of JDBC drivers. Each driver is loaded using the system class loader:
  • jdbc.drivers=foo.bah.Driver:wombat.sql.Driver:bad.taste.ourDriver

  Implementation Note: DriverManager initialization is done lazily and looks up service providers using the thread context class loader. The drivers loaded and available to an application will depend on the thread context class loader of the thread that triggers driver initialization by DriverManager .

  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 class loader as the current application.

  Method Summary

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

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

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

  Methods declared in class java.lang.Object

  Method Details

  getLogWriter

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

  setLogWriter

  Sets the logging/tracing PrintWriter object that is used by the DriverManager and all drivers. If a security manager exists, its checkPermission method is first called with a SQLPermission(«setLog») permission to check that the caller is allowed to call setLogWriter .

  getConnection

  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. Note: If a property is specified as part of the url and is also specified in the Properties object, it is implementation-defined as to which value will take precedence. For maximum portability, an application should only specify a property once.

  getConnection

  public static Connection getConnection (String url, String user, String password) throws SQLException

  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. Note: If the user or password property are also specified as part of the url , it is implementation-defined as to which value will take precedence. For maximum portability, an application should only specify a property once.

  getConnection

  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.

  getDriver

  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.

  registerDriver

  Registers the given driver with the DriverManager . A newly-loaded driver class should call the method registerDriver to make itself known to the DriverManager . If the driver is currently registered, no action is taken.

  registerDriver

  Registers the given driver with the DriverManager . A newly-loaded driver class should call the method registerDriver to make itself known to the DriverManager . If the driver is currently registered, no action is taken.

  deregisterDriver

  Removes the specified driver from the DriverManager ‘s list of registered drivers. If a null value is specified for the driver to be removed, then no action is taken. If a security manager exists, its checkPermission method is first called with a SQLPermission(«deregisterDriver») permission to check that the caller is allowed to deregister a JDBC Driver. If the specified driver is not found in the list of registered drivers, then no action is taken. If the driver was found, it will be removed from the list of registered drivers. If a DriverAction instance was specified when the JDBC driver was registered, its deregister method will be called prior to the driver being removed from the list of registered drivers.

  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()

  drivers

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

  setLoginTimeout

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

  getLoginTimeout

  setLogStream

  Sets the logging/tracing PrintStream that is used by the DriverManager and all drivers. If a security manager exists, its checkPermission method is first called with a SQLPermission(«setLog») permission to check that the caller is allowed to call setLogStream .

  getLogStream

  println

  Report a bug or suggest an enhancement
  For further API reference and developer documentation see the Java SE Documentation, which contains more detailed, developer-targeted descriptions with conceptual overviews, definitions of terms, workarounds, and working code examples. Other versions.
  Java is a trademark or registered trademark of Oracle and/or its affiliates in the US and other countries.
  Copyright © 1993, 2023, Oracle and/or its affiliates, 500 Oracle Parkway, Redwood Shores, CA 94065 USA.
  All rights reserved. Use is subject to license terms and the documentation redistribution policy.

  Источник

  Sql java driver manager

  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 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:

  Applications no longer need to explicitly 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» .

  Method Summary

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

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

  Methods inherited from class java.lang.Object

  Method Detail

  getLogWriter

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

  setLogWriter

  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 .

  getConnection

  public static Connection getConnection(String url, Properties info) throws SQLException

  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. Note: If a property is specified as part of the url and is also specified in the Properties object, it is implementation-defined as to which value will take precedence. For maximum portability, an application should only specify a property once.

  getConnection

  public static Connection getConnection(String url, String user, String password) throws SQLException

  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. Note: If the user or password property are also specified as part of the url , it is implementation-defined as to which value will take precedence. For maximum portability, an application should only specify a property once.

  getConnection

  public static Connection getConnection(String url) throws SQLException

  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.

  getDriver

  public static Driver getDriver(String url) throws SQLException

  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.

  registerDriver

  public static void registerDriver(Driver driver) throws SQLException

  Registers the given driver with the DriverManager . A newly-loaded driver class should call the method registerDriver to make itself known to the DriverManager . If the driver is currently registered, no action is taken.

  registerDriver

  public static void registerDriver(Driver driver, DriverAction da) throws SQLException

  Registers the given driver with the DriverManager . A newly-loaded driver class should call the method registerDriver to make itself known to the DriverManager . If the driver is currently registered, no action is taken.

  deregisterDriver

  public static void deregisterDriver(Driver driver) throws SQLException

  Removes the specified driver from the DriverManager ‘s list of registered drivers. If a null value is specified for the driver to be removed, then no action is taken. If a security manager exists and its checkPermission denies permission, then a SecurityException will be thrown. If the specified driver is not found in the list of registered drivers, then no action is taken. If the driver was found, it will be removed from the list of registered drivers. If a DriverAction instance was specified when the JDBC driver was registered, its deregister method will be called prior to the driver being removed from the list of registered drivers.

  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()

  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 once the driver has been identified.

  getLoginTimeout

  public static int getLoginTimeout()

  setLogStream

  @Deprecated public static void setLogStream(PrintStream out)

  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 .

  getLogStream

  @Deprecated public static PrintStream getLogStream()

  println

  Submit a bug or feature
  For further API reference and developer documentation, see Java SE Documentation. That documentation contains more detailed, developer-targeted descriptions, with conceptual overviews, definitions of terms, workarounds, and working code examples.
  Copyright © 1993, 2023, Oracle and/or its affiliates. All rights reserved. Use is subject to license terms. Also see the documentation redistribution policy.

  Источник

  Читайте также:  Copy text with html tags