Example usage for org.apache.commons.dbcp BasicDataSource 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.mskcc.cbio.portal.dao.JdbcUtil.java

private static DataSource initDataSource() {
    DatabaseProperties dbProperties = DatabaseProperties.getInstance();
    String host = dbProperties.getDbHost();
    String userName = dbProperties.getDbUser();
    String password = dbProperties.getDbPassword();
    String database = dbProperties.getDbName();

    String url = "jdbc:mysql://" + host + "/" + database + "?user=" + userName + "&password=" + password
            + "&zeroDateTimeBehavior=convertToNull";

    //  Set up poolable data source
    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUsername(userName);/*from   w w  w  . jav a  2s.  c  o  m*/
    ds.setPassword(password);
    ds.setUrl(url);

    //  By pooling/reusing PreparedStatements, we get a major performance gain
    ds.setPoolPreparedStatements(true);
    ds.setMaxActive(100);

    activeConnectionCount = new HashMap<String, Integer>();

    return ds;
}

---

From source file:org.mskcc.pathdb.sql.JdbcUtil.java

/**
 * Initializes Data Source./*from   w w w  .  j av  a2 s  .c o m*/
 */
private static void initDataSource() {
    PropertyManager manager = PropertyManager.getInstance();
    String host = manager.getProperty(PropertyManager.DB_LOCATION);
    String userName = manager.getProperty(PropertyManager.DB_USER);
    String password = manager.getProperty(PropertyManager.DB_PASSWORD);
    String database = manager.getProperty(CPathConstants.PROPERTY_MYSQL_DATABASE);

    if (database == null) {
        database = CPathConstants.DEFAULT_DB_NAME;
    }
    String url = new String("jdbc:mysql://" + host + "/" + database + "?user=" + userName + "&password="
            + password + "&zeroDateTimeBehavior=convertToNull");

    //  Set up poolable data source
    ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUsername(userName);
    ds.setPassword(password);
    ds.setUrl(url);

    //  By pooling/reusing PreparedStatements, we get a major performance gain
    ds.setPoolPreparedStatements(true);
    ds.setMaxActive(10);
}

---

From source file:org.mzd.shap.sql.FunctionalTable.java

/**
 * @param args/*from   w w w.  j  a v  a 2  s.  c  o m*/
 */
public static void main(String[] args) throws Exception {

    if (args.length != 2) {
        throw new Exception("Usage: [func_cat.txt] [cog-to-cat.txt]");
    }

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUrl("jdbc:mysql://localhost/Dummy");
    ds.setUsername("test");
    ds.setPassword("xeno12");

    Connection conn = ds.getConnection();

    // Get the Sequence ID list.
    PreparedStatement insert = null;
    LineNumberReader reader = null;

    try {
        reader = new LineNumberReader(new FileReader(args[0]));

        insert = conn.prepareStatement("INSERT INTO CogCategories (code,function,class) values (?,?,?)");

        while (true) {
            String line = reader.readLine();
            if (line == null) {
                break;
            }

            String[] fields = line.split("\t");
            if (fields.length != 3) {
                throw new Exception("Bad number of fields [" + fields.length + "] for line [" + line + "]");
            }

            insert.setString(1, fields[0]);
            insert.setString(2, fields[1]);
            insert.setString(3, fields[2]);
            insert.executeUpdate();
        }

        insert.close();

        reader.close();

        reader = new LineNumberReader(new FileReader(args[1]));

        insert = conn.prepareStatement("INSERT INTO CogFunctions (accession,code) values (?,?)");

        while (true) {
            String line = reader.readLine();
            if (line == null) {
                break;
            }

            String[] fields = line.split("\\s+");
            if (fields.length != 2) {
                throw new Exception("Bad number of fields [" + fields.length + "] for line [" + line + "]");
            }

            for (char code : fields[1].toCharArray()) {
                insert.setString(1, fields[0]);
                insert.setString(2, String.valueOf(code));
                insert.executeUpdate();
            }
        }

        insert.close();

    } finally {
        if (reader != null) {
            reader.close();
        }

        conn.close();
        ds.close();
    }
}

---

From source file:org.mzd.shap.sql.UpdateFeatureTable.java

/**
 * @param args//from   w w  w .j av  a2  s.c  o  m
 */
public static void main(String[] args) throws SQLException {

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUrl("jdbc:mysql://localhost/BBay01a");
    ds.setUsername("test");
    ds.setPassword("xeno12");

    Connection conn = ds.getConnection();

    // Get the Sequence ID list.
    PreparedStatement select = null;
    PreparedStatement update = null;
    ResultSet result = null;

    select = conn.prepareStatement("SELECT DISTINCT SEQUENCE_ID FROM Features");
    result = select.executeQuery();
    List<Integer> sequenceIds = new ArrayList<Integer>();
    result.beforeFirst();
    while (result.next()) {
        sequenceIds.add(result.getInt(1));
    }
    result.close();
    select.close();

    // Get the list of Feature IDs for this Sequence ID
    select = conn.prepareStatement("SELECT FEATURE_ID FROM Features WHERE SEQUENCE_ID=? ORDER BY start");

    // Update the idx column for this feature id
    update = conn.prepareStatement("UPDATE Features SET featureOrder=? where FEATURE_ID=?");

    for (Integer seqId : sequenceIds) {
        select.setInt(1, seqId);
        result = select.executeQuery();

        int n = 0;
        result.beforeFirst();
        while (result.next()) {
            int featId = result.getInt(1);
            update.setInt(1, n++);
            update.setInt(2, featId);
            if (update.executeUpdate() != 1) {
                System.out.println("Failed update [" + update.toString() + "]");
                throw new SQLException();
            }
        }
        result.close();
    }

    update.close();
    select.close();

    conn.close();
    ds.close();
}

---

From source file:org.nebula.service.core.DynamicDataSource.java

public void onChange(String dbUrl) {

    logger.info("Change target dbUrl to: " + dbUrl);

    Object oldDataSource = this.datasources.remove(LOOKUP_KEY);

    if (oldDataSource != null) {
        try {/*from  w ww . jav a  2  s .  co  m*/
            ((BasicDataSource) oldDataSource).close();
        } catch (SQLException e) {
            //ignore
        }
    }

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setMaxActive(jdbcMaxActive);
    dataSource.setMaxIdle(jdbcMaxIdle);
    dataSource.setInitialSize(jdbcInitialSize);
    dataSource.setUrl(dbUrl);
    dataSource.setUsername(jdbcUsername);
    dataSource.setPassword(jdbcPassword);
    dataSource.setTestOnBorrow(true);
    dataSource.setValidationQuery("SELECT 1");

    this.datasources.put(LOOKUP_KEY, dataSource);
}

---

From source file:org.nema.medical.mint.server.ServerConfig.java

@Bean(destroyMethod = "close")
public SessionFactory sessionFactory() throws Exception {
    if (sessionFactory == null) {
        final AnnotationSessionFactoryBean annotationSessionFactoryBean = new AnnotationSessionFactoryBean();

        if (StringUtils.isBlank(getConfigString("hibernate.connection.datasource"))) {
            // Not using JNDI data source
            final BasicDataSource dataSource = new BasicDataSource();
            dataSource.setDriverClassName(getConfigString("hibernate.connection.driver_class"));
            String url = getConfigString("hibernate.connection.url");
            url = url.replace("$MINT_HOME", mintHome().getPath());
            dataSource.setUrl(url);/*from  w w w .ja v  a 2s .  co m*/

            dataSource.setUsername(getConfigString("hibernate.connection.username"));
            dataSource.setPassword(getConfigString("hibernate.connection.password"));
            annotationSessionFactoryBean.setDataSource(dataSource);
        } else {
            // Using a JNDI dataSource
            final JndiObjectFactoryBean jndiObjectFactoryBean = new JndiObjectFactoryBean();
            jndiObjectFactoryBean.setExpectedType(DataSource.class);
            jndiObjectFactoryBean.setJndiName(getConfigString("hibernate.connection.datasource"));
            jndiObjectFactoryBean.afterPropertiesSet();
            annotationSessionFactoryBean.setDataSource((DataSource) jndiObjectFactoryBean.getObject());
        }

        final Properties hibernateProperties = new Properties();
        hibernateProperties.put("hibernate.connection.autocommit", Boolean.TRUE);

        final String dialect = getConfigString("hibernate.dialect");
        if (StringUtils.isNotBlank(dialect)) {
            hibernateProperties.put("hibernate.dialect", dialect);
        }

        final String hbm2dll = getConfigString("hibernate.hbm2ddl.auto");
        hibernateProperties.put("hibernate.hbm2ddl.auto", hbm2dll == null ? "verify" : hbm2dll);

        hibernateProperties.put("hibernate.show_sql",
                "true".equalsIgnoreCase(getConfigString("hibernate.show_sql")));

        hibernateProperties.put("hibernate.c3p0.max_statement", 50);
        hibernateProperties.put("hibernate.c3p0.maxPoolSize", 20);
        hibernateProperties.put("hibernate.c3p0.minPoolSize", 5);
        hibernateProperties.put("hibernate.c3p0.testConnectionOnCheckout", Boolean.FALSE);
        hibernateProperties.put("hibernate.c3p0.timeout", 600);
        annotationSessionFactoryBean.setHibernateProperties(hibernateProperties);

        annotationSessionFactoryBean.setPackagesToScan(getPackagesToScan());
        annotationSessionFactoryBean.afterPropertiesSet();

        sessionFactory = annotationSessionFactoryBean.getObject();
    }
    return sessionFactory;
}

---

From source file:org.netxilia.spi.impl.storage.ddl.MockDDLUtils.java

public MockDDLUtils(String forceDbDialect) throws SQLException {
    super(new BasicDataSource(), forceDbDialect);
    reader = new MockDDLReader(getDataSource(), forceDbDialect);
    ISqlDialect dialect = SqlDialectProvider.getSqlDialect(reader.getDbDialect());
    writer = new MockDDLWriter(getDataSource(), dialect);
}

---

From source file:org.ng200.openolympus.Application.java

@Bean
public DataSource dataSource() {
    final BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("org.postgresql.Driver");
    dataSource.setUsername("postgres");
    dataSource.setPassword(this.postgresPassword);
    dataSource.setUrl("jdbc:postgresql://" + this.postgresAddress + "/openolympus");
    return dataSource;
}

---

From source file:org.ngrinder.infra.config.DatabaseConfig.java

/**
 * Create the dataSource based on the database configuration.
 *
 * @return dataSource//  w w w.  j ava 2 s.  co  m
 */
@Bean(name = "dataSource", destroyMethod = "close")
public BasicDataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    PropertiesWrapper databaseProperties = config.getDatabaseProperties();
    Database database = Database.getDatabase(databaseProperties.getProperty(PROP_DATABASE_TYPE));
    database.setup(dataSource, databaseProperties);
    return dataSource;
}

---

From source file:org.nimbustools.messaging.gt4_0_elastic.v2008_05_05.general.defaults.DefaultElasticPersistence.java

public DefaultElasticPersistence(Resource dbResource) throws IOException {
    if (dbResource == null) {
        throw new IllegalArgumentException("diskStoreResource may not be null");
    }//from   w w  w  .ja va2 s.  c  om

    final String dbPath = dbResource.getFile().getAbsolutePath();

    //don't know how to feed this in with Spring and still have it fixup the
    // $NIMBUS_HOME in path
    final BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("org.sqlite.JDBC");
    ds.setUrl("jdbc:sqlite://" + dbPath);

    this.dataSource = ds;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »