Example usage for org.springframework.jdbc.datasource DriverManagerDataSource DriverManagerDataSource

Introduction

In this page you can find the example usage for org.springframework.jdbc.datasource DriverManagerDataSource DriverManagerDataSource.

Prototype

public DriverManagerDataSource()

Source Link

Document

Constructor for bean-style configuration.

Usage

From source file:se.kth.csc.config.SettingsDataSourceConfig.java

@Bean
@Override/*from  ww w. j a  va2  s.  c  o  m*/
public DataSource dataSource() {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();

    dataSource.setDriverClassName(driver);
    dataSource.setUrl(url);
    dataSource.setUsername(username);
    dataSource.setPassword(password);

    log.info("Creating data source with JDBC driver {}, connecting to {} as user {}", driver, url, username);
    return dataSource;
}

From source file:com.github.fedorchuck.webstore.dao.impl.postgresql.JdbcCommodityRepositoryTest.java

@Before
@Ignore/*  ww w. j a  v a 2  s.c o  m*/
public void setUp() {
    try {
        //TODO: should be rewritten.

        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(Config.DRIVERCLASSNAME);
        dataSource.setUrl(Config.URL);
        dataSource.setUsername(Config.USERNAME);
        dataSource.setPassword(Config.PASSWORD);
        jdbc = new JdbcCommodityRepository(new JdbcTemplate(dataSource));
        //TODO: run creating scripts.
        Assert.assertTrue(true);
    } catch (Throwable throwable) {
        Assert.fail(throwable.getMessage());
    }
}

From source file:org.beangle.ems.database.service.DatasourceService.java

public DataSource getDatasource(Integer id) {
    DataSource datasource = datasources.get(id);
    if (null == datasource) {
        OqlBuilder<DatasourceBean> builder = OqlBuilder.from(DatasourceBean.class, "ds");
        builder.where("ds.id=:id", id);
        List<DatasourceBean> beans = entityDao.search(builder);
        if (!beans.isEmpty()) {
            DatasourceBean bean = beans.get(0);
            DriverManagerDataSource ds = new DriverManagerDataSource();
            ds.setUrl(bean.getUrl());/*from  w w w. java2 s . c om*/
            ds.setUsername(bean.getUsername());
            ds.setPassword(bean.getPassword());
            ds.setDriverClassName(bean.getDriverClassName());
            Properties properties = new Properties();
            for (DatasourcePropertyBean propertyBean : bean.getProperties()) {
                properties.put(propertyBean.getName(), propertyBean.getValue());
            }
            ds.setConnectionProperties(properties);
            datasource = ds;
        }
        datasources.put(id, datasource);
    }
    return datasource;
}

From source file:com.banco.config.RootConfig.java

@Bean
public DataSource dataSource() {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();

    dataSource.setDriverClassName(env.getRequiredProperty(PROPERTY_NAME_DATABASE_DRIVER));
    dataSource.setUrl(env.getRequiredProperty(PROPERTY_NAME_DATABASE_URL));
    dataSource.setUsername(env.getRequiredProperty(PROPERTY_NAME_DATABASE_USERNAME));
    dataSource.setPassword(env.getRequiredProperty(PROPERTY_NAME_DATABASE_PASSWORD));

    return dataSource;
}

From source file:com.mac.abstractrepository.DataSourceConfiguration.java

@Bean
public DataSource dataSource() {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName("org.postgresql.Driver");
    dataSource.setUrl("jdbc:postgresql://localhost:5432/entity");
    dataSource.setUsername("postgres");
    dataSource.setPassword("notorious");
    return dataSource;
}

From source file:com.xiovr.unibot.config.JdbcConfig.java

/**
 * @return create bean for jdbc driver//from  w w  w.  j  a v a2s  .com
 */
@Bean(name = "dataSource")
public DataSource getDataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName(env.getProperty("jdbc.driverClassName"));
    ds.setUrl(env.getProperty("jdbc.url"));
    ds.setUsername(env.getProperty("jdbc.username"));
    ds.setPassword(env.getProperty("jdbc.password"));
    return ds;
    //      EmbeddedDatabaseBuilder edb = new EmbeddedDatabaseBuilder();
    //      edb.setType(EmbeddedDatabaseType.HSQL).
    //         setName("e5botdb").
    //         addScripts("classpath:/sql/hsql_create.sql",
    //               "classpath:/sql/hsql_data.sql");

    //      return edb.build();
}

From source file:com.ar.dev.tierra.api.config.DatabaseConfig.java

/**
 * Bean dataSource encargado de la configuracion de conexion con la base de
 * datos./*from   ww  w.j a va2 s. c o m*/
 *
 * @return objeto con la correspondiente conexion a base de datos.
 */
@Bean
public DataSource dataSource() {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(DB_DRIVER);
    dataSource.setUrl(DB_URL);
    dataSource.setUsername(DB_USERNAME);
    dataSource.setPassword(DB_PASSWORD);
    return dataSource;
}

From source file:org.axiom_tools.data.DirectDataSource.java

@Bean
public DataSource dataSource() {
    getLogger().info(String.format(DirectDriver, driverClassName));
    getLogger().info(String.format(DirectURL, databaseURL));

    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(driverClassName);
    dataSource.setUsername(databaseUsername);
    dataSource.setPassword(databasePassword);
    dataSource.setUrl(databaseURL);//  www .  j  a v a 2 s.  c  o  m
    return dataSource;
}

From source file:com.qpark.eip.core.spring.lockedoperation.TestConfig.java

/**
 * Get the {@link DataSource} auto wired in the
 * {@link EipLockedoperationConfig}.// w  ww . j a  v  a 2s . c om
 *
 * @return The {@link DataSource}
 */
@Bean(name = EipLockedoperationConfig.DATASOURCE_BEAN_NAME)
public DataSource DataSource() {
    DriverManagerDataSource bean = new DriverManagerDataSource();
    bean.setDriverClassName("org.hsqldb.jdbc.JDBCDriver");
    bean.setUrl("jdbc:hsqldb:file:target/hsqldb/testHSQLDB.bin");
    bean.setUsername("platformUser");
    bean.setPassword("platformUserPwd");
    return bean;
}

From source file:com.wms.multitenant.tenant.provider.MultiTenantConnectionProviderImpl.java

private DataSource constructDataSource(String dbName) {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(/*from   w w w.ja  v a 2s  .c om*/
            springEnvironment.getProperty("tenant.datasource.classname", "com.mysql.jdbc.Driver"));
    dataSource.setUrl(springEnvironment.getProperty("tenant.datasource.url", "jdbc:mysql://localhost:3306/")
            + dbName + "?createDatabaseIfNotExist=true");
    dataSource.setUsername(springEnvironment.getProperty("tenant.datasource.user", "root"));
    dataSource.setPassword(springEnvironment.getProperty("tenant.datasource.password", "root"));
    //      ResourceDatabasePopulator rdp = new ResourceDatabasePopulator();
    //      rdp.populate(dataSource.getConnection());
    try {
        dataSource.getConnection().createStatement().execute("CREATE DATABASE IF NOT EXISTS " + dbName);
        dataSource.getConnection().createStatement().execute("CREATE TABLE  IF NOT EXISTS `product` (\n"
                + "  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\n" + "  `name` varchar(128) NOT NULL,\n"
                + "  `product_id` varchar(128) DEFAULT NULL,\n" + "  `price` double DEFAULT NULL,\n"
                + "  `description` varchar(256) DEFAULT NULL,\n" + "  `created` timestamp NULL DEFAULT NULL,\n"
                + "  `updated` timestamp NULL DEFAULT NULL,\n" + "  `deleted` timestamp NULL DEFAULT NULL,\n"
                + "  PRIMARY KEY (`id`),\n" + "  UNIQUE KEY `name` (`name`)\n"
                + ") ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;");
    } catch (Exception ex) {
        System.out.println(ex);
    }
    return dataSource;
}