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

Introduction

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

Prototype

public synchronized void setUsername(String username)

Source Link

Document

Sets the #username .

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

Usage

From source file:com.gantzgulch.sharing.configuration.DataSourceContextProduction.java

@Bean(name = "sharingDS")
public DataSource sharingDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
    dataSource.setUrl("jdbc:hsqldb:file:" + storageLocation + "/sharing_db");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    return dataSource;
}

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

public EstadoMunicipioParserDaoJdbc() 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.xmlDocumento = this.xmlParser.build(
            "C:\\Users\\JAVA-08\\Documents\\VOSS\\Modulo 5\\pixup-dao-xml\\src\\testXML\\municipiosBajaCaliforniaSur.xml");
}

From source file:com.googlecode.jdbcproc.daofactory.guice.SimpleModule.java

@Provides
@Singleton//from   w w  w .ja  v a  2  s.  c o m
DataSource provideDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/jdbcprocdb");
    dataSource.setUsername("jdbcproc");
    dataSource.setPassword("jdbcproc");
    dataSource.setDefaultAutoCommit(true);
    dataSource.setValidationQuery("call create_collections()");

    return dataSource;
}

From source file:com.nyaba.dvdrentalsystem.app.config.ConnectionConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource ds = new org.apache.commons.dbcp.BasicDataSource();
    ds.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    ds.setUrl("jdbc:derby://localhost:1527/db");
    ds.setUsername("db");
    ds.setPassword("db");
    return ds;/*from   ww w.  j a v  a  2  s  .  com*/
}

From source file:br.com.shopcarpet.config.JpaConfig.java

/**
 * A metodo dataSource retorna a conexao do banco de dados.
 *///from   www.j av  a  2 s  .  c  om
@Bean
public DataSource getDataSource() {
    final BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUrl("jdbc:mysql://localhost/carpet");
    ds.setUsername("carpet");
    ds.setPassword("carpet123");
    return ds;
}

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;//  ww  w.j  a  va  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.livhuwani.rambuda.policyquotation_app.app.conf.ConnectionConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource ds = new org.apache.commons.dbcp.BasicDataSource();
    ds.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    ds.setUrl("jdbc:derby://localhost:1527/policy");
    ds.setUsername("app");
    ds.setPassword("app");
    return ds;/*from  w ww  .  j  av a 2 s  .  c  o m*/
}

From source file:com.nobu.dvdrentalweb.app.conf.ConnectionConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource ds = new org.apache.commons.dbcp.BasicDataSource();
    ds.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    ds.setUrl("jdbc:derby://localhost:1527/Dvd2");
    ds.setUsername("dvd");
    ds.setPassword("dvd");
    return ds;/*from w w  w  .ja  v  a 2s .c  o m*/
}

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

public DiscoPaisGenerateDaoJdbc(String archivo) throws IOException {
    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 XML
    this.xmlLogico = new Document();
    this.xmlFisico = new XMLOutputter();
    this.archivoFisico = new FileWriter(archivo);
}

From source file:com.joseph.california.app.conf.ConnectionConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource ds = new org.apache.commons.dbcp.BasicDataSource();
    ds.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    ds.setUrl("jdbc:derby://localhost:1527/hello");
    ds.setUsername("app");
    ds.setPassword("app");
    return ds;//w w  w .j av a2  s  .  c  om
}