Hi All
I am trying to set up XE to use an Oracle 10 XE database using a
Tomcat but I seem to be missing some important point I downloaded the
war file to set it up followed the instructions in the setup pages,
have had issues with getting it to parse files and have now got to
here where I seem to be connecting to my database but not getting it
to function
I am an Oracle DBA and do work with Oracle Middleware, so am familiar
with much of the concepts, not so much with Hibernate and Tomcat
This is the error I am seeing
javax.servlet.ServletException: 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.XWikiHibernateMigrationManager
from param xwiki.store.migration.manager.class
Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: could not execute query
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
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(XWikiDavFilter.java:68)
com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:295)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter
Server details are
Centos 5.4 32bit
Apache Tomcat/5.5.23
Oracle 10 database
Xe xwiki-core-2.1.1.jar
OpenJDK Runtime Environment (build 1.6.0-b09)
I have a IBM Java 1.6 jre installed that I could use, should I use
that instead or will this work with OpenJDK
Any help appreciated
Hibernate.cfg.xml
<?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>
<!-- 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:@websrv01:1521:XE</property>
<property name="connection.username">SomeUser</property>
<property name="connection.password">SomePassword</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"/>
<mapping resource="activitystream.hbm.xml"/>
</session-factory>
</hibernate-configuration>
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.