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:pcconfigurator.ConfigurationManagerImplTest.java

private DataSource setDataSource() {
    BasicDataSource ds = new BasicDataSource();
    if (name != null && password != null && dbUrl != null) {
        ds.setUrl(dbUrl);
        ds.setUsername(name);/*from  w w  w.j  a  va 2s.  c o m*/
        ds.setPassword(password);
    } else
        throw new InternalFailureException("cannot create DataSource, properties are empty");

    return ds;
}

From source file:philaman.cput.cardealer.app.config.AppConfig.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/LimaCarDealers");
    ds.setUsername("app");
    ds.setPassword("app");
    return ds;/* w ww. jav a  2s .  c o m*/
}

From source file:qa.qcri.nadeef.core.util.sql.DBConnectionPool.java

/**
 * Create a connection pool.//from  w w w.  j a va  2s.c o  m
 * @param dbconfig input DB config.
 * @return connection pool instance.
 */
public BasicDataSource createConnectionPool(DBConfig dbconfig) {
    tracer.verbose("Creating connection pool for " + dbconfig.getUrl());
    BasicDataSource result;
    result = new BasicDataSource();
    result.setUrl(dbconfig.getUrl());
    result.setDriverClassName(SQLDialectTools.getDriverName(dbconfig.getDialect()));

    String username = dbconfig.getUserName();
    if (!Strings.isNullOrEmpty(username)) {
        result.setUsername(username);
    }

    String password = dbconfig.getPassword();
    if (!Strings.isNullOrEmpty(password)) {
        result.setPassword(password);
    }

    result.setMaxActive(MAX_ACTIVE);
    result.setMaxIdle(MAX_ACTIVE * 3);
    result.setDefaultAutoCommit(false);
    return result;
}

From source file:qa.qcri.nadeef.core.utils.sql.DBConnectionPool.java

/**
 * Create a connection pool.//from ww  w  . ja va  2  s  .c om
 * @param dbconfig input DB config.
 * @return connection pool instance.
 */
public BasicDataSource createConnectionPool(DBConfig dbconfig) {
    tracer.fine("Creating connection pool for " + dbconfig.getUrl());
    BasicDataSource result;
    result = new BasicDataSource();
    result.setUrl(dbconfig.getUrl());
    result.setDriverClassName(SQLDialectTools.getDriverName(dbconfig.getDialect()));

    String username = dbconfig.getUserName();
    if (!Strings.isNullOrEmpty(username)) {
        result.setUsername(username);
    }

    String password = dbconfig.getPassword();
    if (!Strings.isNullOrEmpty(password)) {
        result.setPassword(password);
    }

    result.setMaxActive(MAX_ACTIVE);
    result.setMaxIdle(MAX_ACTIVE * 3);
    result.setDefaultAutoCommit(false);
    return result;
}

From source file:rentalshop.CustomerManagerImplTest.java

private static DataSource prepareDataSource() throws SQLException {
    BasicDataSource ds = new BasicDataSource();
    //we will use in memory database
    ds.setUrl("jdbc:derby:memory:CarManagerTest;create=true");
    return ds;//from  w ww. j a  v a2 s . c  o  m
}

From source file:rentalshop.Window.java

private static DataSource prepareDataSource() throws SQLException {
    BasicDataSource bds = new BasicDataSource();

    bds.setUrl(java.util.ResourceBundle.getBundle("Resource/Database").getString("URL"));
    return bds;//from   ww  w  .  j a  v  a2 s.c  o m
}

From source file:ro.zg.scriptdao.core.DbCommandTest.java

public void testDbCommand() throws Exception {
    DefaultCommandManager commandManager = new DefaultCommandManager("TestCommandManager");

    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName("com.mysql.jdbc.Driver");
    bds.setUrl("jdbc:mysql://127.0.0.1:3306/test");
    bds.setUsername("test");
    bds.setPassword("test");

    commandManager.setCommandLoader(new ClasspathCommandLoader(""));
    commandManager.setCommandExecutor(new DbCommandExecutor(bds));
    commandManager.setCommandBuilder(new VelocityCommandBuilder());
    commandManager.load();// www  .  j  a  v a2 s  .co m
    System.out.println(commandManager.getAvailableCommands().length);

    System.out.println("Found " + commandManager.getAvailableCommands().length + " commands.");

    System.out.println("Reloading..");
    commandManager.load();
    System.out.println("After reload " + commandManager.getAvailableCommands().length);

    //      Map args = new HashMap();
    //      args.put("message_id", "3");
    //      args.put("text", "Si mesaju trei... ce fac cu viata mea?");
    //      Object resp = commandManager.executeCommand("InsertIntoMessages", args);
    //      System.out.println(resp);

    //      Map args = new HashMap();
    //      args.put("message_id", 1);
    //      args.put("service","PREPAID.EO310");
    //      args.put("exit_point", "Success");
    //      args.put("input_channel", "SMS");
    //      args.put("output_channel", "SMS");
    //      args.put("order_idx", 1);
    //      args.put("start_date", "2008-04-20");
    //      args.put("end_date", "2008-06-01");
    //      Object resp = commandManager.executeCommand("InsertIntoServicesMessages", args);
    //      System.out.println(resp);

    Map args = new HashMap();
    args.put("service", "PREPAID.EO310");
    args.put("exit_point", "Success");
    args.put("input_channel", "SMS");
    Object resp = commandManager.executeCommand("GetMessagesForService", args);
    System.out.println(resp);
}

From source file:se.unlogic.hierarchy.core.utils.DBCPUtils.java

public static BasicDataSource createConnectionPool(DataSourceDescriptor dataSourceDescriptor) {

    BasicDataSource basicDataSource = new BasicDataSource();

    basicDataSource.setDriverClassName(dataSourceDescriptor.getDriver());
    basicDataSource.setUsername(dataSourceDescriptor.getUsername());
    basicDataSource.setPassword(dataSourceDescriptor.getPassword());
    basicDataSource.setUrl(dataSourceDescriptor.getUrl());
    basicDataSource.setDefaultCatalog(dataSourceDescriptor.getDefaultCatalog());
    basicDataSource.setLogAbandoned(dataSourceDescriptor.logAbandoned());
    basicDataSource.setRemoveAbandoned(dataSourceDescriptor.removeAbandoned());

    if (dataSourceDescriptor.getRemoveTimeout() != null) {
        basicDataSource.setRemoveAbandonedTimeout(dataSourceDescriptor.getRemoveTimeout());
    }/*from  w  w  w .  jav  a 2  s.com*/

    basicDataSource.setTestOnBorrow(dataSourceDescriptor.testOnBorrow());
    basicDataSource.setValidationQuery(dataSourceDescriptor.getValidationQuery());
    basicDataSource.setMaxWait(dataSourceDescriptor.getMaxWait());
    basicDataSource.setMaxActive(dataSourceDescriptor.getMaxActive());
    basicDataSource.setMaxIdle(dataSourceDescriptor.getMaxIdle());
    basicDataSource.setMinIdle(dataSourceDescriptor.getMinIdle());

    return basicDataSource;
}

From source file:seminar.CookeryManagerImplTest.java

private static DataSource prepareDataSource() throws SQLException {
    BasicDataSource ds = new BasicDataSource();
    ds.setUrl("jdbc:derby://localhost:1527/contactDB;create=true");
    return ds;// ww  w . jav  a2 s.c  om
}

From source file:sistema.Conexion.java

private void inicializaDataSource() {

    BasicDataSource basicDataSource = new BasicDataSource();

    basicDataSource.setDriverClassName("org.gjt.mm.mysql.Driver");
    basicDataSource.setUsername(login);/*from w  ww. ja  v a2 s .  c  o m*/
    basicDataSource.setPassword(pass);
    basicDataSource.setUrl(url);
    basicDataSource.setMaxActive(50);

    dataSource = basicDataSource;

}