数据插入
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后端技术全栈