==> Preparing: update T_USER SET DEPARTMENT_ID = "" WHERE DEPARTMENT_ID=?
==> Parameters: 70(String)
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-01741: 非法的零长度标识符
### The error may involve userMapper.setEmpty-Inline
### The error occurred while setting parameters
### SQL: update T_USER SET DEPARTMENT_ID = "" WHERE DEPARTMENT_ID=?
### Cause: java.sql.SQLSyntaxErrorException: ORA-01741: 非法的零长度标识符
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-01741: 非法的零长度标识符
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:91)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)
at com.sun.proxy.$Proxy15.update(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:250)
at com.ynd.dao.UserDAO.setEmpty(UserDAO.java:25)
at com.ynd.service.impl.UserServiceImpl.setEmptyUserDepartmentId(UserServiceImpl.java:82)
at com.ynd.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$10b38bc1.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transa
bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-01741: 非法的零长度标识符
最新推荐文章于 2024-05-14 19:33:25 发布
在使用MyBatis进行持久层操作时,针对Oracle 12c数据库,遇到SQL语法错误,具体表现为非法的零长度标识符异常。解决办法是,在设置表字段为空的SQL语句中,应当使用单引号而非双引号。
摘要由CSDN通过智能技术生成