Quartz属性文件传入环境变量

2024-04-07

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

这是我的quartz.properties

  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

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
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

Quartz属性文件传入环境变量 的相关文章

随机推荐