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

Introduction

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

Prototype

public void setConnectionProperties(@Nullable Properties connectionProperties) 

Source Link

Document

Specify arbitrary connection properties as key/value pairs, to be passed to the Driver.

Usage

From source file:com.anjewe.anjewewebwinkel.Config.RootConfig.java

@Bean
public DataSource dataSource() throws SQLException {
    // drivermanagerdatasource
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName(env.getRequiredProperty(DATABASE_DRIVER));
    ds.setUsername(env.getRequiredProperty(DATABASE_USERNAME));
    ds.setPassword(env.getRequiredProperty(DATABASE_PASSWORD));
    ds.setUrl(env.getRequiredProperty(DATABASE_URL));
    ds.setConnectionProperties(connectionProperties());
    return ds;/*from  ww w.  j a  va  2 s  . c om*/
}

---

From source file:se.omegapoint.facepalm.client.config.DatabaseConfig.java

@Bean
public DataSource dataSource() {
    final DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(env.getProperty("db.driver"));
    dataSource.setUrl(env.getProperty("db.url"));
    dataSource.setUsername(env.getProperty("db.username"));
    dataSource.setPassword(env.getProperty("db.password"));
    final Properties properties = new Properties();
    dataSource.setConnectionProperties(properties);
    return dataSource;
}

---

From source file:com.kylinolap.rest.service.BasicService.java

public DataSource getOLAPDataSource(String project) {

    project = ProjectInstance.getNormalizedProjectName(project);

    DataSource ret = olapDataSources.get(project);
    if (ret == null) {
        logger.debug("Creating a new data source");
        logger.debug("OLAP data source pointing to " + getConfig());

        File modelJson = OLAPSchemaFactory.createTempOLAPJson(project, getConfig());

        try {//from   w  w  w  . j  a va 2 s . c om
            List<String> text = Files.readLines(modelJson, Charset.defaultCharset());
            logger.debug("The new temp olap json is :");
            for (String line : text)
                logger.debug(line);
        } catch (IOException e) {
            e.printStackTrace();
        }

        DriverManagerDataSource ds = new DriverManagerDataSource();
        Properties props = new Properties();
        props.setProperty(OLAPQuery.PROP_SCAN_THRESHOLD,
                String.valueOf(KylinConfig.getInstanceFromEnv().getScanThreshold()));
        ds.setConnectionProperties(props);
        ds.setDriverClassName("net.hydromatic.optiq.jdbc.Driver");
        ds.setUrl("jdbc:optiq:model=" + modelJson.getAbsolutePath());

        ret = olapDataSources.putIfAbsent(project, ds);
        if (ret == null) {
            ret = ds;
        }
    }
    return ret;
}

---

From source file:de.alexandria.cms.config.SpringConfigBackendDatabase.java

@Bean
public DataSource dataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName("org.postgresql.Driver");
    ds.setUrl("jdbc:postgresql://" + databaseHostname + ":" + databasePort + "/" + databaseName);
    ds.setUsername(databaseUsername);/*w w w .  ja va2 s.  c o m*/
    ds.setPassword(databasePassword);
    ds.setConnectionProperties(getConnectionProperties());
    return ds;
}

---

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  . j ava2 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:org.unbunt.ella.lang.sql.DBUtils.java

protected static DriverManagerDataSource createDataSourceInternal(Properties props, String url, String user,
        String pass, String classOrType) throws DBConnectionFailedException {
    DriverManagerDataSource ds = new SingleConnectionDataSource();

    String[] driverClasses = null;
    if (classOrType != null) {
        try {/*from w w  w.j  ava  2 s.c  o  m*/
            Drivers drivers = Drivers.valueOf(classOrType);
            driverClasses = drivers.getDriverClasses();
        } catch (IllegalArgumentException ignored) {
            driverClasses = new String[] { classOrType };
        }
    }

    if (driverClasses == null) {
        String driverClass = props.getProperty("driverClassName");
        if (driverClass != null) {
            driverClasses = new String[] { driverClass };
        } else {
            throw new DBConnectionFailedException("No driver specified");
        }
    }

    String actualDriverClass = null;
    for (String driverClass : driverClasses) {
        try {
            Class.forName(driverClass);
            actualDriverClass = driverClass;
            break;
        } catch (ClassNotFoundException e) {
            continue;
        }
    }

    if (actualDriverClass == null) {
        throw new DBConnectionFailedException("Failed to load JDBC driver: Unknown type or class not found");
    }

    ds.setDriverClassName(actualDriverClass);
    props.setProperty("driverClassName", actualDriverClass);

    if (url == null) {
        throw new DBConnectionFailedException("Missing URL");
    }
    ds.setUrl(url);

    if (user != null) {
        ds.setUsername(user);
    }
    if (pass != null) {
        ds.setPassword(pass);
    }

    ds.setConnectionProperties(props);

    return ds;
}

---

From source file:scott.barleydb.test.TestBase.java

private void initDb() throws Exception {
    if (!databaseInitialized) {
        DriverManagerDataSource dmDataSource = new DriverManagerDataSource();
        dmDataSource.setDriverClassName(db.getDriverClassName());
        dmDataSource.setUrl(db.getUrl());
        dmDataSource.setUsername(db.getUser());
        dmDataSource.setPassword(db.getPassword());
        dmDataSource.setConnectionProperties(db.getConnectionProperties());
        dataSource = dmDataSource;/*from   w  ww.j av a 2 s  .c o  m*/

        if (db instanceof HsqlDbTest) {
            executeScript("/drop.sql", true);
            executeScript("/" + db.getSchemaName(), false);
        }
        databaseInitialized = true;
    }
}

---

From source file:org.apache.kylin.rest.service.BasicService.java

public DataSource getOLAPDataSource(String project) {

    project = ProjectInstance.getNormalizedProjectName(project);

    DataSource ret = olapDataSources.get(project);
    if (ret == null) {
        logger.debug("Creating a new data source");
        logger.debug("OLAP data source pointing to " + getConfig());

        File modelJson = OLAPSchemaFactory.createTempOLAPJson(project, getConfig());

        try {//from  w ww. j  ava 2  s  .co  m
            List<String> text = Files.readLines(modelJson, Charset.defaultCharset());
            logger.debug("The new temp olap json is :");
            for (String line : text)
                logger.debug(line);
        } catch (IOException e) {
            e.printStackTrace(); // logging failure is not critical
        }

        DriverManagerDataSource ds = new DriverManagerDataSource();
        Properties props = new Properties();
        props.setProperty(OLAPQuery.PROP_SCAN_THRESHOLD,
                String.valueOf(KylinConfig.getInstanceFromEnv().getScanThreshold()));
        ds.setConnectionProperties(props);
        ds.setDriverClassName("net.hydromatic.optiq.jdbc.Driver");
        ds.setUrl("jdbc:calcite:model=" + modelJson.getAbsolutePath());

        ret = olapDataSources.putIfAbsent(project, ds);
        if (ret == null) {
            ret = ds;
        }
    }
    return ret;
}

---