[ 
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

        
_______________________________________________
notifications mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/notifications

Reply via email to