java.sql

Interface Driver

Known Implementing Classes:
PoolingDriver

public interface Driver

The interface that every driver class must implement.

The Java SQL framework allows for multiple database drivers.

Each driver should supply a class that implements the Driver interface.

The DriverManager will try to load as many drivers as it can find and then for any given connection request, it will ask each driver in turn to try to connect to the target URL.

It is strongly recommended that each Driver class should be small and standalone so that the Driver class can be loaded and queried without bringing in vast quantities of supporting code.

When a Driver class is loaded, it should create an instance of itself and register it with the DriverManager. This means that a user can load and register a driver by calling

   Class.forName("foo.bah.Driver")
 
See Also:
DriverManager, Connection

Method Summary

boolean
acceptsURL(String url)
Retrieves whether the driver thinks that it can open a connection to the given URL.
Connection
connect(String url, Properties info)
Attempts to make a database connection to the given URL.
int
getMajorVersion()
Retrieves the driver's major version number.
int
getMinorVersion()
Gets the driver's minor version number.
DriverPropertyInfo[]
getPropertyInfo(String url, Properties info)
Gets information about the possible properties for this driver.
boolean
jdbcCompliant()
Reports whether this driver is a genuine JDBC CompliantTM driver.

Method Details

acceptsURL

public boolean acceptsURL(String url)
            throws SQLException
Retrieves whether the driver thinks that it can open a connection to the given URL. Typically drivers will return true if they understand the subprotocol specified in the URL and false if they do not.
Parameters:
url - the URL of the database
Returns:
true if this driver understands the given URL; false otherwise
Throws:
SQLException - if a database access error occurs
Usages and Demos :

View More Examples of acceptsURL(String url)
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: public class DriverWrapper
   6:   implements Driver
   7: {
   8:         ...
   9:   private final ProfilerPoint _profilerPoint;
  10:   private final Driver _driver;
  11: 
  12:         ...
  13:   {
  14:     return _driver.acceptsURL(url);

View Full Code Here
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: 
   6: public class SpyDriver implements java.sql.Driver {
   7:   protected final static Logger log
   8:         ...
   9: 
  10:   private Driver _driver;
  11:   
  12:         ...
  13:     try {
  14:       boolean result = _driver.acceptsURL(url);

View Full Code Here

connect

public Connection connect(String url,
                          Properties info)
            throws SQLException
Attempts to make a database connection to the given URL. The driver should return "null" if it realizes it is the wrong kind of driver to connect to the given URL. This will be common, as when the JDBC driver manager is asked to connect to a given URL it passes the URL to each loaded driver in turn.

The driver should throw an SQLException if it is the right driver to connect to the given URL but has trouble connecting to the database.

The java.util.Properties argument can be used to pass arbitrary string tag/value pairs as connection arguments. Normally at least "user" and "password" properties should be included in the Properties object.

Parameters:
url - the URL of the database to which to connect
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 object that represents a connection to the URL
Throws:
SQLException - if a database access error occurs
Usages and Demos :

View More Examples of connect(String url,java.util.Properties info)
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: public class DriverWrapper
   6:   implements Driver
   7: {
   8:         ...
   9:   private final ProfilerPoint _profilerPoint;
  10:   private final Driver _driver;
  11: 
  12:         ...
  13:   {
  14:     return wrap(_driver.connect(url, info));

View Full Code Here
   1: package com.kiwisoft.db.driver;
   2: 
   3:         ...
   4: import java.sql.Connection;
   5: import java.sql.Driver;
   6: import java.sql.SQLException;
   7:         ...
   8:     {
   9:         return "Other Driver";
  10:     }
  11:         ...
  12:             if (password!=null) connectProperties.put("password", password);
  13:             return driver.connect(url, connectProperties);

View Full Code Here
   1: 
   2:       public static java.sql.Connection getConnection(java.sql.Driver driver,
   3:                                                       String url,
   4:         ...
   5: 
   6:         return driver.connect(url, props);
   7:      }
   8:         ...
   9: 
  10:      public static java.sql.Driver getDriver(String driverClassName)
  11:          throws InstantiationException,

View Full Code Here
   1: package com.kiwisoft.db.driver;
   2: 
   3:         ...
   4: import java.sql.Connection;
   5: import java.sql.Driver;
   6: import java.sql.SQLException;
   7:         ...
   8:     private String classNames;
   9:     private Driver driver;
  10:     private String[] classes;
  11:         ...
  12:             if (password!=null) connectProperties.put("password", password);
  13:             return driver.connect(url, connectProperties);

View Full Code Here
   1:     
   2:     Driver drvdb = null;
   3:     IFunction function = null;
   4:         ...
   5:         try {
   6:             cl = Class.forName(prop.getProperty("jdbcDriverClass","org.postgresql.Driver"), false, ucl);
   7:         } catch (ClassNotFoundException ex1) {
   8:         ...
   9:         try {
  10:             drvdb = (Driver) cl.newInstance();
  11:         } catch (IllegalAccessException ex2) {

View Full Code Here

getMajorVersion

public int getMajorVersion()
Retrieves the driver's major version number. Initially this should be 1.
Returns:
this driver's major version number
Usages and Demos :

View More Examples of getMajorVersion()
   1:  
   2:       Driver theDriver = DriverManager.getDriver(sourceURL);
   3:  
   4:         ...
   5:       verMajor = theDriver.getMajorVersion();
   6: 
   7:         ...
   8:       else
   9:           System.out.println("Required version of driver (" +
  10:                       verPreferred + ") not found");

View Full Code Here
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: public class DriverWrapper
   6:   implements Driver
   7: {
   8:         ...
   9:   private final ProfilerPoint _profilerPoint;
  10:   private final Driver _driver;
  11: 
  12:         ...
  13:   {
  14:     return _driver.getMajorVersion();

View Full Code Here
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: 
   6: public class SpyDriver implements java.sql.Driver {
   7:   protected final static Logger log
   8:         ...
   9: 
  10:   private Driver _driver;
  11:   
  12:         ...
  13:   {
  14:       int result = _driver.getMajorVersion();

View Full Code Here
   1:     public static int getMajorVersion() {
   2:         return Configuration.getProductVersionHolder().getMajorVersion();
   3:     }
   4:         ...
   5:             printWriter.println(header + "BEGIN TRACE_DRIVER_CONFIGURATION");
   6:             printWriter.println(header + "Driver: " + getDriverNameAndVersion());
   7: 
   8:             printWriter.print(header + "Compatible JRE versions: { ");
   9:             for (int i = 0; i < Configuration.dncCompatibleJREVersions.length; i++) {

View Full Code Here
   1:       MsgCenter.putMsg("Connection information");
   2:       MsgCenter.putMsg("   Connection driver: " +
   3:          factory.getConnectionDriverName());
   4:         ...
   5:             Class  dClass = (Class) Class.forName(dName);
   6:             Driver driver = (Driver) dClass.newInstance();
   7: 
   8:         ...
   9:             MsgCenter.putMsg("JDBC Driver: " + dName);
  10:             MsgCenter.putMsg("   Major version: " + driver.getMajorVersion());
  11:             MsgCenter.putMsg("   Minor version: " + driver.getMinorVersion());

View Full Code Here

getMinorVersion

public int getMinorVersion()
Gets the driver's minor version number. Initially this should be 0.
Returns:
this driver's minor version number
Usages and Demos :

View More Examples of getMinorVersion()
   1:  
   2:       Driver theDriver = DriverManager.getDriver(sourceURL);
   3:  
   4:         ...
   5: 
   6:       verComplete = Float.parseFloat(verMajor + "." + theDriver.getMinorVersion());
   7: 
   8:         ...
   9:       else
  10:           System.out.println("Required version of driver (" +
  11:                       verPreferred + ") not found");

View Full Code Here
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: public class DriverWrapper
   6:   implements Driver
   7: {
   8:         ...
   9:   private final ProfilerPoint _profilerPoint;
  10:   private final Driver _driver;
  11: 
  12:         ...
  13:   {
  14:     return _driver.getMinorVersion();

View Full Code Here
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: 
   6: public class SpyDriver implements java.sql.Driver {
   7:   protected final static Logger log
   8:         ...
   9: 
  10:   private Driver _driver;
  11:   
  12:         ...
  13:   {
  14:       int result = _driver.getMinorVersion();

View Full Code Here
   1:       MsgCenter.putMsg("Connection information");
   2:       MsgCenter.putMsg("   Connection driver: " +
   3:          factory.getConnectionDriverName());
   4:         ...
   5:             Class  dClass = (Class) Class.forName(dName);
   6:             Driver driver = (Driver) dClass.newInstance();
   7: 
   8:         ...
   9:             MsgCenter.putMsg("   Major version: " + driver.getMajorVersion());
  10:             MsgCenter.putMsg("   Minor version: " + driver.getMinorVersion());
  11:             }

View Full Code Here
   1: import java.sql.DatabaseMetaData;
   2: import java.sql.Driver;
   3: import java.sql.DriverManager;
   4:         ...
   5:          int flags,
   6:          String driver,
   7:          String url)
   8:         ...
   9:     connectInternal(env, host, user, password, db, port, socket,
  10:             flags, driver, url);
  11:   }
  12:         ...
  13:           version = driver.getMajorVersion() + "." +
  14:                     driver.getMinorVersion() + ".00";

View Full Code Here

getPropertyInfo

public DriverPropertyInfo[] getPropertyInfo(String url,
                                            Properties info)
            throws SQLException
Gets information about the possible properties for this driver.

The getPropertyInfo method is intended to allow a generic GUI tool to discover what properties it should prompt a human for in order to get enough information to connect to a database. Note that depending on the values the human has supplied so far, additional values may become necessary, so it may be necessary to iterate though several calls to the getPropertyInfo method.

Parameters:
url - the URL of the database to which to connect
info - a proposed list of tag/value pairs that will be sent on connect open
Returns:
an array of DriverPropertyInfo objects describing possible properties. This array may be an empty array if no properties are required.
Throws:
SQLException - if a database access error occurs
Usages and Demos :

View More Examples of getPropertyInfo(String url,java.util.Properties info)
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: public class DriverWrapper
   6:   implements Driver
   7: {
   8:         ...
   9:   private final ProfilerPoint _profilerPoint;
  10:   private final Driver _driver;
  11: 
  12:         ...
  13:   {
  14:     return _driver.getPropertyInfo(url, info);

View Full Code Here
   1: import java.sql.Driver;
   2: import java.sql.Connection;
   3:         ...
   4:     public static final String MYSQL_DRIVER =
   5:     "com.mysql.jdbc.Driver";
   6:     public static final String ORACLE_DRIVER =
   7:         ...
   8:     "oracle.jdbc.driver.OracleDriver";
   9:     public static final String JDBC_ODBC_BRIDGE_DRIVER =
  10:         ...
  11:         DriverPropertyInfo[] attributes =
  12:         driver.getPropertyInfo(url, info);

View Full Code Here
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: 
   6: public class SpyDriver implements java.sql.Driver {
   7:   protected final static Logger log
   8:         ...
   9: 
  10:   private Driver _driver;
  11:   
  12:         ...
  13:     try {
  14:       DriverPropertyInfo []result = _driver.getPropertyInfo(url, fine);

View Full Code Here
   1: import java.sql.Driver;
   2: import java.sql.Connection;
   3:         ...
   4:     public static final String MYSQL_DRIVER =
   5:         "com.mysql.jdbc.Driver";
   6:     public static final String ORACLE_DRIVER =
   7:         ...
   8:         "oracle.jdbc.driver.OracleDriver";
   9:     public static final String JDBC_ODBC_BRIDGE_DRIVER =
  10:         ...
  11:         System.out.println("driver="+driver);
  12:         DriverPropertyInfo[] attributes = driver.getPropertyInfo(url, info);

View Full Code Here
   1: 
   2: public class TransactionalDriver implements java.sql.Driver
   3: {
   4:         ...
   5:         String theUrl = url.substring(index+TransactionalDriver.arjunaDriver.length());
   6:         Driver d = DriverManager.getDriver(theUrl);
   7: 
   8:         ...
   9:         if (d != null)
  10:         return d.getPropertyInfo(theUrl, info);
  11:         else

View Full Code Here

jdbcCompliant

public boolean jdbcCompliant()
Reports whether this driver is a genuine JDBC CompliantTM driver. A driver may only report true here if it passes the JDBC compliance tests; otherwise it is required to return false.

JDBC compliance requires full support for the JDBC API and full support for SQL 92 Entry Level. It is expected that JDBC compliant drivers will be available for all the major commercial databases.

This method is not intended to encourage the development of non-JDBC compliant drivers, but is a recognition of the fact that some vendors are interested in using the JDBC API and framework for lightweight databases that do not support full database functionality, or for special databases such as document information retrieval where a SQL implementation may not be feasible.

Returns:
true if this driver is JDBC Compliant; false otherwise
Usages and Demos :

View More Examples of jdbcCompliant()
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: public class DriverWrapper
   6:   implements Driver
   7: {
   8:         ...
   9:   private final ProfilerPoint _profilerPoint;
  10:   private final Driver _driver;
  11: 
  12:         ...
  13:   {
  14:     return _driver.jdbcCompliant();

View Full Code Here
   1: import java.sql.Connection;
   2: import java.sql.Driver;
   3: import java.sql.DriverPropertyInfo;
   4:         ...
   5: 
   6: public class SpyDriver implements java.sql.Driver {
   7:   protected final static Logger log
   8:         ...
   9: 
  10:   private Driver _driver;
  11:   
  12:         ...
  13:   {
  14:     boolean result = _driver.jdbcCompliant();

View Full Code Here