Hi Mike, On Jan 12, 2012, at 1:38 AM, Mike Jakubik wrote:
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?
Yeah we broke a lot of stuff when upgrading to the latest Hibernate version :( We didn't have automated tests for the various DBs and we let that slip. I've fixed support for Oracle already and I've been working on fixing the PostgreSQL one too. What you should do is try to add the following in your xwiki.hbm.xml file: <typedef name="materialized_clob" class="org.hibernate.type.StringClobType" /> Add it at the top just before this: <class name="com.xpn.xwiki.doc.XWikiDocument" table="xwikidoc"> And let me know if it fixes the issue. To get the xwiki.hbm.xml file you can extract it from WEB-INF/lib/xwiki-platform-legacy-oldcore-*.jar and copy it to WEB-INF/classes so that your copy takes precedence in the classpath. Thanks -Vincent
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users