19 Jan
2010
19 Jan
'10
7:57 a.m.
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
21 Jan
21 Jan
3:53 p.m.
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-tp44…
Sent from the XWiki- Users mailing list archive at Nabble.com.
4 p.m.
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
4:01 p.m.
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
5449
days inactive
5451
days old
3 comments
3 participants
participants (3)
-
adoro -
Oskar Marek Rzepinski -
Vincent Massol