Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g - xwiki-users@xwiki.org

19 Jan 2010

Do shemas have been created in the DB ?

Can you ask your DBA to see what is the last login date of the user ?

It could help to know if the problem comes from the DB or if there is something wrong
before trying to connect

...
  -----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 11:48
 À : XWiki Users
 Objet : Re: [xwiki-users] Problem with getting Xwiki to work 
 with Oracle10g

 So, we started our installation once again and it still does not work.
 Step-by-step:
 1. We created a user xwiki on oracle with all privileges. We 
 use oracle
 10.2.0.40
 2. We deployed the war file with the geronimo console. We use tomcat 6
 javaee5 2.1.4
 3. We than changed the configuration file, as already mentioned
 4. We copied the ojdbc5.jar from oracle 11.1.0.7 and tried it 
 also with
 ojdbc14.jar.
 5. Then we restarted geronimo and started the xwiki container

 We use the oracle installtion and the geronimo server on a sun solaris
 server and solaris as the operating system. We still don't 
 get the xwiki
 installed, and don't understand why.

 Thank you all for the pleasent help.

 2010/1/19 Oskar Marek Rzepinski &lt;rzepinski(a)gmail.com&gt;

  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 &lt;calebdelisle(a)lavabit.com&gt;

 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.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"/>
> >   </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 &lt;Christophe.PERINAUD(a)kbl-bank.com&gt;
> >>
> >>> 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

  _______________________________________________
 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