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 <[email protected]> > 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 > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
