Quartz属性文件传入环境变量

Question

我正试图将环境变量添加到我的石英属性文件中，但它没有正确加载。

这是我的夸脱属性

org.quartz.scheduler.instanceName: scheduler
org.quartz.scheduler.instanceId: AUTO
org.quartz.scheduler.skipUpdateCheck: true
org.quartz.threadPool.class: org.quartz.simpl.SimpleThreadPool
org.quartz.threadPool.threadCount: 10
org.quartz.threadPool.threadPriority: 5
org.quartz.jobStore.misfireThreshold: 60000
org.quartz.jobStore.class: org.quartz.impl.jdbcjobstore.JobStoreTX
org.quartz.jobStore.driverDelegateClass: org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
org.quartz.jobStore.useProperties: false
org.quartz.jobStore.dataSource: myDS
org.quartz.jobStore.tablePrefix: QRTZ_
org.quartz.jobStore.isClustered: true
org.quartz.dataSource.myDS.driver: org.postgresql.Driver
org.quartz.dataSource.myDS.URL: ${APP_JDBC_URL:-jdbc:postgresql://localhost:5432/db}
org.quartz.dataSource.myDS.user:  ${APP_JDBC_USER:-user}
org.quartz.dataSource.myDS.password: ${APP_JDBC_PASSWORD:-pass}
org.quartz.dataSource.myDS.maxConnections: 5
org.quartz.dataSource.myDS.validationQuery: select 1

例外：

ERROR [2018-03-13 21:11:13,958] org.quartz.impl.jdbcjobstore.JobStoreTX: ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Connections could not be acquired from the underlying database!
! com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
! at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
! at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
! at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
! at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
! ... 26 common frames omitted

Answer 1

quartz.properties文件通过以下约定读取环境变量：$@environment_variable_name。

例如，这正在我的应用程序上运行：

org.quartz.threadPool.threadCount=$@QUARTZ_THREAD_COUNT

在您的情况下，您应该能够使用：

org.quartz.dataSource.myDS.URL=$@APP_JDBC_URL
org.quartz.dataSource.myDS.user=$@APP_JDBC_USER
org.quartz.dataSource.myDS.password=$@APP_JDBC_PASSWORD

Answer 2

请不要使用连字符

org.quartz.dataSource.myDS.URL:$｛APP_JDBC_URL:JDBC:postgresql://localhost:5432/db}org.quartz.dataSource.myDS.user:$｛APP_JDBC_user:user｝org.quartz.dataSource.myDS.密码：$｛APP_JDBC_password:pass｝

例如，我的配置是有效的：adb.datasource.url=${DB1_url:jdbc:sqlserver://127.0.0.1:1433；databaseName=authdb｝