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
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
