主题 : jeecms x是不是不支持mysql8? |
级别: 论坛管理员
![]() |
11# 发表于:2019-10-17 14:42:21 IP:117.152.*.*
|
||||
---|---|---|---|---|---|
级别: 贡士
![]() |
12# 发表于:2019-10-17 14:44:01 IP:117.71.*.*
回复第11楼那麻烦你再帮我看看这个错,启动成功后,报了一个这个错,但是好像不影响
Exception in thread "Quartz Scheduler [schedulerFactoryBean]" org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler after delay; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1]] at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:733) Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(UPDLOCK,ROWLOCK) WHERE SCHED_NAME = 'schedulerFactoryBean' AND LOCK_NAME = 'TRI' at line 1]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:697) at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:539) at org.quartz.impl.StdScheduler.start(StdScheduler.java:142) at org.springframework.scheduling.quartz.SchedulerFactoryBean$1.run(SchedulerFactoryBean.java:730) |
||
---|---|---|---|
级别: 贡士
![]() |
14# 发表于:2019-10-17 15:04:16 IP:117.71.*.*
回复第13楼
换成eclipse可以了,谢谢 |
||
---|---|---|---|