Home > Back-end >  Mybatis batch update operation is unusual, database postgres Sql in the database operation (normal)
Mybatis batch update operation is unusual, database postgres Sql in the database operation (normal)

Time:01-27

Mapper configuration:
The update fm_attach_detail attach

Remark=fromData remark,
Valid=fromData. Valid,
Modify_user=fromData. ModifyUser: : INTEGER

The from (values
# # {item id}, {item. RefId}, # {item. Remark}, # # {item. ModifyUser}, {item. Valid}


) as fromData (id, refId, remark, modifyUser, valid)

Attach. Valid='0' AND fromData. Id: : INTEGER=attach. The id AND attach. Ref_id=fromData. RefId


Part of the abnormal information:
Org. Springframework. JDBC. UncategorizedSQLException:
# # # Error updating the database. Cause: Java, SQL. SQLException: SQL injection violation, syntax Error: Error pos 235, line 3, 98, the column token COMMA: update fm_attach_detail attach
The SET remark=fromData remark, valid=fromData. Valid, modify_user=fromData. ModifyUser: : INTEGER
The from (values (?,?,?,?,? ,? ,? ,? ,? ), (? ,? ,? ,? ,? ), (? ,? ,? ,? ,? )) as fromData (id, refId, remark, modifyUser, valid)
WHERE the attach. Valid='0' AND fromData. Id: : INTEGER=attach. Id AND attach. Ref_id=fromData. RefId
# # # : SQL update fm_attach_detail attach SET remark.=fromData remark, valid=fromData. Valid, modify_user=fromData. ModifyUser: : INTEGER from (values (?,?,?,?,? ,? ,? ,? ,? ), (? ,? ,? ,? ,? ), (? ,? ,? ,? ,? )) as fromData (id, refId, remark, modifyUser, valid) WHERE the attach. Valid='0' AND fromData. Id: : INTEGER=attach. Id AND attach. Ref_id=fromData. RefId
# # # Cause: Java. SQL. SQLException: SQL injection violation, syntax error: error pos 235, line 3, 98, the column token COMMA: update fm_attach_detail attach
The SET remark=fromData remark, valid=fromData. Valid, modify_user=fromData. ModifyUser: : INTEGER
The from (values (?,?,?,?,? ,? ,? ,? ,? ), (? ,? ,? ,? ,? ), (? ,? ,? ,? ,? )) as fromData (id, refId, remark, modifyUser, valid)
WHERE the attach. Valid='0' AND fromData. Id: : INTEGER=attach. Id AND attach. Ref_id=fromData. RefId
; Uncategorized SQLException for SQL []; SQL state (null), The error code [0]. SQL injection violation, syntax error: error pos 235, line 3, 98, the column token COMMA: update fm_attach_detail attach
The SET remark=fromData remark, valid=fromData. Valid, modify_user=fromData. ModifyUser: : INTEGER
The from (values (?,?,?,?,? ,? ,? ,? ,? ), (? ,? ,? ,? ,? ), (? ,? ,? ,? ,? )) as fromData (id, refId, remark, modifyUser, valid)
WHERE the attach. Valid='0' AND fromData. Id: : INTEGER=attach. Id AND attach. Ref_id=fromData. RefId; Nested exception is Java. SQL. SQLException: SQL injection violation, syntax error: error pos 235, line 3, 98, the column token COMMA: update fm_attach_detail attach
The SET remark=fromData remark, valid=fromData. Valid, modify_user=fromData. ModifyUser: : INTEGER
The from (values (?,?,?,?,? ,? ,? ,? ,? ), (? ,? ,? ,? ,? ), (? ,? ,? ,? ,? )) as fromData (id, refId, remark, modifyUser, valid)
WHERE the attach. Valid='0' AND fromData. Id: : INTEGER=attach. Id AND attach. Ref_id=fromData. RefId
The at org. Springframework. JDBC. Support. AbstractFallbackSQLExceptionTranslator. Translate (AbstractFallbackSQLExceptionTranslator. Java: 90)
The at org. Springframework. JDBC. Support. AbstractFallbackSQLExceptionTranslator. Translate (AbstractFallbackSQLExceptionTranslator. Java: 82)
The at org. Springframework. JDBC. Support. AbstractFallbackSQLExceptionTranslator. Translate (AbstractFallbackSQLExceptionTranslator. Java: 82)
The at org. Mybatis. Spring. MyBatisExceptionTranslator. TranslateExceptionIfPossible (MyBatisExceptionTranslator. Java: 73)
The at org. Mybatis. Spring. SqlSessionTemplate $SqlSessionInterceptor. Invoke (SqlSessionTemplate. Java: 446)
At com. Sun. Proxy. $Proxy99. Update (Unknown Source)
The at org. Mybatis. Spring. SqlSessionTemplate. Update (SqlSessionTemplate. Java: 294)
The at org. Apache. Ibatis. Binding. MapperMethod. Execute (MapperMethod. Java: 62)
The at org. Apache. Ibatis. Binding. MapperProxy. Invoke (MapperProxy. Java: 59)
At com. Sun. Proxy. $Proxy111. CancelImport (Unknown Source)
At sun. Reflect. NativeMethodAccessorImpl. Invoke0 (Native Method)
At sun. Reflect. NativeMethodAccessorImpl. Invoke (NativeMethodAccessorImpl. Java: 62)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (498) Method. The Java:
The at org. Springframework. Aop. Support. AopUtils. InvokeJoinpointUsingReflection (AopUtils. Java: 333)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. InvokeJoinpoint (ReflectiveMethodInvocation. Java: 190)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. Proceed (ReflectiveMethodInvocation. Java: 157)
The at org. Springframework. Dao. Support. PersistenceExceptionTranslationInterceptor. Invoke (PersistenceExceptionTranslationInterceptor. Java: 136)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull