ORA-00933: SQL 命令未正确结束_唱响星河的博客

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语句一定要认真啊！！！！！！！！！！

org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束### The error may involve com.hotent.platform.mode

公司服务器周末要加硬盘，周一来后应用连不上了。报错如下报错： ORA -12170:TNS connect timeout occurred 第一反应是监听没开： 1. 测试了一下，连接超时没用ping 通 C:\Users\Administrator>tnsping brorcl TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 – Production on 15-6月 -2015 09:45:43 已使用的参数文件

My SQL java. sql . SQL SyntaxErrorException: You have an error in your SQL syntax 关键字异常处理

### Error updating database. Cause: java. sql . SQL SyntaxErrorException: ORA -00947: 没有足够的值 ### The error may involve com.esoon.ids.dao.mapper.ModelConvertRuleMapper.saveConvertRules-Inline ### The error occurred while setting parameters ### SQL : insert into.

My SQL 中，批量插入数据到表，会在一定程度提高效率。 insert into table （column1, column2）values(value1, value2), (value1, value2) 对于List<Map<String, Object>>类型的参数，使用mybatis实现上面语句需要用到动态 SQL –forea

java. sql . SQL SyntaxErrorException: ORA -00923: 未找到要求的 FROM 关键字 ssm( Ora cle)配置druid数据库连接池，正常启动项目，但是请求访问数据库时报错 “java. sql . SQL SyntaxErrorException: ORA -00923: 未找到要求的 FROM 关键字” jdbc配置 validationQuery:SELE...

### Error updating database. Cause: java. sql . SQL SyntaxErrorException: Unknown column 'province' in

### Error updating database. Cause: java. sql . SQL SyntaxErrorException: Unknown column 'province' in 'field list' ### The error may involve defaultParameterMap ### The error occurred while setting para...

最近在使用MyBatis操作 Ora cle数据库的时候，进行批量插入数据，思路是封装一个List集合通过Myabtis 的foreach标签进行循环插入，可是搬照My sql 的批量插入会产生异常　　### Error updating database. Cause: java. sql . SQL SyntaxErrorException: ORA - 00933 : SQL 命令未正确结束错误的写法如下 <insert id="insertExpenseItem" parameterType=.

centos7安装mysql8报错mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared 我这没有用。。 JS中根据入职时间计算工龄安_soul: myDate,month,day的声明都没写哦 springboot连接oracle时报错：不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK poyi2008: 引入的版本和ojdbc保持一致 centos7安装mysql8报错mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared wanglei19930504: 怎么建立的啊