ORA-00933: SQL 命令未正确结束

来源：互联网发布：八爪鱼淘宝营销大师编辑：程序博客网时间：2024/06/07 03:22

org.springframework.jdbc.BadSqlGrammarException:

### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

### The error may involve com.hotent.platform.model.system.SysUser.update-Inline
### The error occurred while setting parameters
### SQL: UPDATE sys_user SET fullname=? , account=? , password=? , isExpired=? , isLock=? , createtime=? , status=? , email=? , mobile=? , phone=? , sex=? , picture=?, fromType=?, entrydate=?, userStatus=?, pwdUpdTime=?, hasSyncToWx =?, weixinid =?, postId=?, postName=?, professionalId=?, professionalName=?, educationId=?, educationName=?, jobGrade=?, jobAge=?, companyAge=?, graduationDate=?, regularDate=?, leaveDate=?, IDENTIFICATION_CARDID=?, BIRTHDAY_DATE=?, AGES=?, JOB_DATE=?, SOCIAL_SECURITYNUM=?, SOCIAL_SECURITY_DEPART=?, NATION=?, POLITICAL_STATUS=?, HOUSEHOLDS=?, BIRTH_PLACE=?, ADDRESS=?, LINKMAN=?, RELATIONSHIP=?, LINKPHONE=?, PROBATION_SALARY=?, PAYMENT_PLACE=?, LEAVE_TYPE=?, IDENTIFICATION_EXPIRE=?, COMMUNICATION_PHONE=?, MOBILE_PHONE=?, OTHER_PHONE=?, WORKADDRESS=?, STATE=?, GRADUATESCHOOL=?, SPECIALTY=?, EDUCATIONAL_DEGREE=? jobnum=? WHERE userId=?
### Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)
at com.sun.proxy.$Proxy10.update(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:250)

结果发现, SPECIALTY=?, EDUCATIONAL_DEGREE=? jobnum=? WHERE userId=?之间少量一个逗号“,”

写sql语句一定要认真啊！！！！！！！！！！

阅读全文

0 0