spring mysql多数据源配置

 

@Configurationpublic 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 datasourcespring.datasource.quartz.url=jdbc:mysql://rds.aliyuncs.com:3306/iotx-data-center-metaspring.datasource.quartz.username=dataservicespring.datasource.quartz.password=Data12345spring.datasource.quartz.driver-class-name=com.mysql.jdbc.Driver