Using MySQL 5.0.27 on a new test box, with XWiki10B2 and getting the
following message every time I try to create a new document:
Does not seem to happen for MySQL 4.1 at all.  Is this a bug or is there
a config I need to implement for my MySQL version?
Error number 3201 in 3: Exception while saving document Main.TesTsts
Wrapped Exception: Could not execute JDBC batch update
com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while
saving document Main.TesTsts
Wrapped Exception: Could not execute JDBC batch update
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:310)
        at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:96
)
        at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:90
)
        at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:767)
        at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:111)
        at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:120)
        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:143)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.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:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java:121)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
        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:1
48)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
        at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
        at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
        at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
        at java.lang.Thread.run(Thread.java:595)
Wrapped Exception:
java.sql.BatchUpdateException: Field 'XWD_ARCHIVE' doesn't have a
default value
        at
com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatem
ent.java:828)
        at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingState
ment.java:294)
        at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingState
ment.java:294)
        at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:5
8)
        at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195
)
        at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java
:91)
        at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java
:86)
        at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher
.java:171)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn
tityPersister.java:2048)
        at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn
tityPersister.java:2427)
        at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:
51)
        at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
        at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
        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(DefaultFlushEv
entListener.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:10
6)
        at
com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernat
eBaseStore.java:561)
        at
com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernat
eBaseStore.java:539)
        at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore
.java:305)
        at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:96
)
        at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:90
)
        at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:767)
        at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:111)
        at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:120)
        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:143)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.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:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi
ngFilter.java:121)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:202)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
        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:1
48)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
9)
        at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
essConnection(Http11BaseProtocol.java:664)
        at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
        at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
        at java.lang.Thread.run(Thread.java:595)
Brandon Esbach
Software Engineer
M/A-Com Eurotec Operations
LoughMahon Technology Park,
Skehard Road,
Blackrock,
Cork, Ireland
Tel  +353 21 4808305