List of usage examples for org.springframework.jdbc.datasource DriverManagerDataSource DriverManagerDataSource
public DriverManagerDataSource()
From source file:py.una.pol.karaku.test.configuration.TransactionTestConfiguration.java
/** * Crea un datasource para una base de datos embebida. * //from ww w . j a v a 2 s . c o m * @return dataSource creada o null si no se necesita un datasource * @throws IOException * si no se puede crear la base de datos */ @Bean public DataSource dataSource() throws IOException { DataSource ds; if (properties.getBoolean(USE_EMBEDDED, true)) { EmbeddedDatabaseBuilder edb = new EmbeddedDatabaseBuilder().setType(EmbeddedDatabaseType.H2); ds = edb.build(); } else { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setUrl(properties.get("test.hiberante.database")); dataSource.setUsername(properties.get("test.hibernate.user")); dataSource.setPassword(properties.get("test.hibernate.pass")); ds = dataSource; } return ds; }
From source file:ca.weblite.contacts.webservice.RESTServiceConfiguration.java
@Bean public DataSource getDataSource() { if (DB_USERNAME == null || DB_PASSWORD == null || DB_URL == null) { loadRuntimeSettings();//from ww w .j a v a2 s .com } DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl(DB_URL); dataSource.setUsername(DB_USERNAME); dataSource.setPassword(DB_PASSWORD); return dataSource; }
From source file:com.iucosoft.eavertizare.dao.impl.ClientsDaoImpl.java
@Override public List<Client> findAllClientsForFirmaRemote(Firma firma) { DriverManagerDataSource dataSourceClient = new DriverManagerDataSource(); dataSourceClient.setDriverClassName(firma.getConfiguratii().getDriver()); dataSourceClient.setUrl(firma.getConfiguratii().getUrlDb()); dataSourceClient.setUsername(firma.getConfiguratii().getUsername()); dataSourceClient.setPassword(firma.getConfiguratii().getPassword()); String query = "select * from " + firma.getConfiguratii().getTabelaClienti(); List<Client> clientsList = new ArrayList<>(); try (Connection con = dataSourceClient.getConnection(); PreparedStatement ps = con.prepareStatement(query); ResultSet rs = ps.executeQuery();) { while (rs.next()) { Client client = new Client(); client.setId(rs.getInt(1));/*from w w w . j a v a 2s . c o m*/ client.setNume(rs.getString(2)); client.setPrenume(rs.getString(3)); client.setNrTelefon(rs.getInt(4)); client.setEmail(rs.getString(5)); client.setDateExpirare(rs.getTimestamp(6)); clientsList.add(client); } } catch (SQLException e) { e.printStackTrace(); } return clientsList; }
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);/*from w ww. ja va 2 s .c o m*/ ds.setPassword(databasePassword); ds.setConnectionProperties(getConnectionProperties()); return ds; }
From source file:com.jmstoolkit.pipeline.plugin.XMLValueTransform.java
/** * Constructor for creating a useful <code>XMLValueTransform</code>. * * @param pluginName The human readable name for the Transform. * @param inConfig The SQL query for looking up the value. * @param inputName The JNDI name of the JMS Destination to subscribe to. * @param outputName The JNDI name of the JMS Destination to publish to. * @param replyToName The JNDI name of the JMS Destination for reply/status. * @param connectionFactory A JMS ConnectionFactory implementation. * @param inJndiTemplate The JndiTemplate. */// w ww. jav a 2s . c om public XMLValueTransform(final String pluginName, final String inConfig, final String inputName, final String outputName, final String replyToName, final ConnectionFactory connectionFactory, final JndiTemplate inJndiTemplate) { super(); this.jndiTemplate = inJndiTemplate; this.name = pluginName; this.inName = inputName; this.outName = outputName; this.replyToName = replyToName; try { // Setup the JMS Destinations setInput((Destination) getJndiTemplate().lookup(inputName, Destination.class)); setOutput((Destination) getJndiTemplate().lookup(outputName, Destination.class)); setReplyTo((Destination) getJndiTemplate().lookup(replyToName, Destination.class)); // Setup the JmsTemplate getJmsTemplate().setConnectionFactory(connectionFactory); getJmsTemplate().setDefaultDestination(getOutput()); // Setup the default JDBC DataSource: final Document doc = getWork(inConfig); defaultDataSource.setDriverClassName(trim(doc.valueOf("//enrich/defaultDatabase/driver"))); defaultDataSource.setUrl(trim(doc.valueOf("//enrich/defaultDatabase/url"))); defaultDataSource.setUsername(trim(doc.valueOf("//enrich/defaultDatabase/username"))); defaultDataSource.setPassword(trim(doc.valueOf("//enrich/defaultDatabase/password"))); //FIXME: pool properties hard coded here defaultDataSource.setMaxActive(5); defaultDataSource.setMaxIdle(2); defaultDataSource.setMinIdle(1); jdbcTemplate = new SimpleJdbcTemplate(getDefaultDataSource()); // create list of value transforms from the elements list final List<Element> elements = doc.selectNodes("//enrich/elements/element"); for (Element node : elements) { SimpleJdbcTemplate vttemplate = jdbcTemplate; final String ddriver = node.valueOf("database/driver"); if (ddriver != null && !"".equals(ddriver)) { // normally we'll use the defaultDataSource which is a pooling source // but we give the ability to specify a unique DataSource as well final DriverManagerDataSource dmds = new DriverManagerDataSource(); dmds.setDriverClassName(trim(node.valueOf("database/driver"))); dmds.setUrl(trim(node.valueOf("database/url"))); dmds.setUsername(trim(node.valueOf("database/username"))); dmds.setPassword(trim(node.valueOf("database/password"))); vttemplate = new SimpleJdbcTemplate(dmds); } final XMLValueTransformer xvt = new XMLValueTransformer(vttemplate); xvt.setSrcPath(trim(node.valueOf("srcPath"))); xvt.setDstPath(trim(node.valueOf("dstPath"))); xvt.setSql(trim(node.valueOf("sql"))); // validates SQL statement xforms.add(xvt); } } catch (NamingException ex) { LOGGER.log(Level.SEVERE, "Bad JNDI name for Destination: " + getName(), ex); setStatus(STATUS_FAILED); } catch (DocumentException ex) { LOGGER.log(Level.SEVERE, "Invalid work XML for transform: ", ex); setStatus(STATUS_FAILED); } catch (XMLValueTransformException ex) { LOGGER.log(Level.SEVERE, "Bad work XML: ", ex); setStatus(STATUS_FAILED); } catch (SQLException ex) { LOGGER.log(Level.SEVERE, "Bad SQL query: ", ex); } }
From source file:br.com.teste.spring.security.config.AppConfig.java
@Bean public DataSource dataSource() { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://localhost:3306/test"); dataSource.setUsername("med"); dataSource.setPassword("med"); return dataSource; }
From source file:com.fantasy.AggregatorConfig.java
@Bean public DataSource dataSource() { DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName("org.postgresql.Driver"); dataSource.setUrl("jdbc:postgresql://localhost:5432/fantasy"); dataSource.setUsername("postgres"); dataSource.setPassword("notorious"); return dataSource; }
From source file:org.mitre.jdbc.datasource.H2DataSourceFactory.java
protected DataSource createDataSource() { DriverManagerDataSource ds = new DriverManagerDataSource(); ds.setDriverClassName("org.h2.Driver"); ds.setUrl(getConnectionString());//from w ww . j a v a 2 s.c o m ds.setUsername("sa"); ds.setPassword(""); logger.debug("Created dataSource: " + ds.toString()); return ds; }
From source file:gov.nih.nci.security.util.ConfigurationHelper.java
private DataSource getDataSourceFromConfiguration(Properties configPropetries) { DataSource ds = null;/*from w w w . ja v a2 s . co m*/ if (configPropetries != null) { String datasource = configPropetries.getProperty("hibernate.connection.datasource"); if (!StringUtils.isEmpty(datasource)) { log.info("Datasource::" + datasource); try { InitialContext initialContext = new InitialContext(); ds = (DataSource) initialContext.lookup(datasource); } catch (NamingException ex) { log.info("Exception occured while looking up datasource::" + datasource); } } else { String urlProperty = configPropetries.getProperty("hibernate.connection.url"); String usernameProperty = configPropetries.getProperty("hibernate.connection.username"); String passwordProperty = configPropetries.getProperty("hibernate.connection.password"); String driverProperty = configPropetries.getProperty("hibernate.connection.driver_class"); log.info("Connection:user:" + configPropetries.getProperty("hibernate.connection.username")); log.info("Connection:url:" + configPropetries.getProperty("hibernate.connection.url")); DriverManagerDataSource dataSource = new DriverManagerDataSource(); dataSource.setDriverClassName(driverProperty); dataSource.setUrl(urlProperty); dataSource.setUsername(usernameProperty); dataSource.setPassword(passwordProperty); ds = dataSource; } } 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;/* www .j ava 2 s . c o m*/ if (db instanceof HsqlDbTest) { executeScript("/drop.sql", true); executeScript("/" + db.getSchemaName(), false); } databaseInitialized = true; } }