Hello, I decided to upgrade my xwiki from 3.1 to 3.3 today, only to find out that since 3.2 postgresql support in the wiki is broken. That's two stable releases that have this problem, is this being worked on or is postgresql support dead? Below is the error, searching around i see other people complaining about this, but no fix. Thanks. --- exception javax.servlet.ServletException: 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:XWiki.XWikiUsers Wrapped Exception: Error number 3211 in 3: Exception while updating archive XWiki.XWikiUsers Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2]{docId=495778886, version2=1, version1=4}] org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) root cause 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:XWiki.XWikiUsers Wrapped Exception: Error number 3211 in 3: Exception while updating archive XWiki.XWikiUsers Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: could not load an entity: [com.xpn.xwiki.doc.rcs.XWikiRCSNodeContent#component[docId,version1,version2]{docId=495778886, version2=1, version1=4}] com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:419) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:488) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Actually found a better solution as described on https://community.jboss.org/wiki/HibernateCoreMigrationGuide36 Don't change xwiki.hbm.xml but instead add the following in your hibernate.cfg.xml: <property name="jdbc.use_streams_for_binary">false</property>

Let me know how it goes. Thanks -Vincent On Jan 12, 2012, at 8:02 AM, Vincent Massol wrote: