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

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

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.datasource.*
  5. DriverManagerDataSource
  6. setUrl

Introduction

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

Prototype

public void setUrl(@Nullable String url)

Source Link

Document

Set the JDBC URL to use for connecting through the Driver.

Usage

From source file:com.pactera.edg.am.metamanager.extractor.adapter.extract.db.impl.TeradataExtractServiceImpl.java

public static void main(String[] args) throws SQLException, FileNotFoundException, IOException {
    IDBExtractService extractor = new TeradataExtractServiceImpl();
    org.springframework.jdbc.datasource.DriverManagerDataSource dSource = new org.springframework.jdbc.datasource.DriverManagerDataSource();
    // dSource.setDriverClassName("com.ncr.teradata.TeraDriver");
    // dSource.setUrl("jdbc:teradata://172.19.0.158/CLIENT_CHARSET=cp936,TMODE=TERA,CHARSET=ASCII,DATABASE=MM");
    // dSource.setUsername("mmuser");
    // dSource.setPassword("mmuser");
    // extractor.setSchemas("MM");
    // File file = new File("d:\\catalog");
    ////from w  w w.java2s.com
    // ObjectOutput output = new ObjectOutputStream(new
    // FileOutputStream(file));
    //
    // // ?
    //
    // output.writeObject(c);
    //
    // output.close();
    //
    // System.out.println("?" + file.getAbsolutePath());
    Log4jInit.init();
    // extractor = new TeradataExtractServiceImpl();
    dSource.setDriverClassName("com.ncr.teradata.TeraDriver");
    dSource.setUrl("jdbc:teradata://172.16.171.24/CLIENT_CHARSET=cp936,TMODE=TERA,CHARSET=ASCII,DATABASE=MM");
    // dSource.setUrl("jdbc:teradata://172.19.166.203/CLIENT_CHARSET=cp936,TMODE=TERA,CHARSET=ASCII,DATABASE=MM");
    dSource.setUsername("mmuser");
    dSource.setPassword("mmuser");
    ((DBExtractBaseServiceImpl) extractor).setSchemas("edwbview");
    // ((DBExtractBaseServiceImpl) extractor).setSchemas("mm2");
    // ((DBExtractBaseServiceImpl) extractor).setSchemas("MM");
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dSource);

    ((DBExtractBaseServiceImpl) extractor).setJdbcTemplate(jdbcTemplate);
    extractor.getCatalog();

}

From source file:com.sms.server.database.SettingsDatabase.java

public static DataSource getDataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName("org.h2.jdbcx.JdbcDataSource");
    ds.setUrl("jdbc:h2:" + SettingsService.getHomeDirectory() + "/db/settings");

    return ds;//  w  w  w. java 2  s .  c om
}

From source file:at.christophwurst.orm.test.IntegrationTest.java

@BeforeClass
public static void setUpClass() {
    Operation operation = DbOperations.PREPARE_DB;
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName("org.apache.derby.jdbc.ClientDriver");
    dataSource.setUrl("jdbc:derby://localhost/WorkLogDb;create=true");
    dataSource.setUsername("user");
    dataSource.setPassword("test");
    dbSetup = new DbSetup(new DataSourceDestination(dataSource), operation);
}

From source file:com.sms.server.database.JobDatabase.java

public static DataSource getDataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName("org.h2.jdbcx.JdbcDataSource");
    ds.setUrl("jdbc:h2:" + SettingsService.getHomeDirectory() + "/db/job");

    return ds;/* www.  j a v  a  2 s .co  m*/
}

From source file:com.google.api.ads.adwords.awalerting.util.JdbcUtil.java

/**
 * Create a JdbcTemplate according to the parameters.
 *
 * @param dbConfig the Json configuration for database connection
 * @param driverKey the key for JDBC driver class name
 * @param urlKey the key for JDBC url//  w w  w.j a  va 2s .  co m
 * @param usernameKey the key for JDBC username
 * @param passwordKey the key JDBC password
 * @return a JdbcTemplate with the given parameters
 */
public static JdbcTemplate createJdbcTemplate(JsonObject dbConfig, String driverKey, String urlKey,
        String usernameKey, String passwordKey) {
    // Read the config values.
    String driver = DEFAULT_DB_DRIVER;
    if (dbConfig.has(driverKey)) {
        driver = dbConfig.get(driverKey).getAsString();
    }

    Preconditions.checkArgument(dbConfig.has(urlKey), "Missing compulsory property: %s", urlKey);
    String url = dbConfig.get(urlKey).getAsString();

    String username = null;
    if (dbConfig.has(usernameKey)) {
        username = dbConfig.get(usernameKey).getAsString();
    }

    String password = null;
    if (dbConfig.has(passwordKey)) {
        password = dbConfig.get(passwordKey).getAsString();
    }

    // Create the data source.
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(driver);
    dataSource.setUrl(url);
    dataSource.setUsername(username);
    dataSource.setPassword(password);

    // Create the JdbcTemplate with the data srouce.
    return new JdbcTemplate(dataSource);
}

From source file:com.sms.server.database.MediaDatabase.java

public static DataSource getDataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName("org.h2.jdbcx.JdbcDataSource");
    ds.setUrl("jdbc:h2:" + SettingsService.getHomeDirectory() + "/db/media");

    return ds;//from   w  ww.j a v a 2  s  .  co m
}

From source file:com.sms.server.database.UserDatabase.java

public static DataSource getDataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName("org.h2.jdbcx.JdbcDataSource");
    ds.setUrl("jdbc:h2:" + SettingsService.getHomeDirectory() + "/db/user");

    return ds;//from   ww  w. ja v a 2  s  . c  o m
}

From source file:com.fmguler.ven.LiquibaseUtil.java

/**
 * @return DataSource for the test database
 *///  w  ww.  j a v a 2  s . c o  m
public static DataSource getDataSource() {
    DriverManagerDataSource ds = new DriverManagerDataSource();
    ds.setDriverClassName("org.postgresql.Driver");
    ds.setUsername("postgres");
    ds.setPassword("qwerty");
    ds.setUrl("jdbc:postgresql://127.0.0.1:5432/ven-test");
    return ds;
}

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

/**
 * Create and initialize the database connection.
 * //from  w  w  w. j av  a2 s  .  c o m
 * @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:com.scooter1556.sms.server.utilities.DatabaseUtils.java

public static DataSource getDataSource(String db, int version) throws DatabaseException {
    if (SettingsService.getInstance().getDataDirectory() == null) {
        throw new DatabaseException("Data directory does not exist or is not writable!");
    }/*w  ww .j a va 2  s.  c  om*/

    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName("org.h2.jdbcx.JdbcDataSource");
    dataSource.setUrl("jdbc:h2:" + SettingsService.getInstance().getDataDirectory() + "/db/" + db.toLowerCase()
            + "." + version + ";"
            + "MV_STORE=FALSE;MVCC=FALSE;FILE_LOCK=FS;IGNORECASE=TRUE;DATABASE_TO_UPPER=FALSE;");

    return dataSource;
}