Guest User

Untitled

a guest
Dec 21st, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. #data source 1
  2. tools.datasource[0].url=jdbc:sqlserver://databaseurl;databaseName=dbname
  3. tools.datasource[0].username=databaseUser
  4. tools.datasource[0].password=databasePassword
  5. tools.datasource[0].driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
  6.  
  7. #data source 2
  8. tools.datasource[0].url=jdbc:sqlserver://databaseurl;databaseName=dbname
  9. tools.datasource[0].username=databaseUser
  10. tools.datasource[0].password=databasePassword
  11. tools.datasource[0].driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
  12.  
  13. @Configuration
  14. @ConfigurationProperties(prefix = "tools.datasource")
  15. public class MultipleDataSource {
  16.  
  17. private List<DataSource> datasources;
  18.  
  19. public List<DataSource> getDatasources() {
  20. return datasources;
  21. }
  22. }
  23.  
  24. @Configuration
  25. @EnableBatchProcessing
  26. public class BatchConfiguration {
  27.  
  28. @Autowired
  29. public JobBuilderFactory jobBuilderFactory;
  30.  
  31. @Autowired
  32. public StepBuilderFactory stepBuilderFactory;
  33.  
  34. @Autowired
  35. public MultipleDataSource dataSourceConfig;
  36.  
  37. public ItemReader<Project> reader(DataSource datasource) {
  38.  
  39. dataSourceConfig.getDatasources().forEach(System.out::println);
  40.  
  41. JdbcCursorItemReader<Item> reader = new JdbcCursorItemReader<Item>();
  42. ......
  43.  
  44. return reader;
  45.  
  46.  
  47. }
  48.  
  49. }
Add Comment
Please, Sign In to add comment