IllegalArgumentException：driverClassName需要jdbcUrl

Question

@Bean
private DataSource getDataSource() {
    return DataSourceBuilder.create()
          .driverClassName("org.postgresql.Driver")
          .url(environment.getProperty(VAR_URL)) // Error thrown here
          .username(environment.getProperty(VAR_NAME))
          .password(environment.getProperty(VAR_PASSWORD))
          .build();

server:
  port: 8080
spring:
  application:
    name: my-app
  profiles:
    active: dev
  jpa:
    properties:
      hibernate:
        dialect: org.hibernate.dialect.PostgreSQLDialect
    show-sql: true
    open-in-view: true
  datasource:
    url:
    username:
    password:
    driver-class-name: org.postgresql.Driver

  quartz:
    properties:
      org.quartz.jobStore.isClustered: true
      org.quartz.scheduler.instanceId: AUTO
      org.quartz.jobStore.driverDelegateClass: org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
      org.quartz.scheduler.instanceName: my-scheduler
      org.quartz.threadPool.threadCount: 3
      org.quartz.jobStore.class: org.quartz.impl.jdbcjobstore.JobStoreTX
      org.quartz.jobStore.useProperties: true
      org.quartz.jobStore.misfireThreshold: 60000
      org.quartz.jobStore.tablePrefix: qrtz_
      org.quartz.plugin.shutdownHook.class: org.quartz.plugins.management.ShutdownHookPlugin
      org.quartz.plugin.shutdownHook.cleanShutdown: TRUE
    jdbc:
      initialize-schema: always
    job-store-type: jdbc

我漏掉什么了吗？请建议是否有更好的方法做这件事。谢谢你。

Answer 1

您基本上是在重写Spring-Boot的自动配置，以便配置这个调度程序的数据源。这就是为什么它可以在没有quartz调度器的分支上工作（我想该分支中没有@bean私有数据源getDataSource())。

必须使用@value才能从application.yml检索数据库属性

例如。

@Value("${spring.datasource.url}")
private String databaseUrl;

@Value("${spring.datasource.username}")
private String username;

@Value("${spring.datasource.password}")
private String password;

//and then use these strings in your getDataSource()

@Bean
private DataSource getDataSource() {
    return DataSourceBuilder.create()
          .driverClassName("org.postgresql.Driver")
          .url(environment.getProperty(databaseUrl)) // Error thrown here
          .username(environment.getProperty(username))
          .password(environment.getProperty(password))
          .build();