67 网友分享了链接
2020-08-16 06:58:51
是大写的，运行时报的错能证明
java.lang.IllegalStateException: Failed to execute CommandLineRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:798) at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:779) at org.springframework.boot.SpringApplication.run(SpringApplication.java:322) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) at org.xingxj.AdminApplication.main(AdminApplication.java:22) Caused by: org.xingxj.common.exception.MyException: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'started.QRTZ_LOCKS' doesn't exist [See nested exception: java.sql.SQLSyntaxErrorException: Table 'started.QRTZ_LOCKS' doesn't exist] at org.xingxj.modules.job.utils.ScheduleUtils.updateScheduleJob(ScheduleUtils.java:104) at org.xingxj.modules.job.init.JobCommandLineRunner.run(JobCommandLineRunner.java:35) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:795) ... 5 common frames omitted Caused by: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'started.QRTZ_LOCKS' doesn't exist at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157) at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113) at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:238) at org.quartz.impl.jdbcjobstore.JobStoreSupport.replaceTrigger(JobStoreSupport.java:1474) at org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1115) at org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:321) at org.xingxj.modules.job.utils.ScheduleUtils.updateScheduleJob(ScheduleUtils.java:96) ... 7 common frames omitted Caused by: java.sql.SQLSyntaxErrorException: Table 'started.QRTZ_LOCKS' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3188) at com.alibaba.druid.wall.WallFilter.preparedStatement_executeQuery(WallFilter.java:641) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3185) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3185) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:181) at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:228) at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96) ... 13 common frames omitted
据错可知 是大写的，在mysql 表名大小写区分是有这个问题