数据插入

09:07:36.078 [DEBUG][main][java.sql.Connection] - {conn-100045} Preparing Statement:    insert into RS_ACTIONRECORD(ACTIONNAME, SYSTRNID, OLDSTATUS, NEWSTATUS, AUDITTIMESTAMP, WORKER)   values(?,?,?,?,?,?)  
09:07:36.078 [DEBUG][main][java.sql.PreparedStatement] - {pstm-100046} Executing Statement:    insert into RS_ACTIONRECORD(ACTIONNAME, SYSTRNID, OLDSTATUS, NEWSTATUS, AUDITTIMESTAMP, WORKER)   values(?,?,?,?,?,?)  
09:07:36.078 [DEBUG][main][java.sql.PreparedStatement] - {pstm-100046} Parameters: [0, SAS123, p2, p1, 19700101080000, zhangsan]
09:07:36.078 [DEBUG][main][java.sql.PreparedStatement] - {pstm-100046} Types: [java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.Long, java.lang.String]
09:07:36.109 [INFO ][main][org.springframework.beans.factory.xml.XmlBeanDefinitionReader] - Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
09:07:36.125 [INFO ][main][org.springframework.jdbc.support.SQLErrorCodesFactory] - SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/erayt/eds/risk/dao/ibatis/db2/ActionRecord.xml.  
--- The error occurred while applying a parameter map.  
--- Check the ActionRecordDao1.insert-InlineParameterMap.  
--- Check the statement (update failed).  

--- Cause: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=OLDSTATUS, DRIVER=3.57.82



这个时候检查一下表字段是否改变,刚刚遇到的问题,昨天还好好的,早上一来就不行了,原来是被人把表的字段改变了


欢迎关注公众号:Java后端技术全栈