weblogic 整合quartz 报错

Question

Nov 06, 2019 4:05:24 AM com.sgcc.uap.kernel.helper.ModuleSRModelHelper setServiceInTargetSource
信息: 引入服务，发布该服务的模块是 Dynamic-Module : [hqmisUtils], ServiceRef : {com.suypower.hqmis.util.springEx.JdbcTemplateEx}={platform_service_idname=JdbcTemplateService, dynamic_module_name=hqmisUtils, platform_service_target=com.suypower.hqmis.util.springEx.JdbcTemplateEx, uap_service_ranking=0, dynamic_module_service=spring_service, service.id=274}
[2019-11-06 04:05:26,331] Third's :ERROR org.springframework.scheduling.quartz.LocalDataSourceJobStore:3876 - ClusterManager: Error managing cluster: Failure identifying failed instances when checking-in: Unknown system variable 'OPTION'
org.quartz.JobPersistenceException: Failure identifying failed instances when checking-in: Unknown system variable 'OPTION' [See nested exception: java.sql.SQLException: Unknown system variable 'OPTION']
at org.quartz.impl.jdbcjobstore.JobStoreSupport.findFailedInstances(JobStoreSupport.java:3343)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterCheckIn(JobStoreSupport.java:3393)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3253)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3870)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3907)
Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1606)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2265)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectSchedulerStateRecords(StdJDBCDelegate.java:2949)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.findFailedInstances(JobStoreSupport.java:3307)
... 4 more

Answer 1

https://blog.csdn.net/nmcurd/article/details/81489189