oracle.jdbc.pool.OracleDataSource ds = new oracle.jdbc.pool.OracleDataSource(); ds.setDriverType("thin"); ds.setServerName("localhost"); ds.setPortNumber(1521); ds.setDatabaseName("XE"); // Oracle SID Connection con = ds.getConnection(user, password);
oracle.jdbc.pool.OracleDataSource ds = new oracle.jdbc.pool.OracleDataSource(); ds.setDriverType("thin"); ds.setServerName("localhost"); ds.setPortNumber(1521); ds.setDatabaseName("XE"); // Oracle SID ds.setUser("Herong"); ds.setPassword("TopSecret");
/** * Default constructor for an Oracle RAC Local DataSource. * * @throws SQLException if there was a problem instantiating an OracleDataSource */ public LocalRACMCF() throws SQLException { super(new OracleDataSource(), new OracleRACExceptionSorter(), true); // the following property has to be set for the ONS.jar, even though its not used in thin mode System.setProperty("oracle.ons.oraclehome", "."); }
/** * Default constructor for an Oracle Local DataSource. * * @throws SQLException if there was a problem instantiating an OracleDataSource */ public LocalMCF() throws SQLException { super(new OracleDataSource(), new OracleExceptionSorter(), true); }
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; }
props.putAll(configurationProperties); try { OracleDataSource ods = new OracleDataSource();
@SuppressWarnings("unchecked") public static void initializeDAD(String dadName, Configuration config, ServletContext ctx) throws Exception { logger.info("init DAD: "+dadName); EntityConfig dadConfig= config.getDADConfig(dadName); String dewrapperClassName= dadConfig.getParameter("jndi-connection-dewrapper"); String jndiDataSourceName= dadConfig.getParameter("jndi-datasource"); DataSource ds= null; if (dewrapperClassName!=null) { Constructor<DataSource> c= (Constructor<DataSource>) Thread.currentThread().getContextClassLoader().loadClass(dewrapperClassName).getConstructor(DataSource.class); ds= c.newInstance(lookupDataSource(jndiDataSourceName)); } else if (jndiDataSourceName!=null) ds= lookupDataSource(jndiDataSourceName); else { ds= new OracleDataSource(); configureDS(dadConfig,(OracleDataSource)ds); } ctx.setAttribute(DAD_DATA_SOURCE+"|"+dadName, ds); }
dataSource = new OracleDataSource(); dataSource.setServerName(this.host); dataSource.setUser(this.user);
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();
/** * 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); } }
/** * 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); } }