Re: [xwiki-users] Problem with getting Xwiki to work with Oracle10g
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
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
participants (2)
-
Oskar Marek Rzepinski -
PERINAUD Christophe