版本:java版本,github的最新版。
数据库版本使用的是mysql5.7,部署在linux上。
跟踪了下报错信息,发现是表明的不一致。例如数据库内的表名是 qrtz_triggers,但是语句调用的表名词是 QRTZ_TRIGGERS。
大小写不一致,查询不到表。但是我查询了下全局,只有quartz 的前缀修改。没找到TRIGGER 这个。因为这个数据库有其他的库,所以不考虑进行忽略大小写。望大佬赐教,看是否还有其他的方案
以下是错误日志:
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'scheduleJobServiceImpl': Invocation of init method failed; nested exception is java.lang.RuntimeException: 获取定时任务CronTrigger出现异常 at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:160) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:416) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1788) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1290) at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1210) at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ... 19 common frames omittedCaused by: java.lang.RuntimeException: 获取定时任务CronTrigger出现异常 at com.zbkj.admin.quartz.ScheduleManager.getCronTrigger(ScheduleManager.java:43) at com.zbkj.admin.service.impl.ScheduleJobServiceImpl.lambda$init$0(ScheduleJobServiceImpl.java:51) at java.util.ArrayList.forEach(ArrayList.java:1257) at com.zbkj.admin.service.impl.ScheduleJobServiceImpl.init(ScheduleJobServiceImpl.java:50) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:389) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:333) at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:157) ... 31 common frames omittedCaused by: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Table 'crmeb.QRTZ_TRIGGERS' doesn't exist at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1538) at org.quartz.impl.jdbcjobstore.JobStoreSupport$12.execute(JobStoreSupport.java:1527) at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:245) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeWithoutLock(JobStoreSupport.java:3800) at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1524) at org.quartz.core.QuartzScheduler.getTrigger(QuartzScheduler.java:1505) at org.quartz.impl.StdScheduler.getTrigger(StdScheduler.java:508) at com.zbkj.admin.quartz.ScheduleManager.getCronTrigger(ScheduleManager.java:41) ... 41 common frames omitted
