19 Jan
2010
19 Jan
'10
8:05 a.m.
Hi,
Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib xwiki's folder
?
Christophe Périnaud
Windows Server 2003 SP2 in a VMWare instance
Oracle 10g
Java 1.6.0_12
Xwiki 2.0.3 from the pack Jetty/HSQL
-----Message d'origine-----
De : users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org]
De la part de Oskar Marek Rzepinski
Envoyé : mardi 19 janvier 2010 07:58
À : users(a)xwiki.org
Objet : [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.DBCPConne
ctionProvider</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.XWikiHibernateMigratio
nManager 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(Req
uestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform
(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProce
ssor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.j
ava: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(XWikiDavFi
lter.java:68)
com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq
uestRestorerFilter.java:295)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara
cterEncodingFilter.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.XWikiHibernateMigratio
nManager 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(RequestProce
ssor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.j
ava: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(XWikiDavFi
lter.java:68)
com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq
uestRestorerFilter.java:295)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara
cterEncodingFilter.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
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--------------------------------------------------------------------------------
This e-mail is intended only for the addressee named above. It does not bind the sender,
except in the case of an existing written convention with the addressee. This e-mail may
contain material that is confidential and privileged for the sole use of the intended
recipient. Any review, reliance or distribution by others or forwarding without express
permission is strictly prohibited and may be unlawful. If you are not the intended
recipient, please contact the sender and delete all copies.
While reasonable precautions have been taken to ensure that this e-mail and any
attachments are free from any computer virus or similar defect, no liability will be
accepted in that respect. Anyone accessing this e-mail must take their own precautions as
to security and virus protection.
KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg
B 6395, T (352) 47 97 1
19 Jan
19 Jan
8:13 a.m.
New subject: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
Yes, I forgot to mention it, we copied it from the oracle folder, we copied
this files:
ojdbc14.jar
orai18n.jar
And we also tried it with ojdbc5.jar
It getting us really crazy on this.
2010/1/19 PERINAUD Christophe <Christophe.PERINAUD(a)kbl-bank.com>
Hi,
Maybe stupid but did you install Oracle JDBC drivers in the WEB-INF/lib
xwiki's folder ?
Christophe Périnaud
Windows Server 2003 SP2 in a VMWare instance
Oracle 10g
Java 1.6.0_12
Xwiki 2.0.3 from the pack Jetty/HSQL
-----Message d'origine-----
De : users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org]
De la part de Oskar Marek Rzepinski
Envoyé : mardi 19 janvier 2010 07:58
À : users(a)xwiki.org
Objet : [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.DBCPConne
ctionProvider</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.XWikiHibernateMigratio
nManager 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(Req
uestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform
(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProce
ssor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.j
ava: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(XWikiDavFi
lter.java:68)
com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq
uestRestorerFilter.java:295)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara
cterEncodingFilter.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.XWikiHibernateMigratio
nManager 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(RequestProce
ssor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.j
ava: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(XWikiDavFi
lter.java:68)
com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedReq
uestRestorerFilter.java:295)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetChara
cterEncodingFilter.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
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--------------------------------------------------------------------------------
This e-mail is intended only for the addressee named above. It does not
bind the sender, except in the case of an existing written convention with
the addressee. This e-mail may contain material that is confidential and
privileged for the sole use of the intended recipient. Any review, reliance
or distribution by others or forwarding without express permission is
strictly prohibited and may be unlawful. If you are not the intended
recipient, please contact the sender and delete all copies.
While reasonable precautions have been taken to ensure that this e-mail and
any attachments are free from any computer virus or similar defect, no
liability will be accepted in that respect. Anyone accessing this e-mail
must take their own precautions as to security and virus protection.
KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg,
R.C.S. Luxembourg B 6395, T (352) 47 97 1
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
5407
days inactive
5407
days old
1 comments
2 participants
participants (2)
-
Oskar Marek Rzepinski -
PERINAUD Christophe