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

List of usage examples for org.apache.commons.dbcp BasicDataSource BasicDataSource

  1. HOME
  2. Java
  3. org.apache.commons
  4. org.apache.commons.dbcp.*
  5. BasicDataSource
  6. BasicDataSource

Introduction

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

Prototype

BasicDataSource

Source Link

Usage

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

public CancionParserDaoJdbc() 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\\cancion311.xml");
}

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:ca.qc.adinfo.rouge.server.DBManager.java

public void connect() {

    this.dataSource = new BasicDataSource();

    this.dataSource.setDriverClassName(this.properties.getProperty("db.driver"));
    this.dataSource.setUsername(this.properties.getProperty("db.user"));
    this.dataSource.setPassword(this.properties.getProperty("db.pwd"));
    this.dataSource.setUrl(this.properties.getProperty("db.url"));

}

From source file:net.java.ao.db.DBCPPoolProvider.java

public DBCPPoolProvider(DatabaseProvider delegate) {
    super(delegate);

    ds = new BasicDataSource();
    try {//  ww  w .  jav a  2s.com
        ds.setDriverClassName(delegate.getDriverClass().getCanonicalName());
    } catch (ClassNotFoundException e) {
    }
    ds.setUsername(getUsername());
    ds.setPassword(getPassword());
    ds.setUrl(getURI());

    ds.setMaxActive(30);
}

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: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.spankr.tutorial.ConnectionDAO.java

/**
 * Git me mah datasource!/* www  . j  a  v  a  2  s  .c om*/
 * 
 * @return datasource pointing at the DEV version of partsearch
 */
public DataSource getDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.hsqldb.jdbc.JDBCDriver");
    ds.setUrl("jdbc:hsqldb:mem:sampleDB");
    ds.setUsername("SA");
    ds.setPassword("");
    ds.setInitialSize(2);
    ds.setMaxActive(20);
    return ds;
}

From source file:com.alibaba.druid.DBCPTest.java

public void test_max() throws Exception {
    Class.forName("com.alibaba.druid.mock.MockDriver");

    final BasicDataSource dataSource = new BasicDataSource();
    //        final DruidDataSource dataSource = new DruidDataSource();
    dataSource.setInitialSize(3);/*from   w  ww  . j  a  v  a2  s. c  om*/
    dataSource.setMaxActive(20);
    dataSource.setMaxIdle(20);
    dataSource.setDriverClassName("com.alibaba.druid.mock.MockDriver");
    dataSource.setUrl("jdbc:mock:xxx");

    final int THREAD_COUNT = 200;
    final CountDownLatch endLatch = new CountDownLatch(THREAD_COUNT);
    final CountDownLatch startLatch = new CountDownLatch(1);
    Thread[] threads = new Thread[THREAD_COUNT];
    for (int i = 0; i < THREAD_COUNT; ++i) {
        threads[i] = new Thread() {

            public void run() {
                try {
                    startLatch.await();
                    for (int i = 0; i < 1000; ++i) {
                        Connection conn = dataSource.getConnection();
                        Thread.sleep(1);
                        conn.close();
                    }
                } catch (Exception e) {
                } finally {
                    endLatch.countDown();
                }
            }
        };
        threads[i].start();
    }

    startLatch.countDown();

    endLatch.await();

    //        System.out.println(dataSource.getNumIdle());
    System.out.println(MockDriver.instance.getConnections().size());
    System.out.println(MockDriver.instance.getConnectionCloseCount());
}

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

public ArtistaParserDaoJdbc() 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\\artistas2.xml");
}

From source file:gobblin.metastore.DataSourceProvider.java

@Inject
public DataSourceProvider(@Named("dataSourceProperties") Properties properties) {
    this.basicDataSource = new BasicDataSource();
    basicDataSource//from   w w w.j a va  2 s .c om
            .setDriverClassName(properties.getProperty(ConfigurationKeys.JOB_HISTORY_STORE_JDBC_DRIVER_KEY,
                    ConfigurationKeys.DEFAULT_JOB_HISTORY_STORE_JDBC_DRIVER));
    basicDataSource.setUrl(properties.getProperty(ConfigurationKeys.JOB_HISTORY_STORE_URL_KEY));
    if (properties.containsKey(ConfigurationKeys.JOB_HISTORY_STORE_USER_KEY)
            && properties.containsKey(ConfigurationKeys.JOB_HISTORY_STORE_PASSWORD_KEY)) {
        basicDataSource.setUsername(properties.getProperty(ConfigurationKeys.JOB_HISTORY_STORE_USER_KEY));
        basicDataSource.setPassword(properties.getProperty(ConfigurationKeys.JOB_HISTORY_STORE_PASSWORD_KEY));
    }
}