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

List of usage examples for org.springframework.jdbc.datasource DriverManagerDataSource DriverManagerDataSource

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.datasource.*
  5. DriverManagerDataSource
  6. 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:org.consultjr.mvc.core.config.ApplicationConfig.java

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

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

    return dataSource;
}

From source file:mx.edu.um.eventosum.config.DataConfig.java

@Bean
public DataSource mainDataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName(jdbcDriver);//from  w ww .j  a  v a 2 s  .c  o  m
    ds.setUsername(jdbcUsername);
    ds.setPassword(jdbcPassword);
    ds.setUrl(jdbcUrl);
    return ds;
}

From source file:com.company.project.config.DataConfig.java

@Bean(name = "dataSource")
public DataSource dataSource() {
    DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
    //        driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
    //        driverManagerDataSource.setUrl("jdbc:mysql://localhost:3306/test");
    //        driverManagerDataSource.setUsername("root");
    //        driverManagerDataSource.setPassword("root");

    // fails during unit tests
    //        driverManagerDataSource.setDriverClassName(driverClassName);
    //        driverManagerDataSource.setUrl(url);
    //        driverManagerDataSource.setUsername(username);
    //        driverManagerDataSource.setPassword(password);

    driverManagerDataSource.setDriverClassName(env.getProperty("jdbc.driver"));
    driverManagerDataSource.setUrl(env.getProperty("jdbc.url"));
    driverManagerDataSource.setUsername(env.getProperty("jdbc.username"));
    driverManagerDataSource.setPassword(env.getProperty("jdbc.password"));

    // create a table and populate some data
    //JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    //System.out.println("Creating tables");
    //jdbcTemplate.execute("drop table users if exists");
    //jdbcTemplate.execute("create table users(id serial, firstName varchar(255), lastName varchar(255), email varchar(255))");
    //jdbcTemplate.update("INSERT INTO users(firstName, lastName, email) values (?,?,?)", "Mike", "Lanyon", "lanyonm@gmail.com");

    return driverManagerDataSource;
}

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 {/* w  w w .  java2 s  .  c  o  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();
        }

        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:commonline.query.sql.RecordParserDataSource.java

protected DriverManagerDataSource createDelegate() {
    return new DriverManagerDataSource();
}

From source file:com.MockGatewayApplication.java

@Bean
public DataSource dataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName(dbDriver);/* w  w  w  . j  av a2 s.  c o m*/
    ds.setUrl(dbUrl);
    ds.setUsername(dbUsername);
    ds.setPassword(dbPassword);

    return ds;
}

From source file:cz.dasnet.dasik.Dasik.java

public Dasik() throws ConfigException {
    log.info("");
    log.info("Creating new bot instance ...");
    this.config = new Config();

    log.info("Setting up datasource ...");
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName(config.getProperty("datasource.driver", "com.mysql.jdbc.Driver"));
    ds.setUrl(config.getProperty("datasource.connection", "jdbc:mysql://localhost:3306/dasik"));
    ds.setUsername(config.getProperty("datasource.username", "root"));
    ds.setPassword(config.getProperty("datasource.password", "root"));
    dataSource = ds;/*ww  w  .j  av a 2  s .co m*/

    log.info("Creating User DAO ...");
    userDao = new UserDaoImpl(dataSource);

    log.info("Creating Learn DAO ...");
    learnDao = new LearnDaoImpl(dataSource);

    log.info("Loading channel list ...");
    String channs = config.getProperty("irc.channel.autojoin");
    if (channs != null) {
        for (String chan : channs.split("\\s+")) {
            String pass = config.getProperty("irc.channel.pass." + chan, "");
            channels.put(chan, pass);
        }
    }

    log.info("Initializing logger ...");
    chanlog = new ChannelLogger(config.getProperty("log.basepath", "logs"));
    channelListeners.put("@log", chanlog);

    log.info("Creating plugin loader ...");
    pluginLoader = new PluginLoader(this);

    log.info("Loading plugins ...");
    String commands = config.getProperty("command.autoload");
    if (commands != null) {
        plugins.addAll(Arrays.asList(commands.split("\\s+")));
    }

    Map<String, Plugin> loadedPlugins = pluginLoader.loadPlugins(plugins);
    channelListeners.putAll(loadedPlugins);

    log.info("Loading channel configs ...");
    for (String plugin : plugins) {
        String ignore = config.getProperty("command.ignoreOn." + plugin);
        if (ignore != null) {
            String[] chans = ignore.split("\\s+");
            for (String chan : chans) {
                ChannelConfig c = channelConfigs.get(chan);
                if (c == null) {
                    c = new ChannelConfig(chan);
                    channelConfigs.put(chan, c);
                }
                c.ignorePlugin(plugin);
            }
        }
    }

    log.info("Bot created");
}

From source file:org.tonguetied.test.common.PersistenceTestBase.java

/**
 * Create and initialize the database connection.
 * //from  w w w  . j  ava 2  s .  c  om
 * @param properties
 */
protected static void initializeDataSource(Properties properties) {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setUrl(properties.getProperty(KEY_JDBC_URL));
    dataSource.setDriverClassName(properties.getProperty(KEY_JDBC_DRIVER));
    dataSource.setUsername(properties.getProperty(KEY_JDBC_USER_NAME));
    dataSource.setPassword(properties.getProperty(KEY_JDBC_PASSWORD));
    //        final DatasourceConnectionProvider provider = new DatasourceConnectionProvider();
    //        provider.configure(properties);
    template = new SimpleJdbcTemplate(dataSource);
}

From source file:net.sourceforge.subsonic.dao.HsqlDaoHelper.java

private DataSource createDataSource() {
    File subsonicHome = SettingsService.getSubsonicHome();
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName("org.hsqldb.jdbcDriver");
    ds.setUrl("jdbc:hsqldb:file:" + subsonicHome.getPath() + "/db/subsonic");
    ds.setUsername("sa");
    ds.setPassword("");

    return ds;//from w ww  .  j  a v a 2  s  . c om
}

From source file:ru.develgame.jflickrorganizer.MainClass.java

@Bean
public DataSource dataSource() {
    DriverManagerDataSource basicDataSource = new DriverManagerDataSource();
    basicDataSource.setDriverClassName("org.sqlite.JDBC");
    basicDataSource.setUrl("jdbc:sqlite:" + properties.getProperty("pathToDB", ""));
    basicDataSource.setUsername("");
    basicDataSource.setPassword("");
    return basicDataSource;
}