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:com.zettsy.serverping.dao.PingDataImpl.java

@Override
@Transactional/*  w  ww .j  ava 2  s  .  c  o m*/
public SessionFactory addDataBase(String sid, HashMap myMap) {

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/" + "hrdtechn_" + sid);
    dataSource.setUsername("hrdtechn_javaapp");
    dataSource.setPassword("root123");

    LocalSessionFactoryBuilder sessionBuilder = new LocalSessionFactoryBuilder(dataSource);
    sessionBuilder.addProperties(applicationContextConfig.getHibernateProperties());
    sessionBuilder.addAnnotatedClasses(PingData.class);
    SessionFactory sessionFactory = sessionBuilder.buildSessionFactory();

    myMap.put(sid, sessionFactory);

    return sessionFactory;
}

From source file:cz.muni.fi.pv168.project.hotelmanager.RoomManagerImplTest.java

@Before
public void setUp() throws SQLException {

    BasicDataSource bds = new BasicDataSource();
    //set JDBC driver and URL
    bds.setDriverClassName(EmbeddedDriver.class.getName());
    bds.setUrl("jdbc:derby:memory:TestRoomManagerDB;create=true");
    //populate db with tables and data
    new ResourceDatabasePopulator(new ClassPathResource("schema-javadb.sql")).execute(bds);
    this.dataSource = bds;
    manager = new RoomManagerImpl(bds);

}

From source file:ApplicationContextConfig.java

@Bean
public DataSource getDataSource() {
    BasicDataSource basicDataSource = new BasicDataSource();
    basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    basicDataSource.setUrl("jdbc:mysql://localhost:3306/raphael");
    basicDataSource.setUsername("root");
    basicDataSource.setPassword("root");
    return basicDataSource;
}

From source file:com.peertopark.spring.data.SpringDataConfig.java

@Bean
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUrl(dataSourceConfig.getJDBCUrl());
    dataSource.setUsername(dataSourceConfig.getJDBCUser());
    dataSource.setPassword(dataSourceConfig.getJDBCPassword());
    dataSource.setDriverClassName(dataSourceConfig.getJDBCDriver());
    dataSource.setMaxTotal(dataSourceConfig.getMaxConnections());
    return dataSource;
}

From source file:com.magnet.mmx.server.plugin.mmxmgmt.interceptor.MessageDistributorImplTest.java

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

    Properties testProperties = new Properties();
    testProperties.load(inputStream);/*  w ww. j  a  v a  2s  . co  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);
    {
        InputStream xmlInput = DeviceDAOImplTest.class.getResourceAsStream("/data/app-data-1.xml");
        IDataSet dataSet = builder.build(xmlInput);
        DatabaseOperation.CLEAN_INSERT.execute(con, dataSet);
    }
    {
        InputStream xmlInput = DeviceDAOImplTest.class.getResourceAsStream("/data/device-data-1.xml");
        IDataSet dataSet = builder.build(xmlInput);
        DatabaseOperation.CLEAN_INSERT.execute(con, dataSet);
    }
}

From source file:com.magnet.mmx.server.plugin.mmxmgmt.util.TestOpenfireConnectionProvider.java

public TestOpenfireConnectionProvider() throws Exception {
    InputStream inputStream = MMXTopicTagsResourceTest.class.getResourceAsStream("/test.properties");

    Properties testProperties = new Properties();
    testProperties.load(inputStream);//from w w  w .j av a 2 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);
}

From source file:hu.fnf.devel.wishbox.persistence.ConfigData.java

@Bean(destroyMethod = "close")
public DataSource dataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://sql01x/wishbox");
    dataSource.setUsername(System.getProperty("SQLUser"));
    dataSource.setPassword(System.getProperty("SQLPass"));
    return dataSource;
}

From source file:com.bc.fiduceo.db.DatabaseConfig.java

public BasicDataSource getDataSource() {
    if (properties.isEmpty()) {
        throw new RuntimeException("database.properties not loaded");
    }/*from   w  w  w .j ava 2s . com*/

    final BasicDataSource dataSource = new BasicDataSource();

    dataSource.setDriverClassName(properties.getProperty("driverClassName"));
    dataSource.setUrl(properties.getProperty("url"));
    dataSource.setUsername(properties.getProperty("username"));
    dataSource.setPassword(properties.getProperty("password"));

    return dataSource;
}

From source file:com.bc.fiduceo.db.StorageTest.java

@Test
public void testInitWithUnregisteredDriverUrlThrows() throws SQLException {
    final BasicDataSource weirdDataSource = new BasicDataSource();
    weirdDataSource.setUrl("stupid:unregistered:data_base:driver");

    try {/*from   www. j a va 2 s  .c om*/
        Storage.create(weirdDataSource, geometryFactory);
        fail("IllegalArgumentException expected");
    } catch (IllegalArgumentException expected) {
    }
}

From source file:com.magnet.mmx.server.plugin.mmxmgmt.wakeup.WakeupProcessorTest.java

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

    Properties testProperties = new Properties();
    testProperties.load(inputStream);//from w  w w. j  a 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);
    {
        InputStream xmlInput = DeviceDAOImplTest.class.getResourceAsStream("/data/wakeup-queue-1.xml");
        IDataSet dataSet = builder.build(xmlInput);
        DatabaseOperation.CLEAN_INSERT.execute(con, dataSet);
    }
    {
        InputStream xmlInput = DeviceDAOImplTest.class.getResourceAsStream("/data/message-data-1.xml");
        IDataSet dataSet = builder.build(xmlInput);
        DatabaseOperation.CLEAN_INSERT.execute(con, dataSet);
    }
}