org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

19 篇文章 0 订阅
1 篇文章 0 订阅
org.apache.jasper.JasperException: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
	org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
	org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181)
	org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
	org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
	org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
	org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
	org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324)
	org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
	com.swl.hibernate.pojo.FinanceOperate.insert(FinanceOperate.java:41)
	org.apache.jsp.AddFinance_005fdo_jsp._jspService(AddFinance_005fdo_jsp.java:109)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'declare, input, output, userid, id) values ('2', '2', '2012年03月31日  17:15:' at line 1
	com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2016)
	com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1452)
	org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
	org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:174)
	org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:226)
	org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
	org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
	org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
	org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324)
	org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
	com.swl.hibernate.pojo.FinanceOperate.insert(FinanceOperate.java:41)
	org.apache.jsp.AddFinance_005fdo_jsp._jspService(AddFinance_005fdo_jsp.java:109)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

弄了两个多小时,居然是由于数据表中的字段declare和系统关键字一样,修改下declare为其他的名称,就好了。
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值