[xwiki-notifications] [Issue] Commented: (XWIKI-1702) JDBC batch update error

Ludovic Dubost (JIRA) jira at xwiki.org
Thu Sep 6 15:49:15 CEST 2007 

    [ http://jira.xwiki.org/jira/browse/XWIKI-1702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_18142 ] 

Ludovic Dubost commented on XWIKI-1702:
---------------------------------------


It seems at some version of XWiki the hbm file was not correct and the schema has some incorrectness.
You should run this on your DB

alter table xwikidoc modify column XWD_ARCHIVE mediumtext null;

> JDBC batch update error
> -----------------------
>
>                 Key: XWIKI-1702
>                 URL: http://jira.xwiki.org/jira/browse/XWIKI-1702
>             Project: XWiki Platform
>          Issue Type: Bug
>    Affects Versions: 1.1 RC1
>         Environment: Mandriva Linux 2007.1
> MySQL-5.0.37-2.1mdv2007.1
> mysql-connector-java-5.0.7-bin.jar
> jboss 4.0.4
> java 6u2
>            Reporter: Marc Lijour
>
> I installed rc1 yesterday with no problem. By the meantime I updated MySQL to MySQL-5.0.37-2.1mdv2007.1. Apparently it may affect something?
> Here is the log error:
>  Error number 3232 in 3: Exception while saving attachment xwiki-enterprise-wiki-1.1-rc-1.xar of document XWiki.Import
> Wrapped Exception: Could not execute JDBC batch update
> com.xpn.xwiki.XWikiException: Error number 3232 in 3: Exception while saving attachment xwiki-enterprise-wiki-1.1-rc-1.xar of document XWiki.Import
> Wrapped Exception: Could not execute JDBC batch update
> 	at com.xpn.xwiki.store.XWikiHibernateAttachmentStore.saveAttachmentContent(XWikiHibernateAttachmentStore.java:92)
> 	at com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java:2451)
> 	at com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java:2434)
> 	at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:124)
> 	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:147)
> 	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> 	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> 	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> 	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> 	at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> 	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> 	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
> 	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
> 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> 	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
> 	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
> 	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
> 	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
> 	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
> 	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> 	at java.lang.Thread.run(Thread.java:619)
> Wrapped Exception:
> java.sql.BatchUpdateException: Field 'XWD_ARCHIVE' doesn't have a default value
> 	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1257)
> 	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:943)
> 	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
> 	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:294)
> 	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
> 	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
> 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
> 	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
> 	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
> 	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> 	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
> 	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356)
> 	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
> 	at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:611)
> 	at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:585)
> 	at com.xpn.xwiki.store.XWikiHibernateAttachmentStore.saveAttachmentContent(XWikiHibernateAttachmentStore.java:87)
> 	at com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java:2451)
> 	at com.xpn.xwiki.doc.XWikiDocument.saveAttachmentContent(XWikiDocument.java:2434)
> 	at com.xpn.xwiki.web.UploadAction.action(UploadAction.java:124)
> 	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:147)
> 	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
> 	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
> 	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
> 	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> 	at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> 	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> 	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
> 	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
> 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> 	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
> 	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
> 	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
> 	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
> 	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
> 	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> 	at java.lang.Thread.run(Thread.java:619)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.xwiki.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

More information about the notifications mailing list