12 Jan
2012
12 Jan
'12
4:50 p.m.
On Jan 12, 2012, at 11:58 AM, Vincent Massol wrote:
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>
FYI I've committed this and it'll be available in 3.4RC1.
-Vincent
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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users