Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Actually, I've to connect with two database, but we get error during autowiring:
- Source code
- spring:
- datasource:
- username: platform_test_user
- password: plat3pu66
- urlNmad: jdbc:oracle:thin:@nmad.mitchell.com:1521:nmad
- urlDocd: jdbc:oracle:thin:@docd.mitchell.com:1521:docd
- driver-class-name: oracle.jdbc.driver.OracleDriver
- validation-query: select 1 from dual
- validation-interval: 300000
- test-while-idle: true
- test-on-return: true
- max-active: 100
- max-idle: 0
- min-idle: 0
- initial-size: 5
- time-between-eviction-runs-millis: 65000
- min-evictable-idle-time-millis: 60000
- remove-abandoned: true
- remove-abandoned-timeout: 60
- docddatasource:
- username: platform_test_user
- password: plat3pu66
- urlNmad: jdbc:oracle:thin:@nmad.mitchell.com:1521:nmad
- urlDocd: jdbc:oracle:thin:@docd.mitchell.com:1521:docd
- driver-class-name: oracle.jdbc.driver.OracleDriver
- validation-query: select 1 from dual
- validation-interval: 300000
- test-while-idle: true
- test-on-return: true
- max-active: 100
- max-idle: 0
- min-idle: 0
- initial-size: 5
- time-between-eviction-runs-millis: 65000
- min-evictable-idle-time-millis: 60000
- remove-abandoned: true
- remove-abandoned-timeout: 60
- @Bean(name="claimArchiveDataSourceNmad")
- @Primary
- @ConfigurationProperties(prefix="spring.datasource")
- public DataSource dataSourceNmad() throws SQLException {
- final org.apache.tomcat.jdbc.pool.DataSource dataSource = new org.apache.tomcat.jdbc.pool.DataSource();
- dataSource.setDriverClassName(this.dbDriverClassName);
- dataSource.setUrl(this.urlNmad);
- dataSource.setUsername(this.username);
- dataSource.setPassword(this.password);
- dataSource.setValidationQuery(this.dbValidationQuery);
- dataSource.setValidationInterval(this.dbValidationInterval);
- dataSource.setTestOnReturn(this.dbTestOnReturn);
- dataSource.setTestWhileIdle(this.dbTestWhileIdle);
- dataSource.setMaxActive(this.dbMaxActive);
- dataSource.setMaxIdle(this.dbMaxIdle);
- dataSource.setMinIdle(this.dbMinIdle);
- dataSource.setInitialSize(this.dbInitialSize);
- return dataSource;
- }
- @Bean(name="claimArchiveDataSourceDocd")
- @ConfigurationProperties(prefix="spring.docddatasource")
- public DataSource dataSourceDocd() throws SQLException {
- final org.apache.tomcat.jdbc.pool.DataSource dataSource = new org.apache.tomcat.jdbc.pool.DataSource();
- dataSource.setDriverClassName(this.dbDriverClassName);
- dataSource.setUrl(this.urlDocd);
- dataSource.setUsername(this.username);
- dataSource.setPassword(this.password);
- dataSource.setValidationQuery(this.dbValidationQuery);
- dataSource.setValidationInterval(this.dbValidationInterval);
- dataSource.setTestOnReturn(this.dbTestOnReturn);
- dataSource.setTestWhileIdle(this.dbTestWhileIdle);
- dataSource.setMaxActive(this.dbMaxActive);
- dataSource.setMaxIdle(this.dbMaxIdle);
- dataSource.setMinIdle(this.dbMinIdle);
- dataSource.setInitialSize(this.dbInitialSize);
- dataSource.setTimeBetweenEvictionRunsMillis(this.dbTimeBetweenEvictionRunsMillis);
- dataSource.setMinEvictableIdleTimeMillis(this.dbMinEvictableIdleTimeMillis);
- dataSource.setRemoveAbandoned(this.dbRemoveAbandoned);
- dataSource.setRemoveAbandonedTimeout(this.dbRemoveAbandonedTimeout);
- return dataSource;
- }
- Here we need to wire the configured datasource, but we receive error
- @Autowired
- @Qualifier("claimArchiveDataSourceDocd")
- private DataSource dataSource;
- @Autowired
- @Qualifier("claimArchiveDataSourceNmad")
- private DataSource dataSource;
- Error Description:
- 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.
- ***************************
- APPLICATION FAILED TO START
- ***************************
- Description:
- 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.
- Action:
Add Comment
Please, Sign In to add comment