What I did :

1. change the content of the original "WEB-INF/hibernate.cfg.xml" with

<property name="connection.url">jdbc:oracle:thin:@[serveradd]:[sport]:[dbname] </property>
<property name="connection.username">[user]</property>
<property name="connection.password"> [password]</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="dialect"> org.hibernate.dialect.OracleDialect</property>


2. change the content of the original "WEB-INF/web.xml" with

<init-param>
      <param-name>encoding</param-name>
      <param-value>UTF-8</param-value>
</init-param>


3. append/change the content of the original "WEB-INF/xwiki.cfg" with

xwiki.encoding=UTF-8
xwiki.store.hibernate.updateschema=1


4. I drop all the tables

5. I start the server and go to "http://localhost:8080/xwiki/bin/view/Main/WebHome"

This lead following errors :

From navigator :

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: Error number 3 in 0: Could not initialize main XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences
Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences
Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences
Wrapped Exception: Could not execute JDBC batch update
    org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
    org.apache.struts.action.RequestProcessor.process (RequestProcessor.java:226)
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
    javax.servlet.http.HttpServlet.service (HttpServlet.java:697)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
    org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter (ReplyHeaderFilter.java:81)

root cause

com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences
Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences
Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences
Wrapped Exception: Could not execute JDBC batch update
    com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:142)
    com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
    com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java :117)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    org.apache.struts.action.ActionServlet.process (ActionServlet.java:1164)
    org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    javax.servlet.http.HttpServlet.service(HttpServlet.java :810)
    com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
    org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)



From server log

17:29:48,614 INFO  [ConnectionProviderFactory] Initializing connection provider: com.xpn.xwiki.store.DBCPConnectionProvider
17:29:49,754 INFO  [DBCPConnectionProvider] active: 0 (max: 50)   idle: 1(max: 5)
17:29:49,754 INFO  [DBCPConnectionProvider] active: 1 (max: 50)   idle: 0(max: 5)
17:29:49,754 INFO  [SettingsFactory] RDBMS: Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
17:29:49,770 INFO  [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.2.0.1.0
17:29:49,770 INFO  [DBCPConnectionProvider] active: 0 (max: 50)   idle: 1(max: 5)
17:29:49,832 INFO  [Dialect] Using dialect: org.hibernate.dialect.OracleDialect
17:29:49,848 INFO  [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
17:29:49,848 INFO  [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
17:29:49,848 INFO  [SettingsFactory] Automatic flush during beforeCompletion(): disabled
17:29:49,848 INFO  [SettingsFactory] Automatic session close at end of transaction: disabled
17:29:49,848 INFO  [SettingsFactory] JDBC batch size: 15
17:29:49,848 INFO  [SettingsFactory] JDBC batch updates for versioned data: disabled
17:29:49,848 INFO  [SettingsFactory] Scrollable result sets: enabled
17:29:49,848 INFO  [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
17:29:49,848 INFO  [SettingsFactory] Connection release mode: null
17:29:49,848 INFO  [SettingsFactory] Default batch fetch size: 1
17:29:49,848 INFO  [SettingsFactory] Generate SQL with comments: disabled
17:29:49,848 INFO  [SettingsFactory] Order SQL updates by primary key: disabled
17:29:49,848 INFO  [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:29:49,864 INFO  [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
17:29:49,864 INFO  [SettingsFactory] Query language substitutions: {}
17:29:49,864 INFO  [SettingsFactory] Second-level cache: enabled
17:29:49,864 INFO  [SettingsFactory] Query cache: disabled
17:29:49,864 INFO  [SettingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider
17:29:49,879 INFO  [SettingsFactory] Optimize cache for minimal puts: disabled
17:29:49,879 INFO  [SettingsFactory] Structured second-level cache entries: enabled
17:29:49,895 INFO  [SettingsFactory] Statistics: disabled
17:29:49,895 INFO  [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
17:29:49,895 INFO  [SettingsFactory] Default entity-mode: pojo
17:29:49,989 INFO  [SessionFactoryImpl] building session factory
17:29:50,004 WARN  [Configurator] No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/R:/java/tools/jboss/4_0_3-eici/server/light/deploy/xwiki.war/WEB-INF/lib/ehcache- 1.1.jar!/ehcache-failsafe.xml
17:29:56,536 INFO  [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
17:29:56,536 INFO  [SessionFactoryImpl] Checking 0 named queries
17:29:56,536 ERROR [XWikiHibernateStore] Schema update for wiki xwiki
17:29:56,536 INFO  [Dialect] Using dialect: org.hibernate.dialect.OracleDialect
17:29:56,614 INFO  [DBCPConnectionProvider] active: 1 (max: 50)   idle: 0(max: 5)
17:29:56,864 INFO  [Configuration] processing extends queue
17:29:56,864 INFO  [Configuration] processing collection mappings
17:29:56,864 INFO  [Configuration] processing association property references
17:29:56,864 INFO  [Configuration] processing foreign key constraints
17:29:57,176 INFO  [DatabaseMetadata] table not found: xwikiattachment
17:29:57,301 INFO  [DatabaseMetadata] table not found: xwikiattachment_archive
17:29:57,364 INFO  [DatabaseMetadata] table not found: xwikiattachment_content
17:29:57,442 INFO  [DatabaseMetadata] table not found: xwikibooleanclasses
17:29:57,504 INFO  [DatabaseMetadata] table not found: xwikiclasses
17:29:57,582 INFO  [DatabaseMetadata] table not found: xwikiclassesprop
17:29:57,661 INFO  [DatabaseMetadata] table not found: xwikidateclasses
17:29:57,723 INFO  [DatabaseMetadata] table not found: xwikidates
17:29:57,801 INFO  [DatabaseMetadata] table not found: xwikidblistclasses
17:29:57,864 INFO  [DatabaseMetadata] table not found: xwikidoc
17:29:57,911 INFO  [DatabaseMetadata] table not found: xwikidoubles
17:29:57,973 INFO  [DatabaseMetadata] table not found: xwikifloats
17:29:58,051 INFO  [DatabaseMetadata] table not found: xwikiintegers
17:29:58,114 INFO  [DatabaseMetadata] table not found: xwikilargestrings
17:29:58,192 INFO  [DatabaseMetadata] table not found: xwikilistitems
17:29:58,254 INFO  [DatabaseMetadata] table not found: xwikilists
17:29:58,317 INFO  [DatabaseMetadata] table not found: xwikilock
17:29:58,395 INFO  [DatabaseMetadata] table not found: xwikilongs
17:29:58,473 INFO  [DatabaseMetadata] table not found: xwikinumberclasses
17:29:58,536 INFO  [DatabaseMetadata] table not found: xwikiobjects
17:29:58,598 INFO  [DatabaseMetadata] table not found: xwikiproperties
17:29:58,692 INFO  [DatabaseMetadata] table not found: xwikislistclasses
17:29:58,739 INFO  [DatabaseMetadata] table not found: xwikistatsdoc
17:29:58,832 INFO  [DatabaseMetadata] table not found: xwikistatsreferer
17:29:58,895 INFO  [DatabaseMetadata] table not found: xwikistatsvisit
17:29:58,973 INFO  [DatabaseMetadata] table not found: xwikistringclasses
17:29:59,036 INFO  [DatabaseMetadata] table not found: xwikistrings
17:29:59,114 INFO  [DatabaseMetadata] table not found: xwikiattachment
17:29:59,192 INFO  [DatabaseMetadata] table not found: xwikiattachment_archive
17:29:59,270 INFO  [DatabaseMetadata] table not found: xwikiattachment_content
17:29:59,364 INFO  [DatabaseMetadata] table not found: xwikibooleanclasses
17:29:59,426 INFO  [DatabaseMetadata] table not found: xwikiclasses
17:29:59,504 INFO  [DatabaseMetadata] table not found: xwikiclassesprop
17:29:59,567 INFO  [DatabaseMetadata] table not found: xwikidateclasses
17:29:59,629 INFO  [DatabaseMetadata] table not found: xwikidates
17:29:59,692 INFO  [DatabaseMetadata] table not found: xwikidblistclasses
17:29:59,754 INFO  [DatabaseMetadata] table not found: xwikidoc
17:29:59,817 INFO  [DatabaseMetadata] table not found: xwikidoubles
17:29:59,879 INFO  [DatabaseMetadata] table not found: xwikifloats
17:29:59,957 INFO  [DatabaseMetadata] table not found: xwikiintegers
17:30:00,020 INFO  [DatabaseMetadata] table not found: xwikilargestrings
17:30:00,098 INFO  [DatabaseMetadata] table not found: xwikilistitems
17:30:00,161 INFO  [DatabaseMetadata] table not found: xwikilists
17:30:00,239 INFO  [DatabaseMetadata] table not found: xwikilock
17:30:00,301 INFO  [DatabaseMetadata] table not found: xwikilongs
17:30:00,379 INFO  [DatabaseMetadata] table not found: xwikinumberclasses
17:30:00,442 INFO  [DatabaseMetadata] table not found: xwikiobjects
17:30:00,504 INFO  [DatabaseMetadata] table not found: xwikiproperties
17:30:00,567 INFO  [DatabaseMetadata] table not found: xwikislistclasses
17:30:00,645 INFO  [DatabaseMetadata] table not found: xwikistatsdoc
17:30:00,707 INFO  [DatabaseMetadata] table not found: xwikistatsreferer
17:30:00,786 INFO  [DatabaseMetadata] table not found: xwikistatsvisit
17:30:00,848 INFO  [DatabaseMetadata] table not found: xwikistringclasses
17:30:00,911 INFO  [DatabaseMetadata] table not found: xwikistrings
17:30:01,879 ERROR [XWikiHibernateStore] Failed updating schema: ORA-01754: a table may contain only one column of type LONG

17:30:01,879 ERROR [XWikiHibernateStore] Failed updating schema: ORA-00942: table or view does not exist

17:30:01,879 INFO  [DBCPConnectionProvider] active: 0 (max: 50)   idle: 1(max: 5)
17:30:01,879 INFO  [DBCPConnectionProvider] active: 1 (max: 50)   idle: 0(max: 5)
17:30:01,926 WARN  [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
17:30:01,926 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

17:30:01,926 INFO  [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.SQLGrammarException: could not load an entity: [com.xpn.xwiki.doc.XWikiDocument#104408758]
    at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
    at org.hibernate.exception.JDBCExceptionHelper.convert (JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.loadEntity(Loader.java:1326)
    at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116)
    at org.hibernate.loader.entity.EntityLoader.load (EntityLoader.java:101)
    at org.hibernate.persister.entity.BasicEntityPersister.load(BasicEntityPersister.java:2461)
    at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java :350)
    at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:331)
    at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:113)
    at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad (DefaultLoadEventListener.java:167)
    at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:79)
    at org.hibernate.impl.SessionImpl.load(SessionImpl.java:588)
    at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc (XWikiHibernateStore.java:575)
    at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:123)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:565)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java :599)
    at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:1019)
    at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:1014)
    at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:422)
    at com.xpn.xwiki.XWiki.initXWiki (XWiki.java:397)
    at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
    at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
    at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
    at com.xpn.xwiki.web.ViewEditAction.execute (ViewEditAction.java:117)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:173)
    at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java :202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java :213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke (SecurityAssociationValve.java:159)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java :744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    at java.lang.Thread.run (Thread.java:595)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError (T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java :216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe (T4CPreparedStatement.java:839)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java :3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
    at org.hibernate.loader.Loader.getResultSet (Loader.java:1239)
    at org.hibernate.loader.Loader.doQuery(Loader.java:374)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
    at org.hibernate.loader.Loader.loadEntity (Loader.java:1312)
    ... 49 more
17:30:01,942 INFO  [DBCPConnectionProvider] active: 0 (max: 50)   idle: 1(max: 5)
17:30:02,395 INFO  [DBCPConnectionProvider] active: 1 (max: 50)   idle: 0(max: 5)
17:30:02,411 WARN  [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
17:30:02,411 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

17:30:02,411 INFO  [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.SQLGrammarException: could not load an entity: [ com.xpn.xwiki.doc.XWikiDocument#104408758]
    at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.loadEntity(Loader.java:1326)
    at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116)
    at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:101)
    at org.hibernate.persister.entity.BasicEntityPersister.load(BasicEntityPersister.java:2461)
    at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:350)
    at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:331)
    at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:113)
    at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad (DefaultLoadEventListener.java:167)
    at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:79)
    at org.hibernate.impl.SessionImpl.load(SessionImpl.java:588)
    at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc (XWikiHibernateStore.java:575)
    at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:123)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java:565)
    at com.xpn.xwiki.XWiki.getDocument(XWiki.java :599)
    at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1361)
    at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
    at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
    at com.xpn.xwiki.XWiki.getMainXWiki (XWiki.java:134)
    at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
    at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
    at org.apache.struts.action.RequestProcessor.processActionPerform( RequestProcessor.java:421)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    at org.apache.struts.action.ActionServlet.doGet (ActionServlet.java:397)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java :127)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke (JaccContextValve.java:59)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection (Http11Protocol.java:744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8 (T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal (OraclePreparedStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java :92)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
    at org.hibernate.loader.Loader.getResultSet (Loader.java:1239)
    at org.hibernate.loader.Loader.doQuery(Loader.java:374)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
    at org.hibernate.loader.Loader.loadEntity (Loader.java:1312)
    ... 47 more
17:30:02,411 INFO  [DBCPConnectionProvider] active: 0 (max: 50)   idle: 1(max: 5)
17:30:02,411 INFO  [DBCPConnectionProvider] active: 1 (max: 50)   idle: 0(max: 5)
17:30:02,957 WARN  [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
17:30:02,957 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist

17:30:02,973 INFO  [DBCPConnectionProvider] active: 0 (max: 50)   idle: 1(max: 5)
17:30:02,973 INFO  [STDOUT] com.xpn.xwiki.XWikiException : Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences
Wrapped Exception: could not execute query
17:30:02,973 INFO  [STDOUT]     at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java :540)
17:30:02,973 INFO  [STDOUT]     at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:557)
17:30:02,973 INFO  [STDOUT]     at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java :77)
17:30:03,036 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
17:30:03,036 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418)
17:30:03,036 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.initXWiki (XWiki.java:405)
17:30:03,036 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
17:30:03,036 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
17:30:03,036 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
17:30:03,036 INFO  [STDOUT]     at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
17:30:03,036 INFO  [STDOUT]     at org.apache.struts.action.RequestProcessor.processActionPerform (RequestProcessor.java:421)
17:30:03,036 INFO  [STDOUT]     at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
17:30:03,051 INFO  [STDOUT]     at org.apache.struts.action.ActionServlet.process (ActionServlet.java:1164)
17:30:03,051 INFO  [STDOUT]     at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
17:30:03,051 INFO  [STDOUT]     at javax.servlet.http.HttpServlet.service(HttpServlet.java :697)
17:30:03,051 INFO  [STDOUT]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java :252)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:30:03,051 INFO  [STDOUT]     at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:127)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:173)
17:30:03,051 INFO  [STDOUT]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:202)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:213)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
17:30:03,051 INFO  [STDOUT]     at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke (CustomPrincipalValve.java:39)
17:30:03,051 INFO  [STDOUT]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
17:30:03,051 INFO  [STDOUT]     at org.jboss.web.tomcat.security.JaccContextValve.invoke (JaccContextValve.java:59)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
17:30:03,051 INFO  [STDOUT]     at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:148)
17:30:03,051 INFO  [STDOUT]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
17:30:03,051 INFO  [STDOUT]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection (Http11Protocol.java:744)
17:30:03,051 INFO  [STDOUT]     at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
17:30:03,051 INFO  [STDOUT]     at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run (MasterSlaveWorkerThread.java:112)
17:30:03,051 INFO  [STDOUT]     at java.lang.Thread.run(Thread.java:595)
17:30:03,051 INFO  [STDOUT]

Wrapped Exception:
17:30:03,051 INFO  [STDOUT] java.sql.SQLException : ORA-00942: table or view does not exist
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.T4CTTIoer.processError (T4CTTIoer.java:331)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
17:30:03,051 INFO  [STDOUT]     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
17:30:03,051 INFO  [STDOUT]     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java :92)
17:30:03,051 INFO  [STDOUT]     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
17:30:03,051 INFO  [STDOUT]     at org.hibernate.jdbc.AbstractBatcher.getResultSet (AbstractBatcher.java:118)
17:30:03,051 INFO  [STDOUT]     at org.hibernate.loader.Loader.getResultSet(Loader.java:1239)
17:30:03,051 INFO  [STDOUT]     at org.hibernate.loader.Loader.doQuery(Loader.java:374)
17:30:03,051 INFO  [STDOUT]     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
17:30:03,051 INFO  [STDOUT]     at org.hibernate.loader.Loader.doList(Loader.java:1562)
17:30:03,051 INFO  [STDOUT]     at org.hibernate.loader.Loader.list (Loader.java:1545)
17:30:03,051 INFO  [STDOUT]     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
17:30:03,067 INFO  [STDOUT]     at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java :271)
17:30:03,067 INFO  [STDOUT]     at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840)
17:30:03,067 INFO  [STDOUT]     at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
17:30:03,067 INFO  [STDOUT]     at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:603)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:500)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:557)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.XWiki.getXWiki (XWiki.java:202)
17:30:03,067 INFO  [STDOUT]     at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
17:30:03,067 INFO  [STDOUT]     at org.apache.struts.action.RequestProcessor.processActionPerform (RequestProcessor.java:421)
17:30:03,082 INFO  [STDOUT]     at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
17:30:03,082 INFO  [STDOUT]     at org.apache.struts.action.ActionServlet.process (ActionServlet.java:1164)
17:30:03,082 INFO  [STDOUT]     at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
17:30:03,082 INFO  [STDOUT]     at javax.servlet.http.HttpServlet.service(HttpServlet.java :697)
17:30:03,082 INFO  [STDOUT]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
17:30:03,082 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java :252)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:30:03,239 INFO  [STDOUT]     at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter (SetCharacterEncodingFilter.java:127)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:173)
17:30:03,239 INFO  [STDOUT]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:202)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.core.StandardWrapperValve.invoke (StandardWrapperValve.java:213)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
17:30:03,239 INFO  [STDOUT]     at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke (CustomPrincipalValve.java:39)
17:30:03,239 INFO  [STDOUT]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
17:30:03,239 INFO  [STDOUT]     at org.jboss.web.tomcat.security.JaccContextValve.invoke (JaccContextValve.java:59)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
17:30:03,239 INFO  [STDOUT]     at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:148)
17:30:03,239 INFO  [STDOUT]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
17:30:03,239 INFO  [STDOUT]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection (Http11Protocol.java:744)
17:30:03,239 INFO  [STDOUT]     at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
17:30:03,239 INFO  [STDOUT]     at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run (MasterSlaveWorkerThread.java:112)
17:30:03,254 INFO  [STDOUT]     at java.lang.Thread.run(Thread.java:595)
17:30:03,270 WARN  [RequestProcessor] Unhandled Exception thrown: class com.xpn.xwiki.XWikiException
17:30:03,270 ERROR [[action]] Servlet.service() for servlet action threw exception
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences
Wrapped Exception: could not execute query
    at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:142)
    at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
    at com.xpn.xwiki.web.ViewEditAction.execute (ViewEditAction.java:117)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:173)
    at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java :202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java :213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke (SecurityAssociationValve.java:159)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java :744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    at java.lang.Thread.run (Thread.java:595)


Wrapped Exception:


com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences
Wrapped Exception: could not execute query
    at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:540)
    at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:557)
    at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:77)
    at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
    at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418)
    at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
    at com.xpn.xwiki.XWiki .<init>(XWiki.java:343)
    at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
    at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
    at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    at org.apache.struts.action.ActionServlet.process (ActionServlet.java:1164)
    at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    at javax.servlet.http.HttpServlet.service (HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java :173)
    at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java :213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke (SecurityAssociationValve.java:159)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java :744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    at java.lang.Thread.run (Thread.java:595)


Wrapped Exception:


java.sql.SQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8 (T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal (OraclePreparedStatement.java:3285)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java :92)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
    at org.hibernate.loader.Loader.getResultSet (Loader.java:1239)
    at org.hibernate.loader.Loader.doQuery(Loader.java:374)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210)
    at org.hibernate.loader.Loader.doList( Loader.java:1562)
    at org.hibernate.loader.Loader.list(Loader.java:1545)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java :271)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
    at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:603)
    at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:500)
    at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:557)
    at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc (XWikiCacheStore.java:77)
    at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
    at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418)
    at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
    at com.xpn.xwiki.XWiki .<init>(XWiki.java:343)
    at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
    at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
    at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    at org.apache.struts.action.ActionServlet.process (ActionServlet.java:1164)
    at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    at javax.servlet.http.HttpServlet.service (HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java :173)
    at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java :213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke (SecurityAssociationValve.java:159)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service (CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java :744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    at java.lang.Thread.run (Thread.java:595)


And end I got new tables in my DB :

XWIKIATTACHMENT
XWIKIATTACHMENT_ARCHIVE
XWIKIATTACHMENT_CONTENT
XWIKIBOOLEANCLASSES
XWIKICLASSES
XWIKICLASSESPROP
XWIKIDATECLASSES
XWIKIDATES
XWIKIDBLISTCLASSES



I also tried method from John Turner (http://www.objectweb.org/wws/arc/xwiki-users/2006-03/msg00012.html ) but as soon i change the content of "WEB-INF/hibernate.cfg.xml", i got a error with CGLIB.


Thank for help or files from actually working config.


2006/6/21, Srinivasa Pulugurtha < pulugurtha@gmail.com>:
What are exceptions/errors you are noticing when you use Oracle?

I have XWiki working on Oracle, with some good help on this list.  But you want to go this way, expect to invest some time.

Please look for an email from John Turner on this email list and it has some relevent information and attachments.

You also have to copy the seed database from MySQL to Oracle.  I ran a MySQL database with the data and then copied this to Oracle using a java program.

Also, you want to use atleast Oracle 10g drivers.  I had some issues with even that and finally ended up using DataDirect Oracle drivers, which were available in our enterprise.  I wished that I had used them from the beginning of the task.

cheers,
Srini


On 6/21/06, Guillaume François < guillaume.francois55@gmail.com> wrote:
Hye, i'm trying to get working Xwiki with oracle. This works good with MySQL, but when I switch to Oracle this doesn't work. I can connect to xwiki.

Someone could help me ?



--
You receive this message as a subscriber of the xwiki-users@objectweb.org mailing list.
To unsubscribe: mailto: xwiki-users-unsubscribe@objectweb.org
For general help: mailto: sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws





--
You receive this message as a subscriber of the xwiki-users@objectweb.org mailing list.
To unsubscribe: mailto: xwiki-users-unsubscribe@objectweb.org
For general help: mailto: sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws





--
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCS/IT d(+) s++:- a-- C++$ ULC(+)>+++$ !P--- L+>$ !E---? W+++$ !N* !o-- K--? w(+) !O---? !M- !V--? PS+? !PE Y+ PGP++>+++ !t-- !5 !X- R(+)>++* tv-? b(-) DI !D- G(+)>+ e+++ h--() r->$ y?*
------END GEEK CODE BLOCK------