Hi Gerard, I thought I had already answered you about this this morning...
I'll repeat my suggestion: try tweaking the HBM file for PostGreSQL. Alternatively try using a different database (like MYSQL) if you can as I believe the problem is why PostGreSQL. Last, check the online mail archives since several people got XWiki working with PostGreSQL with some tweakings. Thanks -Vincent On Sep 6, 2007, at 12:08 PM, Geert Verhaag wrote: > Hi XWiki Users, > > I try to start a new thread about this problem, because the problem is > very urgent. > > This matter has been a topic around April this year as I found at > jira.xwiki.org (key: xwiki-992: Cannot save new panel layout while > logged in as Admin), but wasn't really solved if I understand it all > well! > > I experience problems saving both my layout and preferences, getting > the following message: > > Error number 3201 in 3: Exception while saving document > XWiki.XWikiPreferences > Wrapped Exception: Could not execute JDBC batch update > com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while > saving document XWiki.XWikiPreferences > Wrapped Exception: Could not execute JDBC batch update > at > com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc > (XWikiHibernateStore.java:314) > at > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc > (XWikiCacheStore.java:100) > at > com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc > (XWikiCacheStore.java:94) > at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:914) > at com.xpn.xwiki.web.SaveAction.save(SaveAction.java:114) > at com.xpn.xwiki.web.SaveAction.action(SaveAction.java:123) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:149) > 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:710) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:269) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:188) > at > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter > (SetCharacterEncodingFilter.java:118) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:215) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:188) > at > org.apache.catalina.core.StandardWrapperValve.invoke > (StandardWrapperValve.java:210) > at > org.apache.catalina.core.StandardContextValve.invoke > (StandardContextValve.java:174) > at > org.apache.catalina.core.StandardHostValve.invoke > (StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke > (ErrorReportValve.java:117) > at > org.apache.catalina.core.StandardEngineValve.invoke > (StandardEngineValve.java:108) > at > org.apache.catalina.connector.CoyoteAdapter.service > (CoyoteAdapter.java:151) > at > org.apache.coyote.http11.Http11Processor.process > (Http11Processor.java:870) > at > org.apache.coyote.http11.Http11BaseProtocol > $Http11ConnectionHandler.processConnection(Http11BaseProtocol.java: > 665) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket > (PoolTcpEndpoint.java:528) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt > (LeaderFollowerWorkerThread.java:81) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run > (ThreadPool.java:685) > at java.lang.Thread.run(Unknown Source) > > > Wrapped Exception: > > java.sql.BatchUpdateException: Batch entry 0 update xwikidoc set > XWD_ARCHIVE=head > ..... > > Our consideration using xwiki for our institute's wiki site is in > danger because of this error! Currently I'm unable to continue > configuring it properly. > > I use XWiki version 1.0.3342 in combination with PostgreSQL-8.2, > TomCat > 5.5 and jdk-6u2! > > The strange thing is that it has been working properly at the > beginning. Setting up the layout, preferences, and saving it all > wasn't > a problem! > > Thanks! > > Regards, > Gerard > > > ========================================== > > Dit bericht is uitsluitend bestemd voor de geadresseerde. > Het bericht kan vertrouwelijke informatie bevatten. > Als u dit bericht per abuis hebt ontvangen, wordt u > verzocht onmiddellijk de afzender te informeren. Ook > verzoeken wij u het bericht te vernietigen en de inhoud > niet onder derden te verspreiden of te gebruiken. > > This message is intended exclusively for the addressee. > It may contain information that is confidential. > If you are not the intended recipient, we request that > you notify the sender immediately. In that case, we > also request that you destroy the message and that > you neither use the contents nor disclose them in any > manner to third parties. > ========================================== > > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
