quartz启动 mysql报错_使用Quartz2.2.3做持久化，启动程序后，控制台报错问题

最新推荐文章于 2023-02-27 14:05:04 发布

Justmeet

最新推荐文章于 2023-02-27 14:05:04 发布

阅读量1.8k

点赞数

文章标签： quartz启动 mysql报错

本文链接：https://blog.csdn.net/weixin_35034831/article/details/113653927

版权

在使用Quartz 2.2.3进行持久化操作并启动程序时，遇到由于mysql-connector-java.jar版本过低导致的错误。错误信息显示SQL语法错误，提示在'OPTION SQL_SELECT_LIMIT=1'处的语法不正确。建议升级mysql-connector-java.jar版本以解决问题。

摘要由CSDN通过智能技术生成

该错误是由mysql-connector-java.jar版本太低导致。

MLog clients using log4j logging.

Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; trace: 10]

Using default implementation for ThreadExecutor

Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl

Quartz Scheduler v.2.2.3 created.

Using thread monitor-based data access locking (synchronization).

JobStoreTX initialized.

Scheduler meta-data: Quartz Scheduler (v2.2.3) 'MyScheduler' with instanceId 'NON_CLUSTERED'

Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.

NOT STARTED.

Currently in standby mode.

Number of jobs executed: 0

Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 3 threads.

Using job-store 'org.quartz.impl.jdbcjobstore.JobStoreTX' - which supports persistence. and is not clustered.

Quartz scheduler 'MyScheduler' initialized from default resource file in Quartz package: 'quartz.properties'

Quartz scheduler version: 2.2.3

Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge2tf9q16dwpqolmzby|104c89a4, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge2tf9q16dwpqolmzby|104c89a4, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/api?characterEncoding=utf-8, lastAcquisitionFailureDefaultUser -> null, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 0, maxStatementsPerConnection -