spring mysql多数据源配置
@Configuration public class QuartzConfig { @Autowired private AutowireJobFactory jobFactory; @Bean(name = "quartzDataSource") @ConfigurationProperties(prefix="spring.datasource.quartz") public DataSource quartzDataSource() { return DataSourceBuilder.create().build(); } private Properties quartzProperties() { Properties properties = new Properties(); properties.put("org.quartz.jobStore.tablePrefix", "DC_QRTZ_"); return properties; } @Bean public SchedulerFactoryBean schedulerFactoryBean() { SchedulerFactoryBean schedulerFactoryBean = new SchedulerFactoryBean(); schedulerFactoryBean.setJobFactory(jobFactory); schedulerFactoryBean.setDataSource(quartzDataSource()); schedulerFactoryBean.setQuartzProperties(quartzProperties()); return schedulerFactoryBean; } @Bean public Scheduler scheduler() { return schedulerFactoryBean().getScheduler(); } }
application.properties
# quartz datasource spring.datasource.quartz.url=jdbc:mysql://rds.aliyuncs.com:3306/iotx-data-center-meta spring.datasource.quartz.username=dataservice spring.datasource.quartz.password=Data12345 spring.datasource.quartz.driver-class-name=com.mysql.jdbc.Driver