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