Hi,
Is this is plain install or an upgrade from a previous XWiki database ?
What version of MySQL are you running ?
There seems to be an incompatibility of the XWD_ARCHIVE field definition
and the hibernate model.
I don't remember exactly the sql command to run to set a default value
to '' for the field XWD_ARCHIVE
This should be added in the updateschema script to make sure the field
is defined properly.
Ludovic
Kristian Marinkovic a écrit :
  hi,
 i installed the new XWiki as described in the admin guide. But when
 i try to run the new XWiki for the first time i get following exception.
 My previous XWiki was 0.9.1252 and worked fine.
 Could someone help me please?
 com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not
 initialize main XWiki context
 Wrapped Exception: Error number 3201 in 3: Exception while saving
 document XWiki.TagClass
 Wrapped Exception: Could not execute JDBC batch update
     at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:223)
     at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:303)
     at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
     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.doGet(ActionServlet.java:414)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
     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:121)
     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.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.coyote.http11.Http11Processor.process(Http11Processor.java:868)
     at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
     at
 org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
     at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
     at
 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
     at java.lang.Thread.run(Unknown Source)
 Wrapped Exception:
 com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while
 saving document XWiki.TagClass
 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:750)
     at com.xpn.xwiki.XWiki.getTagClass(XWiki.java:1855)
     at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:558)
     at com.xpn.xwiki.XWiki.<init>(XWiki.java:470)
     at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:214)
     at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:303)
     at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
     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.doGet(ActionServlet.java:414)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
     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:121)
     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.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.coyote.http11.Http11Processor.process(Http11Processor.java:868)
     at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
     at
 org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
     at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
     at
 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
     at java.lang.Thread.run(Unknown Source)
 Wrapped Exception:
 java.sql.BatchUpdateException: Field 'XWD_ARCHIVE' doesn't have a
 default value
     at
 com.mysql.jdbc.ServerPreparedStatement.executeBatch(ServerPreparedStatement.java:828)
     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:561)
     at
com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.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:750)
     at com.xpn.xwiki.XWiki.getTagClass(XWiki.java:1855)
     at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:558)
     at com.xpn.xwiki.XWiki.<init>(XWiki.java:470)
     at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:214)
     at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:303)
     at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:96)
     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.doGet(ActionServlet.java:414)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
     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:121)
     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.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.coyote.http11.Http11Processor.process(Http11Processor.java:868)
     at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
     at
 org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
     at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
     at
 org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
     at java.lang.Thread.run(Unknown Source)
 g,
 kris
 ------------------------------------------------------------------------
 --
 You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list.
 To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
 For general help: mailto:sympa@objectweb.org?subject=help
 ObjectWeb mailing lists service home page: 
http://www.objectweb.org/wws
    
--
Ludovic Dubost
Blog: 
http://www.ludovic.org/blog/
XWiki: 
http://www.xwiki.com
Skype: ldubost GTalk: ldubost
AIM: nvludo Yahoo: ludovic