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

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

Here is our config file (if it helps ...) : <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate

"

<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

<property name="connection.username">xwiki</property> <property name="connection.password">*********</property> <property

<property

<property

<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

While reasonable precautions have been taken to ensure that this e-mail

KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg,

_______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users