Guest User

Untitled

a guest
Nov 24th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.86 KB | None | 0 0
  1. Actually, I've to connect with two database, but we get error during autowiring:
  2.  
  3. Source code
  4.  
  5. spring:
  6. datasource:
  7. username: platform_test_user
  8. password: plat3pu66
  9. urlNmad: jdbc:oracle:thin:@nmad.mitchell.com:1521:nmad
  10. urlDocd: jdbc:oracle:thin:@docd.mitchell.com:1521:docd
  11. driver-class-name: oracle.jdbc.driver.OracleDriver
  12. validation-query: select 1 from dual
  13. validation-interval: 300000
  14. test-while-idle: true
  15. test-on-return: true
  16. max-active: 100
  17. max-idle: 0
  18. min-idle: 0
  19. initial-size: 5
  20. time-between-eviction-runs-millis: 65000
  21. min-evictable-idle-time-millis: 60000
  22. remove-abandoned: true
  23. remove-abandoned-timeout: 60
  24. docddatasource:
  25. username: platform_test_user
  26. password: plat3pu66
  27. urlNmad: jdbc:oracle:thin:@nmad.mitchell.com:1521:nmad
  28. urlDocd: jdbc:oracle:thin:@docd.mitchell.com:1521:docd
  29. driver-class-name: oracle.jdbc.driver.OracleDriver
  30. validation-query: select 1 from dual
  31. validation-interval: 300000
  32. test-while-idle: true
  33. test-on-return: true
  34. max-active: 100
  35. max-idle: 0
  36. min-idle: 0
  37. initial-size: 5
  38. time-between-eviction-runs-millis: 65000
  39. min-evictable-idle-time-millis: 60000
  40. remove-abandoned: true
  41. remove-abandoned-timeout: 60
  42.  
  43.  
  44. @Bean(name="claimArchiveDataSourceNmad")
  45. @Primary
  46. @ConfigurationProperties(prefix="spring.datasource")
  47. public DataSource dataSourceNmad() throws SQLException {
  48.  
  49. final org.apache.tomcat.jdbc.pool.DataSource dataSource = new org.apache.tomcat.jdbc.pool.DataSource();
  50. dataSource.setDriverClassName(this.dbDriverClassName);
  51. dataSource.setUrl(this.urlNmad);
  52. dataSource.setUsername(this.username);
  53. dataSource.setPassword(this.password);
  54. dataSource.setValidationQuery(this.dbValidationQuery);
  55. dataSource.setValidationInterval(this.dbValidationInterval);
  56. dataSource.setTestOnReturn(this.dbTestOnReturn);
  57. dataSource.setTestWhileIdle(this.dbTestWhileIdle);
  58. dataSource.setMaxActive(this.dbMaxActive);
  59. dataSource.setMaxIdle(this.dbMaxIdle);
  60. dataSource.setMinIdle(this.dbMinIdle);
  61. dataSource.setInitialSize(this.dbInitialSize);
  62.  
  63. return dataSource;
  64.  
  65.  
  66. }
  67.  
  68. @Bean(name="claimArchiveDataSourceDocd")
  69. @ConfigurationProperties(prefix="spring.docddatasource")
  70. public DataSource dataSourceDocd() throws SQLException {
  71.  
  72. final org.apache.tomcat.jdbc.pool.DataSource dataSource = new org.apache.tomcat.jdbc.pool.DataSource();
  73. dataSource.setDriverClassName(this.dbDriverClassName);
  74. dataSource.setUrl(this.urlDocd);
  75. dataSource.setUsername(this.username);
  76. dataSource.setPassword(this.password);
  77. dataSource.setValidationQuery(this.dbValidationQuery);
  78. dataSource.setValidationInterval(this.dbValidationInterval);
  79. dataSource.setTestOnReturn(this.dbTestOnReturn);
  80. dataSource.setTestWhileIdle(this.dbTestWhileIdle);
  81. dataSource.setMaxActive(this.dbMaxActive);
  82. dataSource.setMaxIdle(this.dbMaxIdle);
  83. dataSource.setMinIdle(this.dbMinIdle);
  84. dataSource.setInitialSize(this.dbInitialSize);
  85. dataSource.setTimeBetweenEvictionRunsMillis(this.dbTimeBetweenEvictionRunsMillis);
  86. dataSource.setMinEvictableIdleTimeMillis(this.dbMinEvictableIdleTimeMillis);
  87. dataSource.setRemoveAbandoned(this.dbRemoveAbandoned);
  88. dataSource.setRemoveAbandonedTimeout(this.dbRemoveAbandonedTimeout);
  89.  
  90. return dataSource;
  91.  
  92. }
  93.  
  94. Here we need to wire the configured datasource, but we receive error
  95.  
  96. @Autowired
  97. @Qualifier("claimArchiveDataSourceDocd")
  98. private DataSource dataSource;
  99.  
  100.  
  101.  
  102. @Autowired
  103. @Qualifier("claimArchiveDataSourceNmad")
  104. private DataSource dataSource;
  105.  
  106.  
  107. Error Description:
  108.  
  109. Field dataSource in com.abc.services.business.claim.dao.ClaimArchiveMetaDataDAO required a bean of type 'org.apache.tomcat.jdbc.pool.DataSource' that could not be found.
  110.  
  111. ***************************
  112. APPLICATION FAILED TO START
  113. ***************************
  114.  
  115. Description:
  116.  
  117. Field dataSource in com.mitchell.services.business.claimarchiving.dao.ClaimArchiveMetaDataDAO required a bean of type 'org.apache.tomcat.jdbc.pool.DataSource' that could not be found.
  118.  
  119.  
  120. Action:
Add Comment
Please, Sign In to add comment