Re: [xwiki-users] Xwiki 3.2+ broken with PostgreSQL
See http://jira.xwiki.org/browse/XWIKI-6738 - I'm also still waiting to
update my sites.
Best Regards,
H.-Dirk Schmitt
On 12.01.2012 01:38, 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?
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@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
*
H.-Dirk Schmitt http://www.computer42.org*
Dipl.Math.
eMail:/dirk.schm...@computer42.org/
mobile:/+49 177 616 8564/
phone: /+49 2642 99 41 10/
fax: /+49 2642 99 41 15/
Kripper Str. 35, D-53489 Sinzig
pgp: http://www.computer42.org/~dirk/OpenPGP-fingerprint.html
http://www.computer42.org/%7Edirk/OpenPGP-fingerprint.html
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Xwiki 3.2+ broken with PostgreSQL
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_binaryfalse/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
users@xwiki.org
Re: [xwiki-users] Xwiki 3.2+ broken with PostgreSQL
On Thu, 2012-01-12 at 11:58 +0100, 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_binaryfalse/property Let me know how it goes. Thanks -Vincent Vincent, Thanks for the info, I'll try this later and let you know. Thanks. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Xwiki 3.2+ broken with PostgreSQL
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@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Xwiki 3.2+ broken with PostgreSQL
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@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
