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:org.devproof.portal.test.JettyStart.java

public static void main(final String[] args) throws Exception {
    if (args.length != 5) {
        System.out.println("JettyStart <DbUser/Pass/Schema> <httpport> <smtphost> <smtpuser> <smtppass>");
        return;/*from  w  ww  . ja v  a 2 s . c  om*/
    }
    Server server = new Server();
    SocketConnector connector = new SocketConnector();
    // Set some timeout options to make debugging easier.
    connector.setMaxIdleTime(1000 * 60 * 60);
    connector.setSoLingerTime(-1);
    connector.setPort(Integer.valueOf(args[1]));
    server.setConnectors(new Connector[] { connector });

    WebAppContext bb = new WebAppContext();
    bb.setServer(server);
    bb.setContextPath("/");
    bb.setWar(System.getProperty("java.io.tmpdir"));
    bb.addEventListener(new PortalContextLoaderListener());
    FilterHolder filter = new FilterHolder();
    filter.setInitParameter("applicationClassName", PortalApplication.class.getName());
    // servlet.setInitParameter("configuration", "deployment");
    filter.setClassName(WicketFilter.class.getName());
    filter.setName(WicketFilter.class.getName());
    bb.addFilter(filter, "/*", 1);
    server.addHandler(bb);

    BasicDataSource datasource = new BasicDataSource();
    datasource.setUrl("jdbc:mysql://localhost/" + args[0]);
    datasource.setUsername(args[0]);
    datasource.setPassword(args[0]);
    datasource.setDriverClassName(Driver.class.getName());
    new Resource(CommonConstants.JNDI_DATASOURCE, datasource);

    Properties props = System.getProperties();
    props.put("mail.smtp.host", args[2]);
    props.put("mail.smtp.auth", "true");
    props.put("mail.transport.protocol", "smtp");
    props.put("mail.smtp.port", "25");
    props.put("mail.smtp.starttls.enable", "true");
    props.put("mail.debug", "true");

    Authenticator auth = new Authenticator() {
        @Override
        protected PasswordAuthentication getPasswordAuthentication() {
            return new PasswordAuthentication(args[3], args[4]);
        }
    };

    Session mailSession = Session.getDefaultInstance(props, auth);
    new Resource(CommonConstants.JNDI_MAIL_SESSION, mailSession);
    new Resource(CommonConstants.JNDI_PROP_EMAIL_DISABLED, "true");
    // START JMX SERVER
    MBeanServer mBeanServer = ManagementFactory.getPlatformMBeanServer();
    MBeanContainer mBeanContainer = new MBeanContainer(mBeanServer);
    server.getContainer().addEventListener(mBeanContainer);
    mBeanContainer.start();
    try {
        System.out.println(">>> STARTING DEVPROOF PORTAL, PRESS ANY KEY TO STOP");
        server.start();
        while (System.in.available() == 0) {
            Thread.sleep(5000);
        }
        server.stop();
        server.join();
    } catch (Exception e) {
        e.printStackTrace();
        System.exit(100);
    }
}

From source file:org.docksidestage.dockside.JdbcBeansJavaConfig.java

@Bean(name = "dataSource")
public DataSource createDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.h2.Driver");
    ds.setUrl(maihamaDbUrl);/*from w w w.j a  v  a2 s.co  m*/
    ds.setUsername("sa");
    ds.setPassword("");
    ds.setMaxActive(20);
    return ds;
}

From source file:org.docksidestage.oracle.JdbcBeansJavaConfig.java

@Bean(name = "dataSource")
public DataSource createDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
    ds.setUrl(JdbcDiconResolver.resolveUrl("jdbc:oracle:thin:@localhost:1521:XE"));
    ds.setUsername("maihamadb");
    ds.setPassword("maihamadb");
    ds.setMaxActive(20);// w w w.  ja  va2 s  . co  m
    return ds;
}

From source file:org.docksidestage.oracle.JdbcBeansResolaJavaConfig.java

@Bean(name = "resolaDataSource")
public DataSource createDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
    ds.setUrl(JdbcDiconResolver.resolveUrl("jdbc:oracle:thin:@localhost:1521:XE"));
    ds.setUsername("resortlinedb");
    ds.setPassword("resortlinedb");
    ds.setMaxActive(20);/*from   w w w .  jav  a 2 s  .  c  o  m*/
    return ds;
}

From source file:org.duracloud.mill.credentials.impl.CredentialsRepoConfig.java

@Bean(name = CREDENTIALS_REPO_DATA_SOURCE_BEAN, destroyMethod = "close")
public BasicDataSource credentialsRepoDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl(MessageFormat.format("jdbc:mysql://{0}:{1}/{2}?autoReconnect=true",
            System.getProperty(ConfigConstants.MC_DB_HOST, "localhost"),
            System.getProperty(ConfigConstants.MC_DB_PORT, "3306"),
            System.getProperty(ConfigConstants.MC_DB_NAME, "mill")));
    dataSource.setUsername(System.getProperty(ConfigConstants.MC_DB_USER, "mill"));
    dataSource.setPassword(System.getProperty(ConfigConstants.MC_DB_PASS, "password"));
    return dataSource;
}

From source file:org.eclipse.data.sampledb.SampledbActivator.java

private DataSource getDataSource() {
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(DERBY_DRIVER_CLASS);
    ds.setUsername(SAMPLE_DB_SCHEMA);/*from  w ww. j  a  v  a 2  s.  c o  m*/
    ds.setPassword(EMPTY_VALUE);
    ds.setUrl(getDBUrl());
    return ds;
}

From source file:org.eclipse.dirigible.repository.datasource.DataSourceFacade.java

private DataSource createDirectDataSource(Properties properties) {
    String id = properties.getProperty(DataSourceFacade.PARAM_DB_ID);
    String name = properties.getProperty(DataSourceFacade.PARAM_DB_NAME);
    String url = properties.getProperty(DataSourceFacade.PARAM_DB_LOC);
    String driver = properties.getProperty(DataSourceFacade.PARAM_DB_DRIVER);
    String user = properties.getProperty(DataSourceFacade.PARAM_DB_USER);
    String password = properties.getProperty(DataSourceFacade.PARAM_DB_PASSWORD);
    String defaultAutoCommit = properties.getProperty(DataSourceFacade.PARAM_DB_AUTO_COMMIT);
    String maxActive = properties.getProperty(DataSourceFacade.PARAM_DB_AUTO_MAX_ACTIVE);
    String maxIdle = properties.getProperty(DataSourceFacade.PARAM_DB_AUTO_MAX_IDLE);
    String maxWait = properties.getProperty(DataSourceFacade.PARAM_DB_AUTO_MAX_WAIT);

    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName(driver);
    basicDataSource.setUrl(url);//from   ww  w  . ja v  a2  s . c o m
    basicDataSource.setUsername(user);
    basicDataSource.setPassword(password);
    basicDataSource.setDefaultAutoCommit(Boolean.parseBoolean(defaultAutoCommit));
    basicDataSource.setMaxActive(maxActive != null ? Integer.parseInt(maxActive) : 100);
    basicDataSource.setMaxIdle(maxIdle != null ? Integer.parseInt(maxIdle) : 30);
    basicDataSource.setMaxWait(maxWait != null ? Integer.parseInt(maxWait) : 10000);

    return basicDataSource;

}

From source file:org.encuestame.test.persistence.config.DBTestConfig.java

@Bean(name = "jdbcDataSource")
public BasicDataSource jdbcDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(EnMePlaceHolderConfigurer.getProperty("datasource.classname"));
    dataSource.setUrl(EnMePlaceHolderConfigurer.getProperty("datasource.urldb"));
    dataSource.setUsername(EnMePlaceHolderConfigurer.getProperty("datasource.userbd"));
    dataSource.setPassword(EnMePlaceHolderConfigurer.getProperty("datasource.pass"));
    return dataSource;
}

From source file:org.eobjects.analyzer.connection.JdbcDatastore.java

public DataSource createDataSource() {
    initializeDriver();//from  ww w  . j  a va2  s .  co m

    BasicDataSource ds = new BasicDataSource();
    ds.setMaxActive(-1);
    ds.setDefaultAutoCommit(false);
    ds.setUrl(_jdbcUrl);

    if (_username != null && _password != null) {
        ds.setUsername(_username);
        ds.setPassword(_password);
    }
    return ds;
}

From source file:org.fao.geonet.arcgis.ArcSDEJdbcConnection.java

/**
 *
 *
 * @param connectionString An example of server string in case of Oracle
 *                         is: "jdbc:oracle:thin:@84.123.79.19:1521:orcl".
 * @param username the username to connect to the database.
 * @param password the password to connect to the database.
 *///w  ww .  j ava 2s . c om
public ArcSDEJdbcConnection(String driverName, String connectionString, String username, String password) {

    try {
        Log.debug(ARCSDE_LOG_MODULE_NAME, "Getting ArcSDE connection (via JDBC)");

        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName(driverName);
        dataSource.setUrl(connectionString);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        // Test the connection config getting a connection and closing it.
        dataSource.getConnection().close();

        jdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
    } catch (SQLException x) {
        Log.error(ARCSDE_LOG_MODULE_NAME, "Error getting ArcSDE connection (via JDBC)", x);

        throw new ExceptionInInitializerError(new ArcSDEConnectionException(
                "Exception in ArcSDEConnection using JDBC: can not connect to the database", x));
    }
}