java.sql.SQLSyntaxErrorException: ORA-01776: 无法通过联接视图修改多个基表

Question

这个问题要怎么处理啊
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com
.ibatis.common.jdbc.exception.NestedSQLException:
The error occurred in com/ufgov/fm/resource/ibatis/AD68.xml.
The error occurred while applying a parameter map.
Check the AD68.updateAD61ForSingleResult-InlineParameterMap.
Check the statement (update failed).
Cause: java.sql.SQLSyntaxErrorException: ORA-01776: 无法通过联接视图修改多个基表

Answer 1

如果你的视图里是基于多个表join出来的数据，那么这个视图是无法进行update操作的，老老实实去一张一张表更新吧