注册

sql报错

文春 2024/08/16 400 5

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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:

Error querying database. Cause: dm.jdbc.driver.DMException: 第 33 行, 第 11 列[]附近出现错误:

语法分析出错

The error may exist in URL [jar:file:/home/oOceanStorageManager/osc/OSC_V3.5.3.12_lib/osms_service-3.5.312-SNAPSHOT.jar!/com/netzon/osms/oOcean/model/mapper/OCompTaskMapper.xml]

The error may involve OCompTask.getTaskOrderLev

The error occurred while executing a query

SQL: SELECT OC_TASK_ID , NODE_ID , OC_TASK_PID , OC_TASK_GID , OC_TASK_TYPE , OC_TASK_STATE , TASK_RESULT_CODE , TASK_RESULT_TITLE , TASK_RESULT_MSG , MT_TASK_ID , TASK_SCOPE , TASK_PROTYPE , TASK_MODE , QUEUE_TYPE , TASK_LEVEL , DISC_ID , VOL_ID , POOL_ID , DEV_ID , TASK_SOURCE , TASK_TARGET , IMP_SID , IMP_TID , DRV_SID , DRV_TID , MAG_SID , MAG_TID , DISC_RAID_GID, SLOT_SID , SLOT_TID , BIN_SID , BIN_TID , PRINT_SID , PRINT_TID , INVERTER_SID, INVERTER_TID, PDISC_ID , FILE_ID , START_TIME , END_TIME , "CONTEXT" , REMARK , PROGRESS , DRIVE_NAME , DEVICE_NAME , IMAGEPATH , CMD_TYPE , CREATE_TIME , ACC_CNF_ID , DISC_INVERT FROM cs_optical_ocmptask WHERE 1=1 AND cs_optical_ocmptask.NODE_ID = ? AND OC_TASK_TYPE = ? AND OC_TASK_STATE = ? AND DEV_ID = ? ORDER BY cs_optical_ocmptask.TASK_LEVEL DESC, cs_optical_ocmptask.CREATE_TIME ASC, cs_optical_ocmptask.OC_TASK_PID ASC limit ?

Cause: dm.jdbc.driver.DMException: 第 33 行, 第 11 列[]附近出现错误:

语法分析出错
; 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)

回答 0
暂无回答
扫一扫
联系客服