日期:2014-05-17  浏览次数:21128 次

做了一次数据库迁移,原本正常的程序出错:invalid identifier
高手帮忙 
STRUTS + SPRING + IBATIS 

sqlmap 是 abator 生成,迁移一次库,其他没有做任何事情,在spring中配置数库地址。改成新库就报错,改成老库就没问题,重新建表问题依然存在! 


org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/together/sys/persistence/ICAPP_SqlMap.xml. --- The error occurred while applying a parameter map. --- Check the gcrm_T_PMS_ICAPP.abatorgenerated_insert-InlineParameterMap. --- Check the statement (update failed). --- Cause: java.sql.SQLException: ORA-00904: "ICA_DEL_FLAG": invalid identifier

------解决方案--------------------
LZ去JAVA版问应该更好