Re: [xwiki-users] Xwiki and Oracle

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 &lt;pulugurtha(a)gmail.com&gt;om>: -- -----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------