I am trying to setup org.springframework.jdbc.datasource.lookup.Abstrac tRoutingDataSource and am wondering if this dynamic data source routing can be integrated with Quartz. If we have SchedulerFactoryBean defined as:
And quartzDS is a routing data source like:Code:<bean id="cronSchedulerFactory" class="org.springframework.scheduling.quartz.SchedulerFactoryBean" p:dataSource-ref="quartzDS"> .... </bean>
Can this actually work? I am finding that jobs that are scheduled on defaultTargetDataSource (quartzDS1) are firing correctly while jobs scheduled in other datasources are not firing.Code:<bean id="quartzDS" class="xxx.xxx.xxx.CustomRoutingDataSource"> <property name="targetDataSources"> <map key-type="xxx.xxx.xxx.DSKeyType"> <entry key="T1" value-ref="quartzDS1"/> <entry key="T2" value-ref="quartzDS2"/> </map> </property> <property name="defaultTargetDataSource" ref="quartzDS1"/> </bean>
Thanks


Reply With Quote