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

Introduction

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

Prototype

BasicDataSource

Source Link

Usage

From source file:science.freeabyss.hulk.jdbc.dbcp.BasicDataSourceExample.java

private static void initDataSource() {
    dataSource = new BasicDataSource();
    dataSource.setDriverClassName(PropertiesUtil.getString("jdbc.driver"));
    dataSource.setUrl(PropertiesUtil.getString("jdbc.url"));
    dataSource.setUsername(PropertiesUtil.getString("jdbc.username"));
    dataSource.setPassword(PropertiesUtil.getString("jdbc.password"));
}

From source file:tilda.db.ConnectionPool.java

public static void init(String Id, String Driver, String DB, String User, String Pswd, int InitialSize,
        int MaxSize) {
    if (_DataSourcesById.get(Id) == null)
        synchronized (_DataSourcesById) {
            if (_DataSourcesById.get(Id) == null) // Definitely no connection pool by that name
            {/*ww w. jav  a  2 s .c  o m*/
                String Sig = DB + "``" + User;
                BasicDataSource BDS = _DataSourcesBySig.get(Sig); // Let's see if that DB definition is already there
                if (BDS == null) {
                    LOG.info("Initializing a fresh pool for Id=" + Id + ", DB=" + DB + ", User=" + User
                            + ", and Pswd=Shhhhhhh!");
                    BDS = new BasicDataSource();
                    BDS.setDriverClassName(Driver);
                    BDS.setUrl(DB);
                    if (TextUtil.isNullOrEmpty(Pswd) == false && TextUtil.isNullOrEmpty(User) == false) {
                        BDS.setUsername(User);
                        BDS.setPassword(Pswd);
                    }
                    BDS.setInitialSize(InitialSize);
                    BDS.setMaxTotal(MaxSize);
                    BDS.setDefaultAutoCommit(false);
                    BDS.setDefaultTransactionIsolation(java.sql.Connection.TRANSACTION_READ_COMMITTED);
                    BDS.setDefaultQueryTimeout(20000);
                    _DataSourcesBySig.put(Sig, BDS);
                } else {
                    LOG.info("Merging pool with ID " + Id + " into prexisting pool " + Sig);
                    if (BDS.getInitialSize() < InitialSize)
                        BDS.setInitialSize(InitialSize);
                    if (BDS.getMaxTotal() < MaxSize)
                        BDS.setMaxTotal(MaxSize);

                }
                _DataSourcesById.put(Id, BDS);
            }
        }
}

From source file:uk.co.platosys.db.jdbc.ConnectionBroker.java

private void init() {

    List<DatabaseCredentials> databases = properties.getDatabases();
    for (DatabaseCredentials credentials : databases) {

        String name = "";
        String driver = "";
        String userName = "";
        String password = "";
        String url = "";
        try {//from   w  w w.j a v a  2 s. c  om
            name = credentials.getName();
            logger.log("ConnectionBroker initialising database " + name);
            driver = credentials.getDriver();
            url = credentials.getUrl();
            userName = credentials.getUsername();
            password = credentials.getPassword();
            logger.log("ConnectionBroker credentials for " + name + " are " + driver + " " + url + " "
                    + userName + " " + password);

        } catch (Exception e) {
            logger.log("ConnectionBroker had a problem getting credentials for " + name, e);
        }
        /* try{
            //although we only use postgresql, there's no reason we couldn't use a different sql rdbms with a different driver for each
            //database.
        Class.forName(driver);
         }catch(ClassNotFoundException e){
        logger.log("ConnectionBroker couldn't load database driver", e);
         }*/
        try {
            /*connFac = new DriverManagerConnectionFactory(url, userName, password);
            PoolableConnectionFactory poolableConFac = new PoolableConnectionFactory(connFac, null);
            GenericObjectPool<PoolableConnection> connectionPool = new GenericObjectPool<PoolableConnection>(poolableConFac);
            pools.put(name, connectionPool);
            poolableConFac.setPool(connectionPool);
            PoolingDataSource<PoolableConnection> dataSource = new PoolingDataSource<PoolableConnection>(connectionPool);*/
            BasicDataSource dataSource = new BasicDataSource();
            dataSource.setDriverClassName(driver);
            dataSource.setUsername(userName);
            dataSource.setPassword(password);
            dataSource.setUrl(url);
            dataSource.setMinIdle(2);
            dataSource.setMaxTotal(MAX_ACTIVE);
            logger.log(5, "ConnectionBroker has made BasicDataSource " + dataSource.toString());
            logger.log("Datasource " + name + " has " + dataSource.getMaxTotal() + " maxConnections");
            try {
                Connection connection = dataSource.getConnection();
                connection.close();
                dataSources.put(name, dataSource);
                dataSet.add(dataSource);
                logger.log(5, "ConnectionBroker has initialised database " + name);
            } catch (PSQLException psqe) {
                logger.log("could not make a test connection to database: " + name, psqe);
            }
        } catch (Exception e) {
            logger.log("ConnectionBroker had a problem configuring the pool with " + name, e);
        }
    }
    done = true;
}

From source file:uk.org.linuxgrotto.config.JpaConfiguration.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(environment.getProperty("jdbc.driverClassName"));
    dataSource.setUrl(environment.getProperty("jdbc.url"));
    dataSource.setUsername(environment.getProperty("jdbc.username"));
    dataSource.setPassword(environment.getProperty("jdbc.password"));

    return dataSource;
}

From source file:ws.rocket.sqlstore.test.SqlStoreTest.java

@BeforeClass
public void setUp() throws SQLException, IOException {
    ResourceBundle bundle = ResourceBundle.getBundle("ws.rocket.sqlstore.test.test");

    File dbPath = new File(bundle.getString("jdbc.dbPath"));
    if (!dbPath.exists()) {
        dbPath.mkdirs();// w ww  . j  av a 2 s  .c o m
    }

    System.setProperty("derby.system.home", dbPath.getCanonicalPath());

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName(bundle.getString("jdbc.driver"));
    ds.setUrl(bundle.getString("jdbc.url"));
    ds.setDefaultReadOnly(true);
    ds.setDefaultAutoCommit(false);
    ds.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
    ds.setInitialSize(Integer.parseInt(bundle.getString("jdbc.initialConnections")));

    this.dataSource = ds;

    boolean tableExists;
    try (Connection c = this.dataSource.getConnection()) {
        DatabaseMetaData meta = c.getMetaData();
        try (ResultSet rs = meta.getTables(null, "SQLSTORE", "PERSON", new String[] { "TABLE" })) {
            tableExists = rs.next();
        }
    }

    if (tableExists) {
        dropTables();
    }
}

From source file:xml.cz.Parser.java

/**
 * Main class in which all data are parsed
 * @param args arguments on main class - not supported
 * @throws IOException/*from ww w .j  a  va  2  s  .c om*/
 * @throws SQLException
 * @throws SAXException
 * @throws ParserConfigurationException 
 */
public static void main(String[] args)
        throws IOException, SQLException, SAXException, ParserConfigurationException {
    Properties pro = new Properties();
    pro.load(new FileInputStream("src/main/java/configuration/jdbc.properties"));

    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(pro.getProperty("url"));
    ds.setUsername(pro.getProperty("username"));
    ds.setPassword(pro.getProperty("password"));

    SectorManagerImpl sectorManager = new SectorManagerImpl();
    sectorManager.setDataSource(ds);
    ClassificationManagerImpl classificationManager = new ClassificationManagerImpl();
    classificationManager.setDataSource(ds);
    RegionManagerImpl regionManager = new RegionManagerImpl();
    regionManager.setDataSource(ds);

    Parser parser = new Parser();
    parser.parseSector(sectorManager);
    parser.parseClassification(classificationManager);
    parser.parseRegion(regionManager);

    ds.close();
}

From source file:xml.sk.Parser.java

public static void main(String[] args) throws IOException, SQLException, ParserConfigurationException,
        SAXException, XPathExpressionException, ParseException {
    Properties pro = new Properties();
    pro.load(new FileInputStream("src/main/java/configuration/jdbc.properties"));

    BasicDataSource ds = new BasicDataSource();
    ds.setUrl(pro.getProperty("url"));
    ds.setUsername(pro.getProperty("username"));
    ds.setPassword(pro.getProperty("password"));

    SectorManagerImpl sectorManager = new SectorManagerImpl();
    sectorManager.setDataSource(ds);//from   ww w .ja va 2s.c  o  m
    ClassificationManagerImpl classificationManager = new ClassificationManagerImpl();
    classificationManager.setDataSource(ds);
    EducationManagerImpl educationManager = new EducationManagerImpl();
    educationManager.setDataSource(ds);
    AgeManagerImpl ageManager = new AgeManagerImpl();
    ageManager.setDataSource(ds);

    Parser parser = new Parser();
    parser.parseSectorSk(sectorManager);
    parser.parseClassificationSk(classificationManager);
    parser.parseEducationSk(educationManager);
    parser.parseAgeSk(ageManager);

    ds.close();
}