19 Jan
2010
19 Jan
'10
9:41 a.m.
We have now some meetings, after them we will try once again with the jetty
pack.
@Caleb James DeLisle
The steps I mentioned already we have done with the war file. We deployed it
with the geronimo console.
I will get back to this after we have tried the jetty pack and than I will
answer and report if we were successful or not.
2010/1/19 Caleb James DeLisle <calebdelisle(a)lavabit.com>
XWiki is built differently for the war installation
than the jetty/HSQL
pack
I think If you download the war file and install that way it will work.
Caleb
PERINAUD Christophe wrote:
Here what we did is that we installed Xwiki from
the pack jetty/HSQL.
Once it work, we modified the hibernate configuration file to connect to
Oracle
DB.
Here is our config file (if it helps ...) :
<?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>
<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>
<property name="connection.url">jdbc:oracle:thin:@IP.IP.IP.IP
:1521:od46</property>
<property
name="connection.username">xwiki</property>
<property name="connection.password">*********</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"/>
</session-factory>
</hibernate-configuration>
--------------------------------------------------------------------------------
-----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 08:13
À : XWiki Users
Objet : Re: [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
_______________________________________________
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
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users