List of usage examples for java.sql DriverManager registerDriver
public static void registerDriver(java.sql.Driver driver) throws SQLException
From source file:com.alibaba.druid.benckmark.pool.Case1.java
protected void setUp() throws Exception { DriverManager.registerDriver(TestDriver.instance); user = "dragoon25"; password = "dragoon25"; // jdbcUrl = "jdbc:h2:mem:"; // driverClass = "org.h2.Driver"; jdbcUrl = "jdbc:test:case1:"; driverClass = "com.alibaba.druid.benckmark.pool.Case1$TestDriver"; physicalConnStat.set(0);//from w ww .j a v a 2 s . c o m }
From source file:de.awtools.grooocle.varray.VarrayTest.java
@BeforeClass public static void setUpClass() throws Exception { String[] tokens = new String[] { "${user}", "${pwd}", "${url}" }; String user = System.getProperty("groovy.oracle.test.user"); String pwd = System.getProperty("groovy.oracle.test.password"); String url = System.getProperty("groovy.oracle.test.url"); String[] replacements = new String[] { user, pwd, url }; DriverManager.registerDriver(new oracle.jdbc.OracleDriver()); String oracleUrl = StringUtils.replaceEach(ORACLE_URL, tokens, replacements); conn = DriverManager.getConnection(oracleUrl, user, pwd); conn.setAutoCommit(false);//from w w w . ja v a 2s . c o m Statement stmt = conn.createStatement(); stmt.execute("CREATE TYPE t_string_varray AS VARRAY(10) OF VARCHAR2(100)"); stmt.execute( "CREATE PROCEDURE call_me(p_strings IN t_string_varray, p_retcode OUT NUMBER) IS BEGIN p_retcode := p_strings.COUNT; END call_me;"); // Doesnt work: // stmt.execute("CREATE OR REPLACE PACKAGE TEST_PACKAGE IS PROCEDURE log(p_stichmon IN NUMBER); END;"); // stmt.execute("CREATE OR REPLACE PACKAGE BODY TEST_PACKAGE IS PROCEDURE log(p_stichmon IN NUMBER) IS BEGIN NULL; END log; END ;"); stmt.execute("ALTER PROCEDURE call_me COMPILE"); }
From source file:net.sf.jdmf.data.sources.jdbc.JDBCDataSource.java
public JDBCDataSource(Driver driver, String connectionString, String userName, String password, String query) { super();/*from w ww . j a va 2s . co m*/ this.connectionString = connectionString; this.userName = userName; this.password = password; queries.add(query); try { DriverManager.registerDriver(driver); } catch (SQLException e) { throw new DataSourceException("Could not register JDBC driver", e); } }
From source file:la.alsocan.symbiot.cli.DropCreateDatabaseCommand.java
@Override protected void run(Bootstrap<ServerConfiguration> bootstrap, Namespace namespace, ServerConfiguration configuration) throws Exception { // check that the config uses Derby with the expected name (KISS!) if (!EXPECTED_DRIVER.equals(configuration.getDataSourceFactory().getDriverClass()) || !EXPECTED_URL.equals(configuration.getDataSourceFactory().getUrl())) { throw new IllegalStateException("Expected driver '" + EXPECTED_DRIVER + "' and url '" + EXPECTED_URL + "' in the config (yeah, that's life)."); }//from w w w . j av a 2 s. c om // drop existing database File f = new File(DB_NAME); if (f.exists() && f.isDirectory()) { FileUtils.deleteDirectory(f); } // create new database (with DDL) DriverManager.registerDriver((Driver) Class.forName(EXPECTED_DRIVER).newInstance()); try (Connection c = DriverManager.getConnection( EXPECTED_URL + ";create=true" + ";user=" + configuration.getDataSourceFactory().getUser() + ";password=" + configuration.getDataSourceFactory().getPassword())) { c.createStatement().executeUpdate(InputDao.DDL); c.createStatement().executeUpdate(OutputDao.DDL); c.createStatement().executeUpdate(StreamDao.DDL); c.createStatement().executeUpdate(BindingDao.DDL); } }
From source file:org.meerkat.util.sql.SQLDriverLoader.java
/** * loadDriver// ww w. jav a 2 s . c om * @param jarDir * @param dbDescription * @param driverClass */ public final void loadDriver(String jarDir, String dbDescription, String driverClass) { // Get the jar name inside the dir String odir = jarDir; File ora_dir = new File(odir); String[] ext = new String[] { "jar" }; List<File> files = (List<File>) FileUtils.listFiles(ora_dir, ext, true); if (files.size() == 0) { log.debug(dbDescription + " JDBC driver jar not available."); } else { try { File fdriver = files.get(0); URL u = new URL("jar:file:" + odir + fdriver.getName() + "!/"); String classname = driverClass; URLClassLoader ucl = new URLClassLoader(new URL[] { u }); Driver d = (Driver) Class.forName(classname, true, ucl).newInstance(); DriverManager.registerDriver(new SQLDriverJar(d)); } catch (Exception e) { log.error(dbDescription + " JDBC driver jar not available."); } } }
From source file:com.yoncabt.ebr.jdbcbridge.pool.DataSource.java
public EBRConnection connect(String driver, String url, String user, String pass) throws SQLException { try {// w w w . j ava 2s. co m DriverManager.registerDriver((Driver) Class.forName(driver).newInstance()); Connection connection = DriverManager.getConnection(url, user, pass); return new EBRConnection(this, connection); } catch (ClassNotFoundException | InstantiationException | IllegalAccessException ex) { throw new SQLException(ex); } }
From source file:nl.b3p.gis.writers.B3pOgcSqlWriter.java
public B3pOgcSqlWriter(String url, String user, String password, java.sql.Driver driver) throws SQLException { DriverManager.registerDriver(driver); setConnection(DriverManager.getConnection(url, user, password)); }
From source file:org.sonar.jpa.session.DriverDatabaseConnector.java
public Connection getConnection() throws SQLException { try {/* ww w . ja v a 2s . co m*/ /* The sonar batch downloads the JDBC driver in a separated classloader. This is a well-know problem of java.sql.DriverManager. The workaround is to use a proxy. See http://stackoverflow.com/questions/288828/how-to-use-a-jdbc-driver-from-an-arbitrary-location */ Driver driver = (Driver) classloader.loadClass(getDriver()).newInstance(); DriverManager.registerDriver(new DriverProxy(driver)); } catch (Exception e) { SQLException ex = new SQLException("SQL driver not found " + getDriver()); ex.initCause(e); throw ex; } return DriverManager.getConnection(getUrl(), getUsername(), getPassword()); }
From source file:net.riezebos.thoth.configuration.persistence.ThothDB.java
protected void registerDriver(String driverClassName) throws DatabaseException { try {/*from ww w .j a va 2 s . c om*/ Class<?> driverClass = Thread.currentThread().getContextClassLoader().loadClass(driverClassName); DriverManager.registerDriver((Driver) driverClass.newInstance()); } catch (Exception e) { throw new DatabaseException(e.getMessage(), e); } }
From source file:com.yoncabt.abys.core.util.EBRConf.java
/** * veritabanna tekrar balanr/*from ww w .ja v a 2 s . co m*/ * * @param tmp bilgilerin okunaca map */ private void reconnectToDb(Map<String, String> tmp) { final String name = getClass().getSimpleName().toLowerCase(Locale.US); if (tmp.containsKey(name + ".connection.url")) { try { if (connection != null) { connection.close(); } DriverManager .registerDriver((Driver) Class.forName(tmp.get(name + ".connection.driver")).newInstance()); connection = DriverManager.getConnection(tmp.get(name + ".connection.url"), tmp.get(name + ".connection.user"), tmp.get(name + ".connection.pass")); tableName = tmp.get(name + ".connection.tableName"); tableKeyColumn = tmp.get(name + ".connection.tableKeyColumn"); tableValueColumn = tmp.get(name + ".connection.tableValueColumn"); } catch (SQLException | ClassNotFoundException | InstantiationException | IllegalAccessException ex) { Logger.getLogger(EBRConf.class.getName()).log(Level.SEVERE, null, ex); } } }