[xwiki-users] H2 support in xwiki 2.6
Hi, As was wondering if H2 database was still supported as database from xwiki. According to this page ( http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationH2), this should work but here is the exception I get whe using this configuration : javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param xwiki.store.migration.manager.class Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Errors in named queries: getAllPublicDocuments, listGroupsForUserInOtherWiki, getSpaceDocsName, listGroupsForUser, getAllUsers, getAllDocuments, getAllSpaceDocuments, getSpaces 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:129) com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) I'm using h2-1.2.147.jar and here is wat I put in hibernate config file: <property name="connection.url">jdbc:h2:wiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">org.h2.Driver</property> <property name="dialect">org.hibernate.dialect.H2Dialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">20</property> Can anyone help ?
2010/11/24 Nicolas Jouanin <[email protected]>:
Hi,
As was wondering if H2 database was still supported as database from xwiki. According to this page ( http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationH2), this should work but here is the exception I get whe using this configuration :
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param xwiki.store.migration.manager.class Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Errors in named queries: getAllPublicDocuments, listGroupsForUserInOtherWiki, getSpaceDocsName, listGroupsForUser, getAllUsers, getAllDocuments, getAllSpaceDocuments, getSpaces 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:129) com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
I'm using h2-1.2.147.jar and here is wat I put in hibernate config file: <property name="connection.url">jdbc:h2:wiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">org.h2.Driver</property> <property name="dialect">org.hibernate.dialect.H2Dialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">20</property>
Can anyone help ? _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Did you add H2 jars in WEB-INF/lib ? Arnaud.
Yes, the file h2-1.2.147.jar is in webapps/xwiki/WEB-INF/lib. (tomcat container) 2010/11/24 Arnaud bourree <[email protected]>
2010/11/24 Nicolas Jouanin <[email protected]>:
Hi,
As was wondering if H2 database was still supported as database from xwiki. According to this page ( http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationH2), this should work but here is the exception I get whe using this configuration :
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param xwiki.store.migration.manager.class Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Errors in named queries: getAllPublicDocuments, listGroupsForUserInOtherWiki, getSpaceDocsName, listGroupsForUser, getAllUsers, getAllDocuments, getAllSpaceDocuments, getSpaces
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:129)
com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152)
com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
I'm using h2-1.2.147.jar and here is wat I put in hibernate config file: <property name="connection.url">jdbc:h2:wiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">org.h2.Driver</property> <property name="dialect">org.hibernate.dialect.H2Dialect</property> <property
name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.pool_size">20</property>
Can anyone help ? _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Did you add H2 jars in WEB-INF/lib ?
Arnaud. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
OK, my mistake, I copied/paste the hibernate properties shown on the webpage, but I forgot to add the three mapping files : <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> Now it works, except that I cant' login. I use Admin/admin and I get invalid credentials error. I'll investigate. Le 24 nov. 2010 à 15:52, Arnaud bourree a écrit :
2010/11/24 Nicolas Jouanin <[email protected]>:
Hi,
As was wondering if H2 database was still supported as database from xwiki. According to this page ( http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationH2), this should work but here is the exception I get whe using this configuration :
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param xwiki.store.migration.manager.class Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Errors in named queries: getAllPublicDocuments, listGroupsForUserInOtherWiki, getSpaceDocsName, listGroupsForUser, getAllUsers, getAllDocuments, getAllSpaceDocuments, getSpaces 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:129) com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:218) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
I'm using h2-1.2.147.jar and here is wat I put in hibernate config file: <property name="connection.url">jdbc:h2:wiki</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">org.h2.Driver</property> <property name="dialect">org.hibernate.dialect.H2Dialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">20</property>
Can anyone help ? _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Did you add H2 jars in WEB-INF/lib ?
Arnaud. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
On 11/24/2010 10:16 PM, Nicolas Jouanin wrote:
Now it works, except that I cant' login. I use Admin/admin and I get invalid credentials error. I'll investigate.
This is normal, by default the database is empty, no user is automatically created. You should have access to the administration though, just import the default XE XAR. -- Sergiu Dumitriu http://purl.org/net/sergiu/
Yes, thanks for the feedback, I also forgot to import the default XAR. Also I had a problem with tomcat 6.0.29 : I couldn't login with this version. I got invalid credentials message and this message in the log : 2010-11-24 22:28:43,269 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] WARN xwiki.MyPersistentLoginManager - Login cookie validation hash mismatch! Cookies have been tampered with I moved my xwiki installation to tomcat 6.0.26 and it works fine. I've seen on google that issue XWIKI-2119 sound like this problem but it's an old issue. So you should have a look, maybe it's coming back with tomcat 6.0.29 (see bug https://issues.apache.org/bugzilla/show_bug.cgi?id=49598). Regards, Le 24 nov. 2010 à 22:44, Sergiu Dumitriu a écrit :
On 11/24/2010 10:16 PM, Nicolas Jouanin wrote:
Now it works, except that I cant' login. I use Admin/admin and I get invalid credentials error. I'll investigate.
This is normal, by default the database is empty, no user is automatically created. You should have access to the administration though, just import the default XE XAR. -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
participants (3)
-
Arnaud bourree -
Nicolas Jouanin -
Sergiu Dumitriu