设为首页收藏本站

JEECG官方网站-企业级JAVA快速开发平台

 找回密码
 立即注册

关注JEECG发展历程 关注最新动态和版本, 记录JEECG成长点滴 最新动态 - 技术支持 - 师徒架构班

JEECG最新版本下载 JEECG智能开发平台 - 显著提高开发效率 常见问题 - 入门视频 - 参与开源团队

商务 QQ: 3102411850、418799587 商务热线: 18611788525 客服电话: 010-64808099 官方邮箱: jeecgos@163.com

查看: 47|回复: 0

数据源改成DM后,求助以下问题解决方法

[复制链接]

2

主题

0

好友

46

积分

新手上路

Rank: 2

发表于 2019-8-26 18:34:06 |显示全部楼层
应该是初始化Quartz的时候,找不到对应的表名称,因为数据源换成了达梦,改成JEECGBOOT.QRTZ_LOCKS可以执行,所以报错的原因是表名缺少前缀导致,在那个地方取QRTZ_LOCKS表校验的地方的?我想修改代码通过配置文件统一加上前缀

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2019-08-26 17:23:24.136 [main] ERROR org.springframework.boot.SpringApplication:858 - Application run failed
org.springframework.context.ApplicationContextException: Failed to start bean 'quartzScheduler'; nested exception is org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: 第1 行附近出现错误:
无效的表或视图名[QRTZ_LOCKS] [See nested exception: java.sql.SQLException: 第1 行附近出现错误:
无效的表或视图名[QRTZ_LOCKS]]]
        at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:185)
        at org.springframework.context.support.DefaultLifecycleProcessor.access$200(DefaultLifecycleProcessor.java:53)
        at org.springframework.context.support.DefaultLifecycleProcessor$LifecycleGroup.start(DefaultLifecycleProcessor.java:360)
        at org.springframework.context.support.DefaultLifecycleProcessor.startBeans(DefaultLifecycleProcessor.java:158)
        at org.springframework.context.support.DefaultLifecycleProcessor.onRefresh(DefaultLifecycleProcessor.java:122)
        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:893)
        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.finishRefresh(ServletWebServerApplicationContext.java:163)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:552)
        at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:142)
        at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775)
        at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:316)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1260)
        at org.springframework.boot.SpringApplication.run(SpringApplication.java:1248)
        at org.jeecg.JeecgApplication.main(JeecgApplication.java:22)
Caused by: org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: 第1 行附近出现错误:
无效的表或视图名[QRTZ_LOCKS] [See nested exception: java.sql.SQLException: 第1 行附近出现错误:
无效的表或视图名[QRTZ_LOCKS]]]
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.start(SchedulerFactoryBean.java:802)
        at org.springframework.context.support.DefaultLifecycleProcessor.doStart(DefaultLifecycleProcessor.java:182)
        ... 14 common frames omitted
Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery.
        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.startScheduler(SchedulerFactoryBean.java:727)
        at org.springframework.scheduling.quartz.SchedulerFactoryBean.start(SchedulerFactoryBean.java:799)
        ... 15 common frames omitted
Caused by: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: 第1 行附近出现错误:
无效的表或视图名[QRTZ_LOCKS]
        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.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3842)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverJobs(JobStoreSupport.java:839)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.schedulerStarted(JobStoreSupport.java:695)
        ... 19 common frames omitted
Caused by: java.sql.SQLException: 第1 行附近出现错误:
无效的表或视图名[QRTZ_LOCKS]
        at dm.jdbc.dbaccess.DBError.throwSQLException(DBError.java:44)
        at dm.jdbc.dbaccess.Request_Response.resp_checkErr(Request_Response.java:2457)
        at dm.jdbc.dbaccess.Request_Response.resp_prepare(Request_Response.java:676)
        at dm.jdbc.dbaccess.DmdbCSI.prepareSQL(DmdbCSI.java:379)
        at dm.jdbc.driver.DmdbStatement_bs.directExec(DmdbStatement_bs.java:1783)
        at dm.jdbc.driver.DmdbPreparedStatement_bs.initialize(DmdbPreparedStatement_bs.java:248)
        at dm.jdbc.driver.DmdbPreparedStatement_bs.<init>(DmdbPreparedStatement_bs.java:188)
        at dm.jdbc.driver.DmdbConnection_bs.prepareStatement(DmdbConnection_bs.java:2087)
        at dm.jdbc.driver.DmdbConnection_bs.prepareStatement(DmdbConnection_bs.java:707)
        at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:1687)
        at dm.jdbc.filter.FilterChain.Connection_prepareStatement(FilterChain.java:539)
        at dm.jdbc.driver.DmdbConnection.prepareStatement(DmdbConnection.java:198)
        at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:572)
        at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:930)
        at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)
        at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568)
        at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:930)
        at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)
        at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568)
        at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:341)
        at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:349)
        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.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:73)
        at com.sun.proxy.$Proxy234.prepareStatement(Unknown Source)
        at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:88)
        ... 23 common frames omitted

您需要登录后才可以回帖 登录 | 立即注册

Archiver|手机版|JEECG技术论坛 - 基于BPM的JAVA快速开发平台 ( 京ICP备12013567号-3 )  

GMT+8, 2019-9-19 14:33 , Processed in 1.216802 second(s), 21 queries , Gzip On.

JEECG Open Source

© 2001-2012 Comsenz Inc.

回顶部