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:io.druid.server.namespace.cache.JDBCExtractionNamespaceTest.java

@BeforeClass
public static final void createTables() {
    final BasicDataSource datasource = new BasicDataSource();
    datasource.setUrl(connectionURI);// w w  w  .  jav  a2  s. c  o m
    datasource.setDriverClassLoader(JDBCExtractionNamespaceTest.class.getClassLoader());
    datasource.setDriverClassName("org.apache.derby.jdbc.EmbeddedDriver");
    dbi = new DBI(datasource);
    dbi.withHandle(new HandleCallback<Void>() {
        @Override
        public Void withHandle(Handle handle) throws Exception {
            handle.createStatement(
                    String.format("CREATE TABLE %s (%s TIMESTAMP, %s VARCHAR(64), %s VARCHAR(64))", tableName,
                            tsColumn_, keyName, valName))
                    .execute();
            return null;
        }
    });
}

---

From source file:com.magnet.mmx.server.plugin.mmxmgmt.db.MessageDAOImplSearchTest.java

@BeforeClass
public static void setup() throws Exception {
    InputStream inputStream = DeviceDAOImplTest.class.getResourceAsStream("/test.properties");

    Properties testProperties = new Properties();
    testProperties.load(inputStream);/*from ww  w.  ja v a  2  s.  c o  m*/

    String host = testProperties.getProperty("db.host");
    String port = testProperties.getProperty("db.port");
    String user = testProperties.getProperty("db.user");
    String password = testProperties.getProperty("db.password");
    String driver = testProperties.getProperty("db.driver");
    String schema = testProperties.getProperty("db.schema");

    String url = "jdbc:mysql://" + host + ":" + port + "/" + schema;

    ds = new BasicDataSource();
    ds.setDriverClassName(driver);
    ds.setUsername(user);
    ds.setPassword(password);
    ds.setUrl(url);
    //clean any existing records and load some records into the database.
    FlatXmlDataSetBuilder builder = new FlatXmlDataSetBuilder();
    builder.setColumnSensing(true);
    Connection setup = ds.getConnection();
    IDatabaseConnection con = new DatabaseConnection(setup);
    DatabaseConfig dbConfig = con.getConfig();
    dbConfig.setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY,
            new MessageDAOImplTest.CustomDataTypeFactory());
    {
        InputStream xmlInput = DeviceDAOImplTest.class.getResourceAsStream("/data/message-data-1.xml");
        IDataSet dataSet = builder.build(xmlInput);
        DatabaseOperation.CLEAN_INSERT.execute(con, dataSet);
    }
    {
        InputStream xmlInput = DeviceDAOImplTest.class.getResourceAsStream("/data/wakeup-queue-1.xml");
        IDataSet dataSet = builder.build(xmlInput);
        DatabaseOperation.CLEAN_INSERT.execute(con, dataSet);
    }
}

---

From source file:guiPackage.AllAccomComboBoxModel.java

@Override
public Object getElementAt(int index) {
    BasicDataSource mySource = new BasicDataSource();
    mySource.setUrl(ResourceBundle.getBundle("databaseConnection").getString("connection"));
    mySource.setUsername(ResourceBundle.getBundle("databaseConnection").getString("username"));
    mySource.setPassword(ResourceBundle.getBundle("databaseConnection").getString("password"));

    GuestManager guestMngr = new GuestManagerImpl(mySource);
    RoomManager roomMngr = new RoomManagerImpl(mySource);
    return (String) (myValues.get(index).getAccomId() + ": "
            + guestMngr.getGuest(myValues.get(index).getGuestId()).getName() + ", "
            + roomMngr.getRoom(myValues.get(index).getRoomId()).getRoomNumber() + " ("
            + myValues.get(index).getStartDate() + " - " + myValues.get(index).getEndDate() + ")");
}

---

From source file:com.magnet.mmx.server.plugin.mmxmgmt.db.TopicItemDAOImplTest.java

@BeforeClass
public static void setupDatabase() throws Exception {
    InputStream inputStream = DeviceDAOImplTest.class.getResourceAsStream("/test.properties");

    Properties testProperties = new Properties();
    testProperties.load(inputStream);/*from w ww  .  ja va  2 s  .  c  o m*/

    String host = testProperties.getProperty("db.host");
    String port = testProperties.getProperty("db.port");
    String user = testProperties.getProperty("db.user");
    String password = testProperties.getProperty("db.password");
    String driver = testProperties.getProperty("db.driver");
    String schema = testProperties.getProperty("db.schema");

    String url = "jdbc:mysql://" + host + ":" + port + "/" + schema;

    ds = new BasicDataSource();
    ds.setDriverClassName(driver);
    ds.setUsername(user);
    ds.setPassword(password);
    ds.setUrl(url);

    DBTestUtil.setBasicDataSource(ds);
    generatePubsubItems();
}

---

From source file:adept.kbapi.sql.QuickJDBC.java

/**
 * initialize connection pool. This connection pool is to be used by the
 * entire KB setup.//from   ww w .  jav a 2  s .  co  m
 * 
 * @throws KBConfigurationException
 */
private void initialize(KBParameters kbParameters) throws KBConfigurationException {
    if (kbParameters.metadataUrl.trim().equals("")) {
        throw new KBConfigurationException("No metadata URL in KBParameters.");
    }
    connectionPool = new BasicDataSource();
    connectionPool.setUrl(kbParameters.metadataUrl);
    connectionPool.setUsername(kbParameters.metadataUsername);
    connectionPool.setPassword(kbParameters.metadataPassword);
    connectionPool.setDriverClassName("org.postgresql.Driver");
    connectionPool.setInitialSize(3);
    connectionPool.setDefaultAutoCommit(false);
    connectionPool.setMaxTotal(MAX_ACTIVE_CONNECTIONS);
    connectionPool.setMaxIdle(MAX_IDLE_CONNECTIONS);
    connectionPool.setRemoveAbandonedTimeout(REMOVE_ABANDONED_TIMEOUT);
    connectionPool.setRemoveAbandonedOnBorrow(true);
    connectionPool.setRemoveAbandonedOnMaintenance(true);
}

---

From source file:com.dsf.dbxtract.cdc.AppJournalDeleteTest.java

/**
 * Rigourous Test :-)// w w  w  . java 2  s.co m
 * 
 * @throws Exception
 *             in case of any error
 */
@Test(timeOut = 120000)
public void testAppWithJournalDelete() throws Exception {

    final Config config = new Config(configFile);

    BasicDataSource ds = new BasicDataSource();
    Source source = config.getDataSources().getSources().get(0);
    ds.setDriverClassName(source.getDriver());
    ds.setUsername(source.getUser());
    ds.setPassword(source.getPassword());
    ds.setUrl(source.getConnection());

    // prepara os dados
    Connection conn = ds.getConnection();

    conn.createStatement().execute("truncate table test");
    conn.createStatement().execute("truncate table j$test");

    // Carrega os dados de origem
    PreparedStatement ps = conn.prepareStatement("insert into test (key1,key2,data) values (?,?,?)");
    for (int i = 0; i < TEST_SIZE; i++) {
        if ((i % 100) == 0) {
            ps.executeBatch();
        }
        ps.setInt(1, i);
        ps.setInt(2, i);
        ps.setInt(3, (int) Math.random() * 500);
        ps.addBatch();
    }
    ps.executeBatch();
    ps.close();

    app = new App(config);
    app.start();

    Assert.assertEquals(config.getHandlers().iterator().next().getStrategy(), JournalStrategy.DELETE);

    // Popula as tabelas de journal
    ps = conn.prepareStatement("insert into j$test (key1,key2) values (?,?)");
    for (int i = 0; i < TEST_SIZE; i++) {
        if ((i % 500) == 0) {
            ps.executeBatch();
        }
        ps.setInt(1, i);
        ps.setInt(2, i);
        ps.addBatch();
    }
    ps.executeBatch();
    ps.close();

    while (true) {
        TimeUnit.MILLISECONDS.sleep(500);

        ResultSet rs = conn.createStatement().executeQuery("select count(*) from j$test");
        if (rs.next()) {
            long count = rs.getLong(1);
            System.out.println("remaining journal rows: " + count);
            rs.close();
            if (count == 0L)
                break;
        }
    }
    conn.close();
    ds.close();
}

---

From source file:com.magnet.mmx.server.plugin.mmxmgmt.api.MMXVersionResourceTest.java

@BeforeClass
public static void setupDatabase() throws Exception {
    java.util.logging.Logger.getLogger("com.google.inject").setLevel(java.util.logging.Level.SEVERE);
    org.apache.log4j.Logger.getLogger("org.apache.http").setLevel(org.apache.log4j.Level.DEBUG);
    org.apache.log4j.Logger.getLogger("org.jboss.resteasy").setLevel(Level.OFF);
    InputStream inputStream = MMXTopicTagsResourceTest.class.getResourceAsStream("/test.properties");

    Properties testProperties = new Properties();
    testProperties.load(inputStream);// w  w w .  ja  v a2 s .  c om

    String host = testProperties.getProperty("db.host");
    String port = testProperties.getProperty("db.port");
    String user = testProperties.getProperty("db.user");
    String password = testProperties.getProperty("db.password");
    String driver = testProperties.getProperty("db.driver");
    String schema = testProperties.getProperty("db.schema");

    String url = "jdbc:mysql://" + host + ":" + port + "/" + schema;

    ds = new BasicDataSource();
    ds.setDriverClassName(driver);
    ds.setUsername(user);
    ds.setPassword(password);
    ds.setUrl(url);

    DBTestUtil.setBasicDataSource(ds);
    new MockUp<AppDAOImpl>() {
        @Mock
        protected String getEncrypted(String value) {
            return value;
        }
    };
    DBTestUtil.setupMockDBUtil();
    appEntity = createRandomApp();
    LOGGER.warn("Finished setupDatabase");
}

---

From source file:com.twosigma.beaker.sql.JDBCClient.java

public BasicDataSource getDataSource(String uri) throws DBConnectionException {
    synchronized (this) {
        try {/*from  ww  w  .j a va  2  s.c o  m*/

            BasicDataSource ds = dsMap.get(uri);
            if (ds == null) {
                Driver driver = null;
                for (Driver test : drivers) {
                    if (test.acceptsURL(uri)) {
                        driver = test;
                        break;
                    }
                }
                if (driver == null) {
                    DriverManager.getDriver(uri);
                }
                ds = new BasicDataSource();
                ds.setDriver(driver);
                ds.setUrl(uri);
                dsMap.put(uri, ds);
            }
            return ds;

        } catch (SQLException e) {
            //Logger.getLogger(JDBCClient.class.getName()).log(Level.SEVERE, null, e);
            throw new DBConnectionException(uri, e);
        }
    }
}

---

From source file:net.cloudkit.enterprises.infrastructure.configuration.ApplicationConfiguration.java

@Bean(initMethod = "init", destroyMethod = "close")
public DataSource dataSource() {
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName(driverClassName);
    basicDataSource.setUrl(url);//  w  ww. ja v a2s .c  o m
    basicDataSource.setUsername(username);
    basicDataSource.setPassword(password);
    basicDataSource.setDefaultAutoCommit(false);
    return basicDataSource;
}

---

From source file:de.anycook.db.mysql.DBHandler.java

private static BasicDataSource setupDataSource(String server, int port, String dbName, String username,
        String password, int maxActive, int maxIdle) {
    Preconditions.checkNotNull(server);/*  w  w  w.  j  av a  2 s  .  com*/
    Preconditions.checkNotNull(dbName);
    Preconditions.checkNotNull(username);

    BasicDataSource ds = new BasicDataSource();
    ds.setDriverClassName("com.mysql.jdbc.Driver");
    ds.setUsername(username);

    if (password.length() > 0) {
        ds.setPassword(password);
    }

    String url = String.format("jdbc:mysql://%s:%d/%s?useConfigs=maxPerformance&useCompression=true", server,
            port, dbName);
    ds.setUrl(url);
    ds.setValidationQuery("SELECT 1;");
    ds.setTestWhileIdle(true);
    ds.setTestOnReturn(true);
    ds.setMaxTotal(maxActive);
    ds.setMaxIdle(maxIdle);
    ds.setRemoveAbandonedOnBorrow(true);
    ds.setRemoveAbandonedTimeout(60);

    if (Configuration.getInstance().isDeveloperMode()) {
        ds.setLogAbandoned(true);
    }

    sLogger.info("created new Connectionpool");
    return ds;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• »