注册

nearby [>] has error: Syntax error

hh 2024/12/13 474 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: DM 8
【操作系统】:win11
【CPU】: 锐龙 5800h
【问题描述】*: nearby [>] has error: Syntax error,但 sql 里没有 “>” 这个符号。

... ecord_overdue_count_forestry, pick_record_count_fishery, pick_record_overdue_count_fishery, pick_record_count_animal, pick_record_overdue_count_animal, pick_record_sale_count_agri, pick_record_sale_overdue_count_agri, pick_record_sale_count_forestry, pick_record_sale_overdue_count_forestry, pick_record_sale_count_fishery, pick_record_sale_overdue_count_fishery, pick_record_sale_count_animal, pick_record_sale_overdue_count_animal, total_farm_count, total_mission_farm_count, total_not_mission_farm_count, total_mission_count, total_overdue_count, not_mission_farm_rate, mission_rate, create_time, update_time) values (t.areaId,t.areaName,t.archiveDayStr,t.plantPlanCountAgri,t.plantPlanOverdueCountAgri,t.plantPlanCountAnimal,t.plantPlanOverdueCountAnimal,t.plantPlanCountFishery,t.plantPlanOverdueCountFishery,t.plantPlanCountForestry,t.plantPlanOverdueCountForestry,t.fertilizerCount,t.fertilizerOverdueCount,t.feedingCount,t.feedingOverdueCount,t.chargingCount,t.chargingOverdueCount,t.medicationCount,t.medicationOverdueCount,t.medicationCountAnimal,t.medicationOverdueCountAnimal,t.medicationCountFishery,t.medicationOverdueCountFishery,t.missionCategoryCountOther,t.missionCategoryOverdueCountOther,t.pickRecordCountAgri,t.pickRecordOverdueCountAgri,t.pickRecordCountForestry,t.pickRecordOverdueCountForestry,t.pickRecordCountFishery,t.pickRecordOverdueCountFishery,t.pickRecordCountAnimal,t.pickRecordOverdueCountAnimal,t.pickRecordSaleCountAgri,t.pickRecordSaleOverdueCountAgri,t.pickRecordSaleCountForestry,t.pickRecordSaleOverdueCountForestry,t.pickRecordSaleCountFishery,t.pickRecordSaleOverdueCountFishery,t.pickRecordSaleCountAnimal,t.pickRecordSaleOverdueCountAnimal,t.totalFarmCount,t.totalMissionFarmCount,t.totalNotMissionFarmCount,t.totalMissionCount,t.totalOverdueCount,t.notMissionFarmRate,t.missionRate,now(),now())
### Cause: dm.jdbc.driver.DMException: line 4, column 1291981, nearby [>] has error: 
Syntax error
; bad SQL grammar []; nested exception is dm.jdbc.driver.DMException: line 4, column 1291981, nearby [>] has error: 
Syntax error
	org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:82)
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
com.sun.proxy.$Proxy121.insert(Unknown Source)
org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:142)
org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
com.sun.proxy.$Proxy368.batchInsert(Unknown Source)
com.za.archive.manage.ArchiveFarmInfoReportAreaManage.batchInsertDay(ArchiveFarmInfoReportAreaManage.java:68)
com.za.archive.manage.ArchiveFarmInfoReportAreaManage.doSyncDay(ArchiveFarmInfoReportAreaManage.java:53)
com.za.archive.task.ArchiveFarmInfoReportAreaDayTask.doSyncDay(ArchiveFarmInfoReportAreaDayTask.java:32)
com.za.archive.task.ArchiveFarmInfoReportAreaDayTask$$FastClassBySpringCGLIB$$3fc53d5d.invoke(<generated>)
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)
com.za.archive.task.aspect.TaskLogAspect.interceptor(TaskLogAspect.java:88)
sun.reflect.GeneratedMethodAccessor1200.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)
com.za.archive.task.ArchiveFarmInfoReportAreaDayTask$$EnhancerBySpringCGLIB$$4bfd0fe1.doSyncDay(<generated>)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)
回答 0
暂无回答
扫一扫
联系客服