Example usage for org.apache.commons.dbcp BasicDataSource setPassword

Introduction

In this page you can find the example usage for org.apache.commons.dbcp BasicDataSource setPassword.

Prototype

public synchronized void setPassword(String password)

Source Link

Document

Sets the #password .

Note: this method currently has no effect once the pool has been initialized.

Usage

From source file:com.agiletec.ConfigTestUtils.java

private void createDatasource(String dsNameControlKey, SimpleNamingContextBuilder builder,
        Properties testConfig) {/*from ww w .jav  a  2s .  co m*/
    String beanName = testConfig.getProperty("jdbc." + dsNameControlKey + ".beanName");
    try {
        String className = testConfig.getProperty("jdbc." + dsNameControlKey + ".driverClassName");
        String url = testConfig.getProperty("jdbc." + dsNameControlKey + ".url");
        String username = testConfig.getProperty("jdbc." + dsNameControlKey + ".username");
        String password = testConfig.getProperty("jdbc." + dsNameControlKey + ".password");
        Class.forName(className);
        BasicDataSource ds = new BasicDataSource();
        ds.setUrl(url);
        ds.setUsername(username);
        ds.setPassword(password);
        ds.setMaxActive(8);
        ds.setMaxIdle(4);
        ds.setDriverClassName(className);
        builder.bind("java:comp/env/jdbc/" + beanName, ds);
    } catch (Throwable t) {
        throw new RuntimeException("Error on creation datasource '" + beanName + "'", t);
    }
}

From source file:mx.com.pixup.portal.dao.DiscoParserDaoJdbc.java

public DiscoParserDaoJdbc(String archivoFisico) throws IOException, JDOMException {
    BasicDataSource dataSource = new BasicDataSource();

    //seccion de la DB
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUsername("root");
    dataSource.setPassword("admin");
    //dataSource.setPassword("mysqlroot");
    dataSource.setUrl("jdbc:mysql://localhost:3306/pixup");
    this.dataSource = dataSource;

    //seccion generate XML
    this.xmlParser = new SAXBuilder();
    this.xmlDocument = this.xmlParser.build(archivoFisico);
}

From source file:com.dangdang.ddframe.job.event.rdb.JobEventRdbListenerTest.java

@Before
public void setUp() throws JobEventListenerConfigurationException, SQLException, NoSuchFieldException {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(org.h2.Driver.class.getName());
    dataSource.setUrl("jdbc:h2:mem:job_event_storage");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    JobEventRdbListener jobEventRdbListener = new JobEventRdbListener(dataSource);
    ReflectionUtils.setFieldValue(jobEventRdbListener, "repository", repository);
    when(jobEventRdbConfiguration.createJobEventListener()).thenReturn(jobEventRdbListener);
    jobEventBus = new JobEventBus(jobEventRdbConfiguration);
}

From source file:net.hydromatic.optiq.impl.splunk.SplunkDriver.java

@Override
public Connection connect(String url, Properties info) throws SQLException {
    Connection connection = super.connect(url, info);
    OptiqConnection optiqConnection = (OptiqConnection) connection;
    SplunkConnection splunkConnection;/*w  ww .java 2  s.c  o  m*/
    try {
        String url1 = info.getProperty("url");
        if (url1 == null) {
            throw new IllegalArgumentException("Must specify 'url' property");
        }
        URL url2 = new URL(url1);
        String user = info.getProperty("user");
        if (user == null) {
            throw new IllegalArgumentException("Must specify 'user' property");
        }
        String password = info.getProperty("password");
        if (password == null) {
            throw new IllegalArgumentException("Must specify 'password' property");
        }
        splunkConnection = new SplunkConnection(url2, user, password);
    } catch (Exception e) {
        throw new SQLException("Cannot connect", e);
    }
    final MutableSchema rootSchema = optiqConnection.getRootSchema();
    final String schemaName = "splunk";
    final SplunkSchema schema = new SplunkSchema(optiqConnection, rootSchema, schemaName, splunkConnection,
            optiqConnection.getTypeFactory(), rootSchema.getSubSchemaExpression(schemaName, Schema.class));
    rootSchema.addSchema(schemaName, schema);

    // Include a schema called "mysql" in every splunk connection.
    // This is a hack for demo purposes. TODO: Add a config file mechanism.
    if (true) {
        final String mysqlSchemaName = "mysql";
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            throw new SQLException(e);
        }
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setUrl("jdbc:mysql://localhost");
        dataSource.setUsername("foodmart");
        dataSource.setPassword("foodmart");

        JdbcSchema.create(optiqConnection.getRootSchema(), dataSource, "foodmart", "", mysqlSchemaName);
    }

    return connection;
}

From source file:com.github.viktornar.configuration.ApplicationConfig.java

@Profile("development")
@Bean(destroyMethod = "close")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
    dataSource.setUrl("jdbc:hsqldb:mem:composer_db");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    return dataSource;
}

From source file:com.bt.aloha.testing.JdbcHelper.java

private DataSource buildDataSource(String driver, String url, String username, String password)
        throws Exception {
    log.debug(String.format("Building datasource %s, %s, %s, %s", driver, url, username, password));
    BasicDataSource ds = new BasicDataSource();

    ds.setDriverClassName(driver);//from www  .  j ava  2  s .co  m
    ds.setUrl(url);
    ds.setUsername(username);
    ds.setPassword(password);

    return ds;
}

From source file:com.miserablemind.butter.bootstrap.RootContext.java

/**
 * Data Source Bean that is configured for JDBC connection using {@link ConfigJDBC}.
 *
 * @return {@link BasicDataSource} bean with a name {@code dataSource}.
 *///from  ww w.  ja v a 2 s . c o  m
@Bean(name = "dataSource")
public BasicDataSource dataSource() {

    ConfigJDBC configJDBC = this.configSystem.getConfigJDBC();

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUsername(configJDBC.getJdbcUsername());
    dataSource.setPassword(configJDBC.getJdbcPassword());
    dataSource.setUrl(configJDBC.getJdbcUrl());
    dataSource.setDriverClassName(configJDBC.getJdbcDriverClassName());

    return dataSource;
}

From source file:com.ryno.retailwarehouseweb3.app.config.ConnectionConfig.java

@Bean
//create database
public DataSource dataSource() {
    BasicDataSource dataSrc = new org.apache.commons.dbcp.BasicDataSource();
    dataSrc.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    dataSrc.setUrl("jdbc:derby://localhost:1527/sample");
    dataSrc.setUsername("app");
    dataSrc.setPassword("app");
    return dataSrc;
}

From source file:com.stitchgalaxy.domain.spring.configuration.JpaConfig.java

@Bean
public DataSource dataSource() {
    org.apache.commons.dbcp.BasicDataSource ds = new org.apache.commons.dbcp.BasicDataSource();
    ds.setUrl(jdbcUrl);/*from w  w w . ja v  a  2s . c  o  m*/
    ds.setDriverClassName(driverClassName);
    ds.setUsername(username);
    ds.setPassword(password);
    ds.setInitialSize(4);
    ds.setDefaultAutoCommit(false);
    return ds;
    //EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    //return builder.setType(EmbeddedDatabaseType.HSQL).build();
}

From source file:com.amuponda.estorehack.business.config.EstoreHackDataConfig.java

@Bean(destroyMethod = "close")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();

    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/estore");
    dataSource.setUsername("root");
    dataSource.setPassword("uctatm");

    //This should solve the notorious broken pipe exception
    dataSource.setValidationQuery("SELECT 1");
    dataSource.setTestOnBorrow(true);//from www.  j  ava2  s . co m
    dataSource.setRemoveAbandoned(true);
    dataSource.setRemoveAbandonedTimeout(60);
    dataSource.setLogAbandoned(true);

    return dataSource;
}