Examples of java.sql.Driver

java.sql.Driver
An Interface to a JDBC Driver.
The JDBC Driver uses URLs to specify the location of specific data. URL format typically takes the form "xxxx:yyyy:SpecificData", where "xxxx:yyyy" is termed the subprotocol and is normally the same for all uses of a particular driver. "SpecificData" is a string which identifies the particular data source that the driver should use.

    public static void test() throws Exception {


        Connection        conn;
        Statement         stmnt;
        PreparedStatement pstmnt;
        Driver            driver;


        driver =
            (Driver) Class.forName("org.hsqldb.jdbc.JDBCDriver").newInstance();


        DriverManager.registerDriver(driver);

View Full Code Here


    public static void main(String[] args) throws Exception {


        int    runs;
        String db_path;
        Driver driver;


        runs    = def_runs;
        db_path = def_db_path;


        try {

View Full Code Here

                throw new SQLNestedException(message, t);
            }
        }


        // Create a JDBC driver instance
        Driver driver = null;
        try {
            if (driverFromCCL == null) {
                driver = DriverManager.getDriver(url);
            } else {
                // Usage of DriverManager is not possible, as it does not
                // respect the ContextClassLoader
                driver = (Driver) driverFromCCL.newInstance();
                if (!driver.acceptsURL(url)) {
                    throw new SQLException("No suitable driver", "08001"); 
                }
            }
        } catch (Throwable t) {
            String message = "Cannot create JDBC driver of class '" +

View Full Code Here

    throws Exception
  {
    ClassLoader loader = Thread.currentThread().getContextClassLoader();
    
    Class cl = Class.forName(driverClass, false, loader);
    Driver driver = (Driver) cl.newInstance();
    
    return new DataSourceAdapter(driver, url, user, password);
  }

View Full Code Here

      throw new IllegalStateException();


    if (_driver == null)
      throw new IllegalStateException();


    Driver driver = _driver;
    String url = getURL();


    if (url == null)
      throw new SQLException(L.l("can't create connection with null url"));


    try {
      Properties properties = new Properties();
      properties.putAll(getInfo());


      if (user != null)
        properties.put("user", user);
      else
        properties.put("user", "");


      if (password != null)
        properties.put("password", password);
      else
        properties.put("password", "");


      Connection conn;
      if (driver != null)
        conn = driver.connect(url, properties);
      else
        conn = java.sql.DriverManager.getConnection(url, properties);


      synchronized (this) {
        _connectionCountTotal++;

View Full Code Here

          continue;


        try {
          Class<?> cl = Class.forName(line, false, loader);


          Driver driver = (Driver) cl.newInstance();


          if (driver.acceptsURL(url))
            return cl.getName();
        } catch (Exception e) {
          log.log(Level.WARNING, e.toString(), e);
        }
      }

View Full Code Here


        loadDriver();
        String defaultdburl = url + ";create=true";
        
        // Test that we loaded the right driver by making a connection
        Driver driver = DriverManager.getDriver(defaultdburl);
        Properties props = new Properties();
        props.put("user", "testuser");
        props.put("password", "testpass");
        Connection conn = DriverManager.getConnection(defaultdburl, props);
        // Driver should be jdbc compliant.
        assertTrue(driver.jdbcCompliant());


        // compare driver.get*Version() with DatabaseMetadata.getDriver*Version.
        DatabaseMetaData dbmd = conn.getMetaData();


        assertEquals(dbmd.getDriverMajorVersion(), driver.getMajorVersion());
        assertEquals(dbmd.getDriverMinorVersion(), driver.getMinorVersion());


        // test that the driver is one of the special 40 versions if we are running
        // on Java 6 or higher
        println( "Driver is a " + driver.getClass().getName() );
        assertEquals( JDBC.vmSupportsJDBC4(), driver.getClass().getName().endsWith( "40" ) );
        
        conn.close();
    }

View Full Code Here


        loadDriver();
        String defaultdburl = orgurl + ";create=true";
        
        // Test that we loaded the right driver by making a connection
        Driver driver = DriverManager.getDriver(defaultdburl);


        int  frameworkOffset;
        int EMBEDDED_OFFSET = 0;
        int DERBYNETCLIENT_OFFSET = 1;
        if (usingDerbyNetClient())
            frameworkOffset = DERBYNETCLIENT_OFFSET;
        else // assume (usingEmbedded())
            frameworkOffset = EMBEDDED_OFFSET;
        
        // URLS to check.  New urls need to also be added to the acceptsUrl table
        String EMBEDDED_URL = "jdbc:derby:";
        String INVALID_URL = "jdbc:db2j:";
        String hostName = TestConfiguration.getCurrent().getHostName();
        int port = TestConfiguration.getCurrent().getPort();
        String CLIENT_URL = 
            "jdbc:derby://"+hostName+":"+port+"/"+dbName+";create=true";
        
        String[] urls = new String[]
        {
            EMBEDDED_URL,
            CLIENT_URL,
            INVALID_URL,
        };


        // Table that shows whether tested urls should return true for 
        // acceptsURL under the given framework
        // The acceptsURLTable uses  the frameworkOffset column int he table 
        // to check for valid results for each framework
        boolean[][] acceptsURLTable = new boolean[][]
        {
        // Framework/url      EMBEDDED     DERBYNETCLIENT 
        /* EMBEDDED_URL*/  {   true      ,  false        },
        /* CLIENT_URL  */  {   false     ,  true         },     
        /* INVALID_URL */  {   false     ,  false        } 
        };


        for (int u = 0; u < urls.length;u++)
        {
            String url = urls[u];
            boolean expectedAcceptance = acceptsURLTable[u][frameworkOffset];
            boolean actualAcceptance = driver.acceptsURL(url);
            assertEquals(expectedAcceptance, actualAcceptance);
        }
    }

View Full Code Here

        {
            String url = clientCreateUrls[i];
            try{
                if (url.equals(CLIENT_CREATE_URL_WITH_COLON1))
                {
                    Driver driver = DriverManager.getDriver(url);
                    assertNull(driver.connect(url,info));
                }
                else
                    assertConnect(true, url, info);
            }
            catch(SQLException se){

View Full Code Here

     */
    private static void assertConnect(
        boolean expectUrlEqualsGetUrl, String url, Properties info) 
    throws SQLException
    {
        Driver driver = DriverManager.getDriver(url);


        Connection conn = driver.connect(url, info);
        assertNotNull(conn);
   
        if (expectUrlEqualsGetUrl)
            assertEquals(url, conn.getMetaData().getURL());
        else

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of java.sql.Driver

bitronix.tm.resource.jdbc.lrc.LrcXADataSource

bnGUI.venn.gui.FilterDialog

com.alibaba.druid.filter.FilterChainImpl

com.alibaba.druid.proxy.DruidDriver

com.alibaba.druid.stat.DruidStatManagerFacade

com.caucho.jstl.el.SqlSetDataSourceTag

com.caucho.quercus.lib.db.Mysqli

com.caucho.sql.DriverConfig

com.facebook.presto.verifier.PrestoVerifier

com.google.appengine.tck.sql.GaeDriverTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.