为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:win10
【CPU】:
【问题描述】*:
18:32:04.670 [CtrlName:DevCmdCtrl] INFO c.n.o.c.o.c.c.BaseCmdTaskCtrl (BaseCmdTaskCtrl.java:425) - start sync 2105 door status
18:32:04.673 [CtrlName:DevCmdCtrl] INFO c.n.o.c.o.c.p.DevReadElementCmdTaskProcessor (DevReadElementCmdTaskProcessor.java:74) - ReadElement 2105 Door Start:1 Number:1
org.springframework.jdbc.BadSqlGrammarException:
语法分析出错
语法分析出错
; bad SQL grammar []; nested exception is dm.jdbc.driver.DMException: 第 33 行, 第 11 列[]附近出现错误:
语法分析出错
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
at com.sun.proxy.$Proxy18.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at com.netzon.osms.oOcean.dao.OCompTaskDao.getTaskOrderLev(OCompTaskDao.java:87)
at com.netzon.oraid.cmp.octask.controller.BaseOCompTaskCtrl.runProcess(BaseOCompTaskCtrl.java:197)
at com.netzon.oraid.cmp.octask.controller.BaseOCompTaskCtrl$1.run(BaseOCompTaskCtrl.java:164)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:750)
直接拿sql在管理工具并不报错 不知道日志为啥一直喷这种错误 日志打印报错列还是乱码 我是用的免费的做适配
select * from SYS."V$RUNTIME_ERR_HISTORY";数据库里面查下,把对应的sql拿出来放到客户端里面执行看看是否正常;
查下 OCompTaskMapper.xml 这个文件是不是编码格式有问题