当前位置: 代码迷 >> Java Web开发 >> 呼救:Exception in thread "main" org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch u
  详细解决方案

呼救:Exception in thread "main" org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch u

热度:931   发布时间:2016-04-17 13:56:54.0
求救:Exception in thread "main" org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch u
我在做Spring+Hibernate     时遇见了下面的问题,已经错了好几天了,数据库也从新建了,表关系也重新映射了。。。。。求救SOS

log4j:WARN   No   appenders   could   be   found   for   logger   (org.springframework.context.support.ClassPathXmlApplicationContext).
log4j:WARN   Please   initialize   the   log4j   system   properly.
Exception   in   thread   "main "   org.springframework.dao.InvalidDataAccessResourceUsageException:   Could   not   execute   JDBC   batch   update;   nested   exception   is   org.hibernate.exception.SQLGrammarException:   Could   not   execute   JDBC   batch   update
Caused   by:   org.hibernate.exception.SQLGrammarException:   Could   not   execute   JDBC   batch   update
at   org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at   org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at   org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at   org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at   org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at   org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at   org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at   org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at   org.springframework.orm.hibernate3.HibernateAccessor.flushIfNecessary(HibernateAccessor.java:390)
at   org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:373)
at   org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:632)
at   com.usernews.dao.impl.UserNewsDaoImpl.addNews(UserNewsDaoImpl.java:27)
at   com.usernews.operation.impl.UserNewsServiceImpl.CommitNews(UserNewsServiceImpl.java:71)
at   com.usernews.text.Text.textAdd(Text.java:121)
at   com.usernews.text.Text.main(Text.java:167)
Caused   by:   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   'from,   author,   startdate,   enddate,   iconpath,   note,   checkflag,   newsid)   values   ( 'ti '   at   line   1
at   com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1103)
at   com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:853)
at   org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at   org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at   org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
...   12   more


------解决方案--------------------
<property name= "from " type= "java.lang.String ">
<column name= "from " length= "20 " />
</property>
-------------------

from是sql关键字,不能叫这个名字
  相关解决方案