Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #data source 1
- tools.datasource[0].url=jdbc:sqlserver://databaseurl;databaseName=dbname
- tools.datasource[0].username=databaseUser
- tools.datasource[0].password=databasePassword
- tools.datasource[0].driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
- #data source 2
- tools.datasource[0].url=jdbc:sqlserver://databaseurl;databaseName=dbname
- tools.datasource[0].username=databaseUser
- tools.datasource[0].password=databasePassword
- tools.datasource[0].driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
- @Configuration
- @ConfigurationProperties(prefix = "tools.datasource")
- public class MultipleDataSource {
- private List<DataSource> datasources;
- public List<DataSource> getDatasources() {
- return datasources;
- }
- }
- @Configuration
- @EnableBatchProcessing
- public class BatchConfiguration {
- @Autowired
- public JobBuilderFactory jobBuilderFactory;
- @Autowired
- public StepBuilderFactory stepBuilderFactory;
- @Autowired
- public MultipleDataSource dataSourceConfig;
- public ItemReader<Project> reader(DataSource datasource) {
- dataSourceConfig.getDatasources().forEach(System.out::println);
- JdbcCursorItemReader<Item> reader = new JdbcCursorItemReader<Item>();
- ......
- return reader;
- }
- }
Add Comment
Please, Sign In to add comment