G'day Guillaume, I found my earlier post with some code that should help you get started with Oracle - check out: http://mail-archive.objectweb.org/xwiki-users/2006-03/msg00001.html. I also suggest that you browse the archive around the time of the referenced message because Srinivasa Pulugurtha also posted some relevant information. Cheers, John ________________________________ From: Guillaume François [mailto:guillaume.francois55@gmail.com] Sent: Thursday, 22 June 2006 1:38 AM To: xwiki-users(a)objectweb.org Subject: 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 <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(a)gmail.com&gt;gt;: 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(a)gmail.com <mailto: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(a)objectweb.org <mailto:xwiki-users@objectweb.org> mailing list. To unsubscribe: mailto: xwiki-users-unsubscribe(a)objectweb.org For general help: mailto: sympa(a)objectweb.org <mailto:sympa@objectweb.org> ?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws <http://www.objectweb.org/wws> -- You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list. To unsubscribe: mailto: xwiki-users-unsubscribe(a)objectweb.org For general help: mailto: sympa(a)objectweb.org <mailto:sympa@objectweb.org> ?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws <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------