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:au.org.ala.sds.GeneraliseOccurrenceLocations.java

public static void main(String[] args) throws Exception {
    nameSearcher = new ALANameSearcher(Configuration.getInstance().getNameMatchingIndex());
    sensitiveSpeciesFinder = SensitiveSpeciesFinderFactory
            .getSensitiveSpeciesFinder("file:///data/sds/sensitive-species.xml", nameSearcher);
    occurrenceDataSource = new BasicDataSource();
    occurrenceDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    occurrenceDataSource.setUrl("jdbc:mysql://localhost/portal");
    occurrenceDataSource.setUsername("root");
    occurrenceDataSource.setPassword("password");
    run(args.length == 1 ? args[0] : null);
}

From source file:com.gnizr.core.delicious.DeliciousImportApp.java

/**
 * @param args//  ww  w  . ja  va  2  s  . c  o  m
 */
public static void main(String[] args) throws Exception {
    if (args.length != 1) {
        System.out.println("Missing required arguments.");
        System.exit(1);
    }
    Properties prpt = new Properties();
    prpt.load(new FileInputStream(args[0]));
    String dbdrv = prpt.getProperty("gnizr.db.driver");
    String dbUrl = prpt.getProperty("gnizr.db.url");
    String dbUser = prpt.getProperty("gnizr.db.username");
    String dbPass = prpt.getProperty("gnizr.db.password");
    String gnizrUser = prpt.getProperty("gnizr.import.user");
    String gnizrPassword = prpt.getProperty("gnizr.import.password");
    String gnizrEmail = prpt.getProperty("gnizr.import.email");
    String gnizrFullname = prpt.getProperty("gnizr.import.fullname");
    String deliUser = prpt.getProperty("gnizr.import.delicious.user");
    String deliPassword = prpt.getProperty("gnizr.import.delicious.password");

    BasicDataSource datasource = new BasicDataSource();
    datasource.setDriverClassName(dbdrv);
    datasource.setUrl(dbUrl);
    datasource.setUsername(dbUser);
    datasource.setPassword(dbPass);

    GnizrDao gnizrDao = GnizrDao.getInstance(datasource);

    UserManager userManager = new UserManager(gnizrDao);
    BookmarkManager bookmarkManager = new BookmarkManager(gnizrDao);
    FolderManager folderManager = new FolderManager(gnizrDao);

    User gUser = new User();
    gUser.setUsername(gnizrUser);
    gUser.setPassword(gnizrPassword);
    gUser.setFullname(gnizrFullname);
    gUser.setEmail(gnizrEmail);
    gUser.setAccountStatus(AccountStatus.ACTIVE);
    gUser.setCreatedOn(GnizrDaoUtil.getNow());

    DeliciousImport deliciousImport = new DeliciousImport(deliUser, deliPassword, gUser, userManager,
            bookmarkManager, folderManager, true);
    ImportStatus status = deliciousImport.doImport();
    System.out.println("Del.icio.us Import Status: ");
    System.out.println("- total number: " + status.getTotalNumber());
    System.out.println("- number added: " + status.getNumberAdded());
    System.out.println("- number updated: " + status.getNumberUpdated());
    System.out.println("- number failed: " + status.getNumberError());
}

From source file:edu.ncsa.uiuc.rdfrepo.testing.Stats.java

public static void main(String[] args)
        throws RepositoryException, MalformedQueryException, QueryEvaluationException, SailException {
    BasicDataSource dataSource = new BasicDataSource();
    Stats stats = new Stats();
    stats.statQuery();/*w  w  w . j  a  va 2  s .c  o  m*/

    //      Repository repository = new HTTPRepository(
    //            "http://iacat-dev.ncsa.illinois.edu:8080/openrdf-sesame",
    //            "IACAT2");
    // RepositorySail sail = new RepositorySail(repository);
    //
    // SailRepository repository2 = new SailRepository(sail);
    // IndexingSail indexingSail =
    // USeekMSailFac.getIndexingSail("jdbc:postgresql://iacat-dev.ncsa.illinois.edu:5432/iacat",
    // "iacat", "*iacat*", "http://www.opengis.net/rdf#hasWKT", sail);
    // stats.statQuery(new SailRepository(indexingSail));
}

From source file:edu.caltechUcla.sselCassel.projects.jMarkets.output.OutputWriter.java

public static void main(String[] args) {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUsername("jmarkets");
    ds.setPassword("banana");

    String dbHost = "david.ssel.caltech.edu";
    String dbPort = "3306";
    String dbName = "jmarkets";

    ds.setUrl("jdbc:mysql://" + dbHost + ":" + dbPort + "/" + dbName);
    //ds.setUrl("jdbc:mysql://localhost:3306/jmarkets");
    ds.setMaxActive(10);//from   www.  j  av a2  s .  c  o  m

    OutputWriter writer = new OutputWriter();
    writer.outputSession(145, "c://output.csv");
}

From source file:aplikasi.config.KoneksiDB.java

public static DataSource getDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setUsername("root");
    ds.setPassword("admin");
    ds.setUrl("jdbc:mysql://localhost:3306/sipmi");
    ds.setDriverClassName("org.mariadb.jdbc.Driver");
    return ds;/*w w  w .  ja  v a2s.  co  m*/
}

From source file:com.util.conectividad.ConectorDB.java

public static Connection obtenerConexionBasica() {
    Connection conexion = null;/*  w ww.j  av a2  s .  com*/
    BasicDataSource basicDataSource = null;
    try {
        basicDataSource = new BasicDataSource();
        basicDataSource.setDriverClassName("oracle.jdbc.driver.OracleDriver");
        //            basicDataSource.setUrl("jdbc:oracle:thin:@192.168.21.241:1521/pdb1");// local
        basicDataSource.setUrl("jdbc:oracle:thin:@172.28.80.32:1525/INTERAT1");// local
        //            basicDataSource.setUsername("interacttdp");// local
        basicDataSource.setUsername("USR_INTERACT_APP");
        //            basicDataSource.setPassword("interacttdp99");// local
        basicDataSource.setPassword("RT87TY");
        basicDataSource.setInitialSize(5);
        basicDataSource.setMaxActive(2);
        conexion = basicDataSource.getConnection();

        return conexion;
    } catch (Exception e) {
        return conexion;
    } finally {
        basicDataSource = null;
        conexion = null;
    }
}

From source file:com.weibo.datasys.parser.sql.DBConnectionFactory.java

public static void init() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(ConfigFactory.getString("jdbc.driverClassName"));
    dataSource.setUrl(ConfigFactory.getString("jdbc.url"));
    dataSource.setUsername(ConfigFactory.getString("jdbc.username"));
    dataSource.setPassword(ConfigFactory.getString("jdbc.password"));

    dataSource.setInitialSize(ConfigFactory.getInt("jdbc.initialSize", 1));
    dataSource.setMinIdle(ConfigFactory.getInt("jdbc.minIdle", 2));
    dataSource.setMaxIdle(ConfigFactory.getInt("jdbc.maxIdle", 10));
    dataSource.setMaxWait(ConfigFactory.getInt("jdbc.maxWait", 1000));
    dataSource.setMaxActive(ConfigFactory.getInt("jdbc.maxActive", 2));
    dataSource.addConnectionProperty("autoReconnect", "true");
    // ??// w ww  .ja  v  a2  s.co m
    dataSource.setTestWhileIdle(true);
    // ?sql?
    dataSource.setValidationQuery("select 'test'");
    // ?
    dataSource.setValidationQueryTimeout(5000);
    // 
    dataSource.setTimeBetweenEvictionRunsMillis(3600000);
    // ??
    dataSource.setMinEvictableIdleTimeMillis(3600000);

    ds = dataSource;
}

From source file:com.github.ipan97.belajar.hashMD5.application.App.java

public static DataSource getDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/belajar");
    //set user database
    dataSource.setUsername("root");
    //set password
    dataSource.setPassword("admin");
    return dataSource;
}

From source file:com.taobao.tddl.jdbc.group.testutil.DataSourceFactory.java

public static DataSource getMySQLDataSource(int num) {
    if (num > 3)
        num = 1;//ww  w .jav  a 2  s.  c om
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUsername("tddl");
    ds.setPassword("tddl");
    ds.setUrl("jdbc:mysql://127.0.0.1:3306/group_test_" + num);
    return ds;

}

From source file:com.flytxt.commons.reporting.connection.ConnectionProvider.java

private static DataSource getDs() {
    if (ds == null) {
        BasicDataSource bds = new BasicDataSource();
        bds.setDriverClassName(DbConnectionPropertiesProvider.getDriver());
        bds.setUrl(DbConnectionPropertiesProvider.getUrl());
        bds.setUsername(DbConnectionPropertiesProvider.getUser());
        bds.setPassword(DbConnectionPropertiesProvider.getPwd());

        // Logger.getLogger(ConnectionProvider.class.getName()).log(Level.INFO,"Num Active : "+bds.getNumActive());
        // Logger.getLogger(ConnectionProvider.class.getName()).log(Level.INFO,"Num Idle : "+bds.getNumIdle());

        ds = bds;/*  www .  j  av  a  2 s .  com*/

    }

    return ds;
}