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
