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

Introduction

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

Prototype

public synchronized void setUrl(String url)

Source Link

Document

Sets the #url .

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

Usage

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:gxu.software_engineering.shen10.market.core.SpringBeans.java

@Bean(destroyMethod = "close")
public DataSource dataSource() {
    Properties props = new Properties();
    InputStream in = null;//ww  w  .jav a 2  s  .c o m
    try {
        in = this.getClass().getResourceAsStream("/db/dataSource.properties");
        props.load(in);
    } catch (IOException e) {
        L.error("????", e);
    } finally {
        try {
            in.close();
        } catch (IOException e) {
            L.error("wtf!", e);
        }
    }
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(props.getProperty("db.driver"));
    dataSource.setUrl(props.getProperty("db.url"));
    dataSource.setUsername(props.getProperty("db.username"));
    dataSource.setPassword(props.getProperty("db.password"));
    dataSource.setDefaultAutoCommit(false);
    return dataSource;
}

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:net.certifi.audittablegen.GenericDMR.java

/**
 * Generate a DataSource from Properties 
 * @param props/*  w  w w.  j av  a 2 s . c o m*/
 * @return BasicDataSource as DataSource
 */
static DataSource getRunTimeDataSource(Properties props) {

    BasicDataSource dataSource = new BasicDataSource();

    dataSource.setDriverClassName(props.getProperty("driver", ""));
    dataSource.setUsername(props.getProperty("username"));
    dataSource.setPassword(props.getProperty("password"));
    dataSource.setUrl(props.getProperty("url"));
    dataSource.setMaxActive(10);
    dataSource.setMaxIdle(5);
    dataSource.setInitialSize(5);

    //dataSource.setValidationQuery("SELECT 1");

    return dataSource;
}

From source file:com.alibaba.otter.node.etl.common.datasource.AbstractDbDialectTest.java

private DataSource createDataSource(String url, String userName, String password, String driverClassName,
        DataMediaType dataMediaType, String encoding) {
    BasicDataSource dbcpDs = new BasicDataSource();

    dbcpDs.setRemoveAbandoned(true);/*from ww  w  . j av  a2s . c o m*/
    dbcpDs.setLogAbandoned(true);
    dbcpDs.setTestOnBorrow(true);
    dbcpDs.setTestWhileIdle(true);

    // ??
    dbcpDs.setDriverClassName(driverClassName);
    dbcpDs.setUrl(url);
    dbcpDs.setUsername(userName);
    dbcpDs.setPassword(password);

    if (dataMediaType.isOracle()) {
        dbcpDs.addConnectionProperty("restrictGetTables", "true");
        dbcpDs.setValidationQuery("select 1 from dual");
    } else if (dataMediaType.isMysql()) {
        // open the batch mode for mysql since 5.1.8
        dbcpDs.addConnectionProperty("useServerPrepStmts", "true");
        dbcpDs.addConnectionProperty("rewriteBatchedStatements", "true");
        if (StringUtils.isNotEmpty(encoding)) {
            dbcpDs.addConnectionProperty("characterEncoding", encoding);
        }
        dbcpDs.setValidationQuery("select 1");
    }

    return dbcpDs;
}

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:cn.newgxu.lab.core.config.SpringBeans.java

@Bean(destroyMethod = "close")
public DataSource dataSource() {
    Properties props = new Properties();
    InputStream in = null;/*from   w  ww.ja  v a2 s . c o  m*/
    try {
        in = this.getClass().getResourceAsStream("/config/dataSource.properties");
        props.load(in);
    } catch (IOException e) {
        L.error("????", e);
    } finally {
        try {
            in.close();
        } catch (IOException e) {
            L.error("wtf!", e);
        }
    }
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(props.getProperty("db.driver"));
    dataSource.setUrl(props.getProperty("db.url"));
    dataSource.setUsername(props.getProperty("db.username"));
    dataSource.setPassword(props.getProperty("db.password"));
    dataSource.setDefaultAutoCommit(false);
    return dataSource;
}

From source file:com.uber.hoodie.utilities.HiveIncrementalPuller.java

private DataSource getDatasource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(driverName);//from ww w.ja v  a  2 s .  c  o  m
    ds.setUrl(config.hiveJDBCUrl);
    ds.setUsername(config.hiveUsername);
    ds.setPassword(config.hivePassword);
    return ds;
}

From source file:io.pivotal.spring.xd.jdbcgpfdist.support.GreenplumDataSourceFactoryBean.java

@Override
protected BasicDataSource createInstance() throws Exception {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.postgresql.Driver");
    if (StringUtils.hasText(dbUser)) {
        ds.setUsername(dbUser);/*from w  w  w  .j av  a  2 s  . c om*/
    }
    if (StringUtils.hasText(dbPassword)) {
        ds.setPassword(dbPassword);
    }
    ds.setUrl("jdbc:postgresql://" + dbHost + ":" + dbPort + "/" + dbName);
    return ds;
}

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

public FormaPagoDaoJdbc() {
    BasicDataSource dataSource = new BasicDataSource();

    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;
}