新增了个字段,保存就报错

2015-08-12 12:22:39,821 [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]-[INFO] Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2015-08-12 12:22:39,875 [org.springframework.jdbc.support.SQLErrorCodesFactory]-[INFO] SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
2015-08-12 12:22:39,884 [pay.lewan.control.LewanPayOrderControl]-[INFO] Error http goPayConfigrm errorCode:lw001,payCode:0516DC59C2341439353359356;PreparedStatementCallback; bad SQL grammar []; nested exception is java.sql.SQLException: No value specified for parameter 46

新增了个字段,保存时候报错

检查一下字段和值是否一一对应

打印一下新增的SQL语句,最有可能出现的就是少写了问号,或者写了问号然后没有传入值(必须一一对应)

bad SQL grammar []; nested exception is java.sql.SQLException: No value specified for parameter 46
有一个字段没传值,

打印SQL,放到数据库执行一下,看看哪里报错