注册

dm.jdbc.driver.DMException: line 6, column 10, nearby [`] has error:

Hwei 2023/11/28 1321 3

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:linux
【CPU】:
【问题描述】*:
Syntax error

The error may exist in URL [jar:file:/home/Application/api-v5.jar!/BOOT-INF/lib/sqn-service-user-5.0.0.jar!/mapper/UserAccountMapper.xml]

The error may involve com.sqn.service.user.dao.UserAccountDao.findByMachineCode

The error occurred while executing a query

SQL: select user_id ,user_name ,account ,type ,password ,salt ,machine_code ,view_code ,create_time ,expired_time ,is_delete ,status from account_user_account WHERE machine_code = ? and is_delete = 1

Cause: dm.jdbc.driver.DMException: line 6, column 10, nearby [`] has error:

Syntax error
; bad SQL grammar []; nested exception is dm.jdbc.driver.DMException: line 6, column 10, nearby [`] has error:
Syntax error
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
at com.sun.proxy.$Proxy100.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:90)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy101.findByMachineCode(Unknown Source)
at com.sqn.service.user.service.impl.UserAccountServiceImpl.findByMachineCode(UserAccountServiceImpl.java:38)
at com.sqn.service.user.service.impl.UserAccountServiceImpl$$FastClassBySpringCGLIB$$35408e49.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)
at com.sqn.service.user.service.impl.UserAccountServiceImpl$$EnhancerBySpringCGLIB$$d5df4d5.findByMachineCode(<generated>)
at com.sqn.service.user.service.impl.UserAccountServiceImpl$$FastClassBySpringCGLIB$$35408e49.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)
at com.sqn.service.user.service.impl.UserAccountServiceImpl$$EnhancerBySpringCGLIB$$f4ea6319.findByMachineCode(<generated>)
at com.sqn.api.user.controller.login.LoginController.hztLogin(LoginController.java:415)
at com.sqn.api.user.controller.login.LoginController$$FastClassBySpringCGLIB$$2741df12.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
at com.sqn.service.core.Aspect.ControllerAspect.invokeAPI(ControllerAspect.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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