[xwiki-users] Problem with getting Xwiki to work with Oracle10g
Hello everybody, we just stuck on installing xwiki on our devserver. We tried almost 10 times to get it work by ourselves but I didn't work. We still want to get it working. Here are the steps we did already: 1. we created a user xwiki on our DB server with the instructions from the official site 2. then we deployed xwiki on our server with the geronimo console 3. we made some changes to the hibernate configuration file, as you can see: <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- Please refer to the installation guide on http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your database. You'll need to do 2 things: 1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory 2) Uncomment the properties below for your specific DB (and comment the default database configuration if it doesn't match your DB) --> <!-- Generic parameters common to all Databases --> <property name="show_sql">false</ property> <property name="use_outer_join">true</property> <property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxActive">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWait">30000</property> <property name="dbcp.whenExhaustedAction">1</property> <property name="dbcp.ps.whenExhaustedAction">1</property> <property name="dbcp.ps.maxActive">20</property> <property name="dbcp.ps.maxWait">120000</property> <property name="dbcp.ps.maxIdle">20</property> <!-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. --> <property name="jdbc.use_scrollable_resultset">false</property> <!-- Oracle configuration. Uncomment if you want to use Oracle and comment out other database configurations. Note: the 2 properties named "hibernate.connection.SetBigStringTryClob" and "hibernate.jdbc.batch_size". They are required to tell Oracle to allow CLOBs larger than 32K. --> <property name="connection.url">jdbc:oracle:thin:@10.233.106.132:1521 :devORA</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <property name="hibernate.connection.SetBigStringTryClob">true</property> <property name="hibernate.jdbc.batch_size">0</property> <mapping resource="xwiki.oracle.hbm.xml"/> <mapping resource="feeds.oracle.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property> </session-factory> </hibernate-configuration> 4. We still get this error. We can simply connect to the xwiki users on the solaris console with sqlplus, but we cannot get it work. The user for the xwiki has all privileges to work the database. We cannot understand what goes wrong. Is there a simple how to how to really xwiki working on oracle 10g? Thank you very much. HTTP Status 500 - _____ type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception 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: invalid configuration 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:693) javax.servlet.http.HttpServlet.service(HttpServlet.java:806) com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) root cause 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: invalid configuration com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:341) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:402) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) 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:693) javax.servlet.http.HttpServlet.service(HttpServlet.java:806) com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:117) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs. _____ Apache Tomcat/6.0.18 sincerely Oskar
Hello Oscar, it's really pity you cannot use XWiki for your purposes - I have tried at least 6 - 7 other Wikis before we chosen this one. Sure, there are some bugs, but who's perfect? :-) It's getting better from version to version. Now we have experience with XWiki with different environments - XE 1.2 (Oracle 10g+OC4J), XE 1.5 (MySQL+Tomcat 5.5), XE 2.1.1 (Oracle 10g + Tomcat 6 and Oracle 10g +JBoss 5). For Oracle 10g we are using ojdbc14.jar (in WEB-INF/lib XWiki directory or in the \common\lib directory from Tomcat) - it works perfectly. I'm pretty sure, the problem might be geronimo server - we have no problems without using it :-) I'm not familiar with Apache geronimo but perhaps you need some more plugins (see i.e. http://www.geronimoplugins.com/entry_OracleXADriverforConsole.php) to get works all together? Best Regards, Alla -- View this message in context: http://n2.nabble.com/Problem-with-getting-Xwiki-to-work-with-Oracle10g-tp441... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi Adoro, On Jan 21, 2010, at 3:53 PM, adoro wrote:
Hello Oscar,
it's really pity you cannot use XWiki for your purposes - I have tried at least 6 - 7 other Wikis before we chosen this one. Sure, there are some bugs, but who's perfect? :-) It's getting better from version to version. Now we have experience with XWiki with different environments - XE 1.2 (Oracle 10g+OC4J), XE 1.5 (MySQL+Tomcat 5.5), XE 2.1.1 (Oracle 10g + Tomcat 6 and Oracle 10g +JBoss 5). For Oracle 10g we are using ojdbc14.jar (in WEB-INF/lib XWiki directory or in the \common\lib directory from Tomcat) - it works perfectly.
Cool, thanks for the feedback Adoro. I wasn't sure since I haven't tried XE on Oracle for at least 1 year. Good to get confirmation it's working fine. Are all features working fine or are there some areas not working? Thanks -Vincent
I'm pretty sure, the problem might be geronimo server - we have no problems without using it :-) I'm not familiar with Apache geronimo but perhaps you need some more plugins (see i.e. http://www.geronimoplugins.com/entry_OracleXADriverforConsole.php) to get works all together?
Best Regards, Alla
On Jan 21, 2010, at 4:00 PM, Vincent Massol wrote:
Hi Adoro,
Sorry I meant Alla. -Vincent
On Jan 21, 2010, at 3:53 PM, adoro wrote:
Hello Oscar,
it's really pity you cannot use XWiki for your purposes - I have tried at least 6 - 7 other Wikis before we chosen this one. Sure, there are some bugs, but who's perfect? :-) It's getting better from version to version. Now we have experience with XWiki with different environments - XE 1.2 (Oracle 10g+OC4J), XE 1.5 (MySQL+Tomcat 5.5), XE 2.1.1 (Oracle 10g + Tomcat 6 and Oracle 10g +JBoss 5). For Oracle 10g we are using ojdbc14.jar (in WEB-INF/lib XWiki directory or in the \common\lib directory from Tomcat) - it works perfectly.
Cool, thanks for the feedback Adoro. I wasn't sure since I haven't tried XE on Oracle for at least 1 year.
Good to get confirmation it's working fine. Are all features working fine or are there some areas not working?
Thanks -Vincent
I'm pretty sure, the problem might be geronimo server - we have no problems without using it :-) I'm not familiar with Apache geronimo but perhaps you need some more plugins (see i.e. http://www.geronimoplugins.com/entry_OracleXADriverforConsole.php) to get works all together?
Best Regards, Alla
participants (3)
-
adoro -
Oskar Marek Rzepinski -
Vincent Massol