注册

o enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.minute

2024/06/28 378 1

The error may exist in file [D:\Users\scheduledtask\target\classes\mybatis\pw\TPwRemindMapper.xml]

The error may involve com.cdkj.project.pw.mapper.TPwRemindMapper.selectListForWarn-Inline

The error occurred while setting parameters

SQL: /!mycat:schema=dnCd/select t.* from t_pw_remind t where t.del_flag = '0' and exists (select 'X' from sys_dept d where d.dr = 0 and t.dept_pk = d.pk_id and d.org_pk = ?) and t.remind_date = date_format(?,'%Y-%m-%d') and t.restrict_end_time < date_add(?, interval '10' minute) -- 提醒结束时间小于(当前时间+延迟时间) and t.status = 10 and t.sign_pk is null order by t.pk_id asc

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.minute

; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: No enum constant com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleIntervalType.minute
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:236)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy137.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
at com.sun.proxy.$Proxy338.selectListForWarn(Unknown Source)
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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:58)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:241)
at com.sun.proxy.$Proxy339.selectListForWarn(Unknown Source)
at com.cdkj.project.pw.service.impl.TPwRemindServiceImpl.lambda$dealWarnTask$14(TPwRemindServiceImpl.java:791)
at java.util.ArrayList.forEach(ArrayList.java:1257)
at com.cdkj.project.pw.service.impl.TPwRemindServiceImpl.dealWarnTask(TPwRemindServiceImpl.java:790)
at com.cdkj.project.pw.service.impl.TPwRemindServiceImpl$$FastClassBySpringCGLIB$$a5609b19.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

错误

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