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 : [email protected] [mailto:[email protected]] >> 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 <[email protected]> >> >>> 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 : [email protected] [mailto:[email protected]] >>>> De la part de Oskar Marek Rzepinski >>>> Envoyé : mardi 19 janvier 2010 07:58 >>>> À : [email protected] >>>> 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 >>>> [email protected] >>>> 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 >>> [email protected] >>> http://lists.xwiki.org/mailman/listinfo/users >>> >> _______________________________________________ >> users mailing list >> [email protected] >> 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 > [email protected] > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
