Java OracleDataSource.setPassword方法代码示例

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
public void initialSetup(String rootUser, String rootPass, String rootDb)
{
  try
  {
    // Set up the root connection
    OracleDataSource oracleRootSource = new OracleDataSource();

    oracleRootSource.setServerName(DatabaseProperties.getServerName());
    oracleRootSource.setServiceName(rootDb);
    oracleRootSource.setPortNumber(DatabaseProperties.getPort());
    oracleRootSource.setDriverType("thin");
    oracleRootSource.setUser(rootUser);
    oracleRootSource.setPassword(rootPass);

    this.rootDataSource = oracleRootSource;
  }
  catch (SQLException e)
  {
    throwDatabaseException(e);
  }

  this.dropUser();

  this.createUser();
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
public static Connection createConnection() throws SQLException {
    MjdbcUtils.loadDriver("oracle.jdbc.pool.OracleDataSource");

    OracleDataSource ds = new oracle.jdbc.pool.OracleDataSource();

    ds.setDriverType("thin");
    ds.setServerName("localhost");
    ds.setDatabaseName("xe");
    ds.setPortNumber(1521);
    ds.setUser("chris");
    ds.setPassword("welcome1");

    Connection conn = ds.getConnection();

    return conn;
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
private static HikariDataSource dataSource(PatterdaleRuntimeParameters runtimeParameters, DatabaseDefinition databaseDefinition, Passwords passwords, Logger logger)
        throws SQLException {
    try {
        OracleDataSource oracleDataSource = new OracleDataSource();
        oracleDataSource.setUser(databaseDefinition.user);

        String password = passwords.byDatabaseName(databaseDefinition.name).value;
        oracleDataSource.setPassword(password);

        HikariDataSource hikariDataSource = new HikariDataSource(jdbcConfig(runtimeParameters, databaseDefinition, password));
        hikariDataSource.setDataSource(oracleDataSource);
        return hikariDataSource;
    } catch (Exception e) {
        logger.error("Error occurred initialising Oracle and Hikari data sources.", e);
        throw e;    // caught by the RetryPolicy
    }
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
/**
 * 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);
  }
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
@Bean
PrivilegedDataSourceProvider privilegedBankDataSource() throws SQLException {
    OracleDataSource dataSource = new OracleDataSource();
    dataSource.setUser("system");
    dataSource.setPassword("oracle");
    dataSource.setURL("jdbc:oracle:thin:@//localhost:1521/XE");

    return DefaultPrivilegedDataSourceProvider.builder()
        .dataSourceName("dataSource")
        .privilegedDataSource(dataSource)
        .schemas(Arrays.asList("BANK"))
        .build();
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
/**
 * Creates a connection to an oracle database
 * @param username A username, e.g. "DB_USER"
 * @param password A password, e.g. "rainbow123"
 * @param connectionString A connection string, e.g. "jdbc:oracle:thin:@sdwh.cooperation.net:1331:SDWH"
 * @param log Object for accessing the console
 * @return a Connection object
 * @throws SQLException
 */
public static Connection Create(String username, String password, String connectionString, Log log) throws SQLException {
    PingPong ping = log.info("connecting to database...");
    OracleDataSource ods = new OracleDataSource();
    ods.setUser(username);
    ods.setPassword(password);
    ods.setURL(connectionString);
    log.finished(ping);
    return ods.getConnection();
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
@Bean
public OracleDataSource dataSource() throws SQLException {
	OracleDataSource ds = new OracleDataSource();
	ds.setURL(WqpEnv.get("test.datasource.url"));
	ds.setUser(WqpEnv.get("test.datasource.username"));
	ds.setPassword(WqpEnv.get("test.datasource.password"));
	return ds;
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
@Bean
public OracleDataSource dbUnitDataSource() throws SQLException {
	OracleDataSource ds = new OracleDataSource();
	ds.setURL(WqpEnv.get("test.datasource.url"));
	ds.setUser(WqpEnv.get("test.dbunit.username"));
	ds.setPassword(WqpEnv.get("test.dbunit.password"));
	return ds;
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
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;
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
private void StartConnection() {
	try {
		Locale.setDefault(new Locale(stringConnection.language(), stringConnection.country()));
		OracleDataSource ods = new OracleDataSource();
		ods.setURL("jdbc:oracle:thin:@" + stringConnection.host() + ":" + stringConnection.port() + ":" + stringConnection.database());
		ods.setUser(stringConnection.user());
		ods.setPassword(stringConnection.password());
		connection = ods.getConnection();
		connection.setAutoCommit(stringConnection.autoCommit());
	} catch (SQLException e) {
		System.out.println("Could not connect - StartConnection (). Let's try again!");
		e.printStackTrace();
		StartConnection();
	}
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
protected DataSource createDataSource() {
	try {
		OracleDataSource source = new OracleDataSource();
		source.setUser(USER);
		source.setPassword(PASS);
		source.setURL(getDataSourceURL());		
		return source;
	} catch (SQLException e) {
		logger.error("Error while creating datasource for oracle", e);
		fireRepositoryEvent(EventLevel.ERROR, "Error while creating datasource for oracle", e);
	}
    return null;
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
/**
 * Constructs a CommittingData object.
 * @throws SQLException Any database error while
 * opening a database connection
 */
public CommittingData() throws SQLException {
	OracleDataSource ods = new OracleDataSource();
	ods.setDriverType("thin");
	ods.setServerName(host);
	ods.setPortNumber(port);
	ods.setServiceName(serviceName);
	ods.setUser(userName);
	ods.setPassword(password);

	myConnection = ods.getConnection();
	myConnection.setAutoCommit(false);
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
private Database() {
	try {
		ods = new OracleDataSource();
		ods.setURL(ApplicationConfig.DB_CONNECTION);
		ods.setUser(ApplicationConfig.DB_USER);
		ods.setPassword(ApplicationConfig.DB_PASSWORD);

		// Load driver
		Class.forName(ApplicationConfig.JDBC_CLASS);
	} catch (SQLException e1) {
		LOG.warn("Connection failed!");
	} catch (ClassNotFoundException e) {
		LOG.warn("Driver not found!");
	}
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
protected DataSource createDefaultDataSource()
        throws Exception
{
    OracleDataSource unitDataSource = new OracleDataSource();

    String url = propertyManager.getUnitDataSourceURL();
    String user = propertyManager.getUnitDataSourceUser();
    String password = propertyManager.getUnitDataSourcePassword();

    unitDataSource.setURL(url);
    unitDataSource.setUser(user);
    unitDataSource.setPassword(password);

    return unitDataSource;
}
 

import oracle.jdbc.pool.OracleDataSource; //导入方法依赖的package包/类
@Bean(name = "sampledb")
public DataSource dataSource() throws SQLException {
    OracleDataSource d = new OracleDataSource();
    d.setServerName(host);
    d.setDatabaseName(databaseName);
    d.setPortNumber(portNumber);
    d.setUser(user);
    d.setPassword(password);
    return d;
}