public void setURL(String s) { dataSource.setURL(s); }
public void setURL(String s) { dataSource.setURL(s); }
public ScriptRunner(final String jdbcUrl, final String username, final String password) throws SQLException { OracleDataSource ds = new OracleDataSource(); ds.setURL(jdbcUrl); ds.setUser(username); ds.setPassword(password); this.dataSource = ds; }
OracleDataSource ods = new OracleDataSource(); // set cache properties java.util.Properties prop = new java.util.Properties(); prop.setProperty("MinLimit", "2"); prop.setProperty("MaxLimit", "10"); // set DataSource properties String url = "jdbc:oracle:oci8:@"; ods.setURL(url); ods.setUser("hr"); ods.setPassword("hr"); ods.setConnectionCachingEnabled(true); // be sure set to true ods.setConnectionCacheProperties (prop); ods.setConnectionCacheName("ImplicitCache01"); // this cache's name // We need to create a connection to create the cache Connection conn = ds.getConnection(user, pass); Statement stmt = conn1.createStatement(); ResultSet rset = stmt.executeQuery("select user from dual"); conn1.close(); ods.close();
dataSource.setDatabaseName(this.db); dataSource.setURL(this.url);
String password = extractPasswordfromDbUrl(dbUrl); OracleDataSource dataSource = (OracleDataSource) context.getBean("dataSource"); dataSource.setURL(url);
/** * Creates a database connection pool object using JDBC 2.0. */ private OracleDataSource createConnectionPool() { try { // Create a OracleConnectionPoolDataSource instance. OracleDataSource ds = new OracleDataSource(); ds.setConnectionCacheName("oraCache"); ds.setConnectionCachingEnabled(true); ds.setURL(TestConfig.tab().stringAt(JtaPrms.jdbcUrl)); ds.setUser(TestConfig.tab().stringAt(JtaPrms.rdbUser)); ds.setPassword(TestConfig.tab().stringAt(JtaPrms.rdbPassword)); Properties cacheProps = new Properties(); cacheProps.setProperty("MinLimit", String.valueOf(TestConfig.tab().intAt(JtaPrms.poolMinLimit))); ds.setConnectionCacheProperties(cacheProps); return ds; } catch (Exception ex) { Log.getLogWriter().info("Unable to create connection pool: " + ex, ex); throw new HydraRuntimeException("Problem creating Oracle connection pool", ex); } }
/** * Creates a database connection pool object using JDBC 2.0. */ private OracleDataSource createConnectionPool() { try { // Create a OracleConnectionPoolDataSource instance. OracleDataSource ds = new OracleDataSource(); ds.setConnectionCacheName("oraCache"); ds.setConnectionCachingEnabled(true); ds.setURL(TestConfig.tab().stringAt(DBParms.jdbcUrl)); ds.setUser(TestConfig.tab().stringAt(DBParms.rdbUser)); ds.setPassword(TestConfig.tab().stringAt(DBParms.rdbPassword)); Properties cacheProps = new Properties(); cacheProps.setProperty("MinLimit", String.valueOf(TestConfig.tab().intAt(DBParms.poolMinLimit))); ds.setConnectionCacheProperties(cacheProps); return ds; } catch (Exception ex) { Log.getLogWriter().info("Unable to create connection pool: " + ex, ex); throw new HydraRuntimeException("Problem creating connection pool", ex); } }
private static void configureDS(EntityConfig dbconfig, OracleDataSource ds) throws Exception { ds.setUser(dbconfig.getParameter("user")); ds.setPassword(dbconfig.getParameter("password")); if (dbconfig.getParameter("url")==null) { ds.setDriverType("thin"); ds.setPortNumber(dbconfig.getIntParameter("port")); ds.setServerName(dbconfig.getParameter("host")); ds.setDatabaseName(dbconfig.getParameter("sid")); } else ds.setURL(dbconfig.getParameter("url")); ds.setImplicitCachingEnabled(dbconfig.getBooleanParameter("implicit-caching")); ds.setExplicitCachingEnabled(dbconfig.getBooleanParameter("explicit-caching")); ds.setConnectionCachingEnabled(false); ds.setConnectionProperties(dbconfig.getPropertiesParameter("connection-properties")); }