An: xwiki-users@objectweb.org
Von: Ludovic Dubost <ludovic@xwiki.com>
Datum: 06.01.2007 02:56PM
Thema: Re: [xwiki-users] Exception with XWiki 1.0 Beta 1


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@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



--
You receive this message as a subscriber of the xwiki-users@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