执行时,异常如下
org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [Insert into User (FirstName1,LastName) values('333','444')] in task 'executing StatementCallback'; nested exception is java.sql.SQLException: Unknown column 'FirstName1' in 'field list'
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:198)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:262)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:283)
com.ce.spring.UserDAO$1.doInTransaction(UserDAO.java:86)
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:114)
com.ce.spring.UserDAO.insertUser(UserDAO.java:81)
org.apache.jsp.index_jsp._jspService(index_jsp.java:74)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [Insert into User (FirstName1,LastName) values('333','444')] in task 'executing StatementCallback'; nested exception is java.sql.SQLException: Unknown column 'FirstName1' in 'field list'
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:198)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:262)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:283)
com.ce.spring.UserDAO$1.doInTransaction(UserDAO.java:86)
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:114)
com.ce.spring.UserDAO.insertUser(UserDAO.java:81)
org.apache.jsp.index_jsp._jspService(index_jsp.java:74)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
解决方案 »
- 如何从Spring 获取 Connection?
- 用maven管理的项目中如何实现不打war包就能部署
- j2ee中公文流转的问题
- J2EE这个大的框架应该要掌握的知识点是什么.
- mysql function 返回值 给100分 急急急
- iframe标签的src属性怎么不能是一个action,或是要设置哪里?
- 给大家推荐一套非常实用的通用查询框架,有完整的Demo、使用说明、示例源码
- weblogic创建连接池报错
- PB中如何解决关于动态工资项目的问题?高手请进!
- 很土的一问,关于sessionbean及jsp中的session
- struts问题,怎么获值呢???
- 用java自动更新dns,谁做过?
try
{
// your operations
}
catch(DataAccessException e)
{
ts.setRollbackOnly();
// ts = TransactionStatus
...other operations
}如果采用programming的方式控制事务,需要手动设置rollback;
但是,如果采用declaring方式,则可以直接在transactionAttributes中指定-DataAccessException就可以自动回滚了。