数据插入
来源:互联网 发布:代购管理系统源码 编辑:程序博客网 时间:2024/05/24 05:52
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).
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
这个时候检查一下表字段是否改变,刚刚遇到的问题,昨天还好好的,早上一来就不行了,原来是被人把表的字段改变了
- 插入数据
- 插入数据
- 插入数据
- 插入数据
- 插入数据
- 插入数据
- 数据插入
- 数据插入
- 插入数据
- 插入数据
- 插入数据
- mongodb批量插入插入数据
- 批量插入数据重复插入
- 插入数据与更新数据
- 插入大量数据
- 插入数据Parameters.add
- 大批量数据的插入
- 批量插入数据集
- 学习VS2010------自制对话框添加页面
- java 面试的一些总结
- Java出现No enclosing instance of type E is accessible. Must qualify the allocation with an enclosing
- oracle用户管理--oracle学习第四天
- Makefile详解
- 数据插入
- jquery的$.extend和$.fn.extend作用及区别
- Java vs. Python (2): Data Types
- div css 实现tabs标签
- Andriod从零单排08_相对布局
- 基于独立服务器SVNServer配置
- cookie记住密码
- Mac OS X上搭建本地SVN服务器
- ora_00845