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>:
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------
Guillaume,
There are a number of steps you need to take:
1. create your own database object create script.
2. create a hibernate mapping for your oracle DB (there are some differences in the Oracle and MySQL data types).
3. create a hibernate configuration file.
4. you may need to create some custom types to handle Oracle BLOBs or CLOBs depending on the Oracle version and JDBC drivers being used.
I posted some messages giving more detail earlier this year - I suggest you visit the archive and review those messages.
Regards, John Turner
_____
From: Guillaume François [mailto:guillaume.francois55@gmail.com]
Sent: Wednesday, 21 June 2006 9:30 PM
To: xwiki-users(a)objectweb.org
Subject: [xwiki-users] Xwiki and Oracle
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 ?
Hi All,
At the moment I'm using the HTML <head> / <meta> tags to redirect a page to
another page. The initial redirect page is need to do some processing which
then determines which page to redirect to. The bad news is that the page
loads in the browser then loads the final page which looks a bit ugly.
Is there a way to internally redirect on the server side to load and display
another page without using the browser redirect?
Thanks
Duke
One of my favorite RSS display programs is picky, and displays (Invalid Date) on the items' date entries. Investigation into this revealed that it insists on the correct format of the dc:date element in the item's header.
This is specified by ISO 8601, which in turn refers to the W3C standards, which indicate that the separator between the date and time fields, which for most sane people is a space, must be an upper-case 'T'.
I dutifully changed XWiki.WebRssCode and XWiki.BlogRssCode, et voilà : no more error, just nice date/time fields.
Life is good - until my sysadmin starts complaining about megabytes per minute of logfile accumulation, resulting from 20 60+-line exception stack traces per RSS request. I look at the logs and what do I see? Each one is a complaint from java.text.SimpleDateFormat.compile:
java.lang.IllegalArgumentException: Illegal pattern character 'T'
I have sought in vain for how to get this 'T' into the default pattern character array. It looks like it could be one of the things I can set in the Locale, but I have so far failed to figure out where the defaults are located or what key they have.
Any clues?
Brian M. Thomas - Senior Technical Architect
AT&T Services, Inc.
One SBC Center, Room 24D3
St. Louis, MO 63101
314 235 3141
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 ?
