21 Jun
2006
21 Jun
'06
1:29 p.m.
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 ?
21 Jun
21 Jun
2:02 p.m.
New subject: [xwiki-users] Xwiki and Oracle
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> 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.orgmailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
5:38 p.m.
New subject: [xwiki-users] Xwiki and Oracle
What I did :
1. change the content of the original "WEB-INF/hibernate.cfg.xml" with
<property name="connection.url">
jdbc:oracle:thin:@[serveradd]:[sport]:[dbname]</property>
<property name="connection.username">[user]</property>
<property name="connection.password">[password]</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver
</property>
<property
name="dialect">org.hibernate.dialect.OracleDialect</property>
2. change the content of the original "WEB-INF/web.xml" with
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
3. append/change the content of the original "WEB-INF/xwiki.cfg" with
xwiki.encoding=UTF-8
xwiki.store.hibernate.updateschema=1
4. I drop all the tables
5. I start the server and go to "
http://localhost:8080/xwiki/bin/view/Main/WebHome"
This lead following errors :
From navigator :
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it
from fulfilling this request.
exception
javax.servlet.ServletException: Error number 3 in 0: Could not initialize
main XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving document
XWiki.XWikiPreferences
Wrapped Exception: Error number 3221 in 3: Exception while saving class
XWiki.XWikiPreferences
Wrapped Exception: Error number 3222 in 3: Exception while saving class
XWiki.XWikiPreferences
Wrapped Exception: Could not execute JDBC batch update
org.apache.struts.action.RequestProcessor.processException(
RequestProcessor.java:516)
org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:423)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java
:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(
SetCharacterEncodingFilter.java:127)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:81)
root cause
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main
XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving document
XWiki.XWikiPreferences
Wrapped Exception: Error number 3221 in 3: Exception while saving class
XWiki.XWikiPreferences
Wrapped Exception: Error number 3222 in 3: Exception while saving class
XWiki.XWikiPreferences
Wrapped Exception: Could not execute JDBC batch update
com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:142)
com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java
:226)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(
SetCharacterEncodingFilter.java:127)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:81)
From server log
17:29:48,614 INFO [ConnectionProviderFactory] Initializing connection
provider: com.xpn.xwiki.store.DBCPConnectionProvider
17:29:49,754 INFO [DBCPConnectionProvider] active: 0 (max: 50) idle:
1(max: 5)
17:29:49,754 INFO [DBCPConnectionProvider] active: 1 (max: 50) idle:
0(max: 5)
17:29:49,754 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle9i
Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
17:29:49,770 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver,
version: 10.2.0.1.0
17:29:49,770 INFO [DBCPConnectionProvider] active: 0 (max: 50) idle:
1(max: 5)
17:29:49,832 INFO [Dialect] Using dialect:
org.hibernate.dialect.OracleDialect
17:29:49,848 INFO [TransactionFactoryFactory] Using default transaction
strategy (direct JDBC transactions)
17:29:49,848 INFO [TransactionManagerLookupFactory] No
TransactionManagerLookup configured (in JTA environment, use of read-write
or transactional second-level cache is not recommended)
17:29:49,848 INFO [SettingsFactory] Automatic flush during
beforeCompletion(): disabled
17:29:49,848 INFO [SettingsFactory] Automatic session close at end of
transaction: disabled
17:29:49,848 INFO [SettingsFactory] JDBC batch size: 15
17:29:49,848 INFO [SettingsFactory] JDBC batch updates for versioned data:
disabled
17:29:49,848 INFO [SettingsFactory] Scrollable result sets: enabled
17:29:49,848 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): enabled
17:29:49,848 INFO [SettingsFactory] Connection release mode: null
17:29:49,848 INFO [SettingsFactory] Default batch fetch size: 1
17:29:49,848 INFO [SettingsFactory] Generate SQL with comments: disabled
17:29:49,848 INFO [SettingsFactory] Order SQL updates by primary key:
disabled
17:29:49,848 INFO [SettingsFactory] Query translator:
org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:29:49,864 INFO [ASTQueryTranslatorFactory] Using
ASTQueryTranslatorFactory
17:29:49,864 INFO [SettingsFactory] Query language substitutions: {}
17:29:49,864 INFO [SettingsFactory] Second-level cache: enabled
17:29:49,864 INFO [SettingsFactory] Query cache: disabled
17:29:49,864 INFO [SettingsFactory] Cache provider:
org.hibernate.cache.EhCacheProvider
17:29:49,879 INFO [SettingsFactory] Optimize cache for minimal puts:
disabled
17:29:49,879 INFO [SettingsFactory] Structured second-level cache entries:
enabled
17:29:49,895 INFO [SettingsFactory] Statistics: disabled
17:29:49,895 INFO [SettingsFactory] Deleted entity synthetic identifier
rollback: disabled
17:29:49,895 INFO [SettingsFactory] Default entity-mode: pojo
17:29:49,989 INFO [SessionFactoryImpl] building session factory
17:29:50,004 WARN [Configurator] No configuration found. Configuring
ehcache from ehcache-failsafe.xml found in the classpath:
jar:file:/R:/java/tools/jboss/4_0_3-eici/server/light/deploy/xwiki.war/WEB-INF/lib/ehcache-
1.1.jar!/ehcache-failsafe.xml
17:29:56,536 INFO [SessionFactoryObjectFactory] Not binding factory to
JNDI, no JNDI name configured
17:29:56,536 INFO [SessionFactoryImpl] Checking 0 named queries
17:29:56,536 ERROR [XWikiHibernateStore] Schema update for wiki xwiki
17:29:56,536 INFO [Dialect] Using dialect:
org.hibernate.dialect.OracleDialect
17:29:56,614 INFO [DBCPConnectionProvider] active: 1 (max: 50) idle:
0(max: 5)
17:29:56,864 INFO [Configuration] processing extends queue
17:29:56,864 INFO [Configuration] processing collection mappings
17:29:56,864 INFO [Configuration] processing association property
references
17:29:56,864 INFO [Configuration] processing foreign key constraints
17:29:57,176 INFO [DatabaseMetadata] table not found: xwikiattachment
17:29:57,301 INFO [DatabaseMetadata] table not found:
xwikiattachment_archive
17:29:57,364 INFO [DatabaseMetadata] table not found:
xwikiattachment_content
17:29:57,442 INFO [DatabaseMetadata] table not found: xwikibooleanclasses
17:29:57,504 INFO [DatabaseMetadata] table not found: xwikiclasses
17:29:57,582 INFO [DatabaseMetadata] table not found: xwikiclassesprop
17:29:57,661 INFO [DatabaseMetadata] table not found: xwikidateclasses
17:29:57,723 INFO [DatabaseMetadata] table not found: xwikidates
17:29:57,801 INFO [DatabaseMetadata] table not found: xwikidblistclasses
17:29:57,864 INFO [DatabaseMetadata] table not found: xwikidoc
17:29:57,911 INFO [DatabaseMetadata] table not found: xwikidoubles
17:29:57,973 INFO [DatabaseMetadata] table not found: xwikifloats
17:29:58,051 INFO [DatabaseMetadata] table not found: xwikiintegers
17:29:58,114 INFO [DatabaseMetadata] table not found: xwikilargestrings
17:29:58,192 INFO [DatabaseMetadata] table not found: xwikilistitems
17:29:58,254 INFO [DatabaseMetadata] table not found: xwikilists
17:29:58,317 INFO [DatabaseMetadata] table not found: xwikilock
17:29:58,395 INFO [DatabaseMetadata] table not found: xwikilongs
17:29:58,473 INFO [DatabaseMetadata] table not found: xwikinumberclasses
17:29:58,536 INFO [DatabaseMetadata] table not found: xwikiobjects
17:29:58,598 INFO [DatabaseMetadata] table not found: xwikiproperties
17:29:58,692 INFO [DatabaseMetadata] table not found: xwikislistclasses
17:29:58,739 INFO [DatabaseMetadata] table not found: xwikistatsdoc
17:29:58,832 INFO [DatabaseMetadata] table not found: xwikistatsreferer
17:29:58,895 INFO [DatabaseMetadata] table not found: xwikistatsvisit
17:29:58,973 INFO [DatabaseMetadata] table not found: xwikistringclasses
17:29:59,036 INFO [DatabaseMetadata] table not found: xwikistrings
17:29:59,114 INFO [DatabaseMetadata] table not found: xwikiattachment
17:29:59,192 INFO [DatabaseMetadata] table not found:
xwikiattachment_archive
17:29:59,270 INFO [DatabaseMetadata] table not found:
xwikiattachment_content
17:29:59,364 INFO [DatabaseMetadata] table not found: xwikibooleanclasses
17:29:59,426 INFO [DatabaseMetadata] table not found: xwikiclasses
17:29:59,504 INFO [DatabaseMetadata] table not found: xwikiclassesprop
17:29:59,567 INFO [DatabaseMetadata] table not found: xwikidateclasses
17:29:59,629 INFO [DatabaseMetadata] table not found: xwikidates
17:29:59,692 INFO [DatabaseMetadata] table not found: xwikidblistclasses
17:29:59,754 INFO [DatabaseMetadata] table not found: xwikidoc
17:29:59,817 INFO [DatabaseMetadata] table not found: xwikidoubles
17:29:59,879 INFO [DatabaseMetadata] table not found: xwikifloats
17:29:59,957 INFO [DatabaseMetadata] table not found: xwikiintegers
17:30:00,020 INFO [DatabaseMetadata] table not found: xwikilargestrings
17:30:00,098 INFO [DatabaseMetadata] table not found: xwikilistitems
17:30:00,161 INFO [DatabaseMetadata] table not found: xwikilists
17:30:00,239 INFO [DatabaseMetadata] table not found: xwikilock
17:30:00,301 INFO [DatabaseMetadata] table not found: xwikilongs
17:30:00,379 INFO [DatabaseMetadata] table not found: xwikinumberclasses
17:30:00,442 INFO [DatabaseMetadata] table not found: xwikiobjects
17:30:00,504 INFO [DatabaseMetadata] table not found: xwikiproperties
17:30:00,567 INFO [DatabaseMetadata] table not found: xwikislistclasses
17:30:00,645 INFO [DatabaseMetadata] table not found: xwikistatsdoc
17:30:00,707 INFO [DatabaseMetadata] table not found: xwikistatsreferer
17:30:00,786 INFO [DatabaseMetadata] table not found: xwikistatsvisit
17:30:00,848 INFO [DatabaseMetadata] table not found: xwikistringclasses
17:30:00,911 INFO [DatabaseMetadata] table not found: xwikistrings
17:30:01,879 ERROR [XWikiHibernateStore] Failed updating schema: ORA-01754:
a table may contain only one column of type LONG
17:30:01,879 ERROR [XWikiHibernateStore] Failed updating schema: ORA-00942:
table or view does not exist
17:30:01,879 INFO [DBCPConnectionProvider] active: 0 (max: 50) idle:
1(max: 5)
17:30:01,879 INFO [DBCPConnectionProvider] active: 1 (max: 50) idle:
0(max: 5)
17:30:01,926 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
17:30:01,926 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not
exist
17:30:01,926 INFO [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.SQLGrammarException: could not load an entity: [
com.xpn.xwiki.doc.XWikiDocument#104408758]
at org.hibernate.exception.ErrorCodeConverter.convert(
ErrorCodeConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(
JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1326)
at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116)
at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:101)
at org.hibernate.persister.entity.BasicEntityPersister.load(
BasicEntityPersister.java:2461)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(
DefaultLoadEventListener.java:350)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(
DefaultLoadEventListener.java:331)
at org.hibernate.event.def.DefaultLoadEventListener.load(
DefaultLoadEventListener.java:113)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(
DefaultLoadEventListener.java:167)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(
DefaultLoadEventListener.java:79)
at org.hibernate.impl.SessionImpl.load(SessionImpl.java:588)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(
XWikiHibernateStore.java:575)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java
:123)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:565)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:599)
at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:1019)
at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:1014)
at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:422)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:397)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
at org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(
RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java
:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(
SetCharacterEncodingFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(
CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(
SecurityAssociationValve.java:159)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(
JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(
MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(
T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
OraclePreparedStatement.java:3329)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java
:118)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1239)
at org.hibernate.loader.Loader.doQuery(Loader.java:374)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
Loader.java:210)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1312)
... 49 more
17:30:01,942 INFO [DBCPConnectionProvider] active: 0 (max: 50) idle:
1(max: 5)
17:30:02,395 INFO [DBCPConnectionProvider] active: 1 (max: 50) idle:
0(max: 5)
17:30:02,411 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
17:30:02,411 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not
exist
17:30:02,411 INFO [DefaultLoadEventListener] Error performing load command
org.hibernate.exception.SQLGrammarException: could not load an entity: [
com.xpn.xwiki.doc.XWikiDocument#104408758]
at org.hibernate.exception.ErrorCodeConverter.convert(
ErrorCodeConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(
JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1326)
at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116)
at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:101)
at org.hibernate.persister.entity.BasicEntityPersister.load(
BasicEntityPersister.java:2461)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(
DefaultLoadEventListener.java:350)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(
DefaultLoadEventListener.java:331)
at org.hibernate.event.def.DefaultLoadEventListener.load(
DefaultLoadEventListener.java:113)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(
DefaultLoadEventListener.java:167)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(
DefaultLoadEventListener.java:79)
at org.hibernate.impl.SessionImpl.load(SessionImpl.java:588)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(
XWikiHibernateStore.java:575)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java
:123)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:565)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:599)
at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1361)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
at org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(
RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java
:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(
SetCharacterEncodingFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(
CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(
SecurityAssociationValve.java:159)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(
JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(
MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(
T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
OraclePreparedStatement.java:3329)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java
:118)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1239)
at org.hibernate.loader.Loader.doQuery(Loader.java:374)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
Loader.java:210)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1312)
... 47 more
17:30:02,411 INFO [DBCPConnectionProvider] active: 0 (max: 50) idle:
1(max: 5)
17:30:02,411 INFO [DBCPConnectionProvider] active: 1 (max: 50) idle:
0(max: 5)
17:30:02,957 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
17:30:02,957 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not
exist
17:30:02,973 INFO [DBCPConnectionProvider] active: 0 (max: 50) idle:
1(max: 5)
17:30:02,973 INFO [STDOUT] com.xpn.xwiki.XWikiException: Error number 3201
in 3: Exception while saving document XWiki.XWikiPreferences
Wrapped Exception: could not execute query
17:30:02,973 INFO [STDOUT] at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(
XWikiHibernateStore.java:540)
17:30:02,973 INFO [STDOUT] at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(
XWikiHibernateStore.java:557)
17:30:02,973 INFO [STDOUT] at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77)
17:30:03,036 INFO [STDOUT] at com.xpn.xwiki.XWiki.saveDocument(
XWiki.java:556)
17:30:03,036 INFO [STDOUT] at com.xpn.xwiki.XWiki.getPrefsClass(
XWiki.java:1418)
17:30:03,036 INFO [STDOUT] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java
:405)
17:30:03,036 INFO [STDOUT] at com.xpn.xwiki.XWiki.<init>(XWiki.java
:343)
17:30:03,036 INFO [STDOUT] at com.xpn.xwiki.XWiki.getMainXWiki(
XWiki.java:134)
17:30:03,036 INFO [STDOUT] at com.xpn.xwiki.XWiki.getXWiki(XWiki.java
:202)
17:30:03,036 INFO [STDOUT] at com.xpn.xwiki.web.ViewEditAction.execute(
ViewEditAction.java:117)
17:30:03,036 INFO [STDOUT] at
org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:421)
17:30:03,036 INFO [STDOUT] at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
17:30:03,051 INFO [STDOUT] at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
17:30:03,051 INFO [STDOUT] at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
17:30:03,051 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(
HttpServlet.java:697)
17:30:03,051 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(
HttpServlet.java:810)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
17:30:03,051 INFO [STDOUT] at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(
SetCharacterEncodingFilter.java:127)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
17:30:03,051 INFO [STDOUT] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:81)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
17:30:03,051 INFO [STDOUT] at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(
CustomPrincipalValve.java:39)
17:30:03,051 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(
SecurityAssociationValve.java:159)
17:30:03,051 INFO [STDOUT] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java
:59)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:107)
17:30:03,051 INFO [STDOUT] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
17:30:03,051 INFO [STDOUT] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
17:30:03,051 INFO [STDOUT] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:744)
17:30:03,051 INFO [STDOUT] at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
17:30:03,051 INFO [STDOUT] at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(
MasterSlaveWorkerThread.java:112)
17:30:03,051 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
17:30:03,051 INFO [STDOUT]
Wrapped Exception:
17:30:03,051 INFO [STDOUT] java.sql.SQLException: ORA-00942: table or view
does not exist
17:30:03,051 INFO [STDOUT] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
17:30:03,051 INFO [STDOUT] at oracle.jdbc.driver.T4CTTIoer.processError
(T4CTTIoer.java:331)
17:30:03,051 INFO [STDOUT] at oracle.jdbc.driver.T4CTTIoer.processError
(T4CTTIoer.java:288)
17:30:03,051 INFO [STDOUT] at oracle.jdbc.driver.T4C8Oall.receive(
T4C8Oall.java:743)
17:30:03,051 INFO [STDOUT] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java
:216)
17:30:03,051 INFO [STDOUT] at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
T4CPreparedStatement.java:799)
17:30:03,051 INFO [STDOUT] at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java
:1039)
17:30:03,051 INFO [STDOUT] at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(
T4CPreparedStatement.java:839)
17:30:03,051 INFO [STDOUT] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1132)
17:30:03,051 INFO [STDOUT] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
OraclePreparedStatement.java:3285)
17:30:03,051 INFO [STDOUT] at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
OraclePreparedStatement.java:3329)
17:30:03,051 INFO [STDOUT] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
17:30:03,051 INFO [STDOUT] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
17:30:03,051 INFO [STDOUT] at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118)
17:30:03,051 INFO [STDOUT] at org.hibernate.loader.Loader.getResultSet(
Loader.java:1239)
17:30:03,051 INFO [STDOUT] at org.hibernate.loader.Loader.doQuery(
Loader.java:374)
17:30:03,051 INFO [STDOUT] at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
Loader.java:210)
17:30:03,051 INFO [STDOUT] at org.hibernate.loader.Loader.doList(
Loader.java:1562)
17:30:03,051 INFO [STDOUT] at org.hibernate.loader.Loader.list(
Loader.java:1545)
17:30:03,051 INFO [STDOUT] at org.hibernate.loader.hql.QueryLoader.list
(QueryLoader.java:375)
17:30:03,067 INFO [STDOUT] at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
17:30:03,067 INFO [STDOUT] at org.hibernate.impl.SessionImpl.list(
SessionImpl.java:840)
17:30:03,067 INFO [STDOUT] at org.hibernate.impl.QueryImpl.list(
QueryImpl.java:74)
17:30:03,067 INFO [STDOUT] at
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java
:603)
17:30:03,067 INFO [STDOUT] at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(
XWikiHibernateStore.java:500)
17:30:03,067 INFO [STDOUT] at
com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(
XWikiHibernateStore.java:557)
17:30:03,067 INFO [STDOUT] at
com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77)
17:30:03,067 INFO [STDOUT] at com.xpn.xwiki.XWiki.saveDocument(
XWiki.java:556)
17:30:03,067 INFO [STDOUT] at com.xpn.xwiki.XWiki.getPrefsClass(
XWiki.java:1418)
17:30:03,067 INFO [STDOUT] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java
:405)
17:30:03,067 INFO [STDOUT] at com.xpn.xwiki.XWiki.<init>(XWiki.java
:343)
17:30:03,067 INFO [STDOUT] at com.xpn.xwiki.XWiki.getMainXWiki(
XWiki.java:134)
17:30:03,067 INFO [STDOUT] at com.xpn.xwiki.XWiki.getXWiki(XWiki.java
:202)
17:30:03,067 INFO [STDOUT] at com.xpn.xwiki.web.ViewEditAction.execute(
ViewEditAction.java:117)
17:30:03,067 INFO [STDOUT] at
org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:421)
17:30:03,082 INFO [STDOUT] at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
17:30:03,082 INFO [STDOUT] at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
17:30:03,082 INFO [STDOUT] at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
17:30:03,082 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(
HttpServlet.java:697)
17:30:03,082 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(
HttpServlet.java:810)
17:30:03,082 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
17:30:03,239 INFO [STDOUT] at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(
SetCharacterEncodingFilter.java:127)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
17:30:03,239 INFO [STDOUT] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:81)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
17:30:03,239 INFO [STDOUT] at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(
CustomPrincipalValve.java:39)
17:30:03,239 INFO [STDOUT] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(
SecurityAssociationValve.java:159)
17:30:03,239 INFO [STDOUT] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java
:59)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:107)
17:30:03,239 INFO [STDOUT] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
17:30:03,239 INFO [STDOUT] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
17:30:03,239 INFO [STDOUT] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:744)
17:30:03,239 INFO [STDOUT] at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
17:30:03,239 INFO [STDOUT] at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(
MasterSlaveWorkerThread.java:112)
17:30:03,254 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
17:30:03,270 WARN [RequestProcessor] Unhandled Exception thrown: class
com.xpn.xwiki.XWikiException
17:30:03,270 ERROR [[action]] Servlet.service() for servlet action threw
exception
com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main
XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving document
XWiki.XWikiPreferences
Wrapped Exception: could not execute query
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:142)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
at org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(
RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java
:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(
SetCharacterEncodingFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(
CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(
SecurityAssociationValve.java:159)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(
JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(
MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Wrapped Exception:
com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving
document XWiki.XWikiPreferences
Wrapped Exception: could not execute query
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(
XWikiHibernateStore.java:540)
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(
XWikiHibernateStore.java:557)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java
:77)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
at org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(
RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java
:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(
SetCharacterEncodingFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(
CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(
SecurityAssociationValve.java:159)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(
JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(
MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Wrapped Exception:
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(
T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
OraclePreparedStatement.java:3329)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java
:118)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1239)
at org.hibernate.loader.Loader.doQuery(Loader.java:374)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(
Loader.java:210)
at org.hibernate.loader.Loader.doList(Loader.java:1562)
at org.hibernate.loader.Loader.list(Loader.java:1545)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(
QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(
AbstractQueryImpl.java:603)
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(
XWikiHibernateStore.java:500)
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(
XWikiHibernateStore.java:557)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java
:77)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:556)
at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1418)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:405)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:343)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:134)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202)
at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117)
at org.apache.struts.action.RequestProcessor.processActionPerform(
RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(
RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java
:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(
SetCharacterEncodingFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(
ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(
CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(
SecurityAssociationValve.java:159)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(
JaccContextValve.java:59)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection
(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(
MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
And end I got new tables in my DB :
XWIKIATTACHMENT
XWIKIATTACHMENT_ARCHIVE
XWIKIATTACHMENT_CONTENT
XWIKIBOOLEANCLASSES
XWIKICLASSES
XWIKICLASSESPROP
XWIKIDATECLASSES
XWIKIDATES
XWIKIDBLISTCLASSES
I also tried method from John Turner (
http://www.objectweb.org/wws/arc/xwiki-users/2006-03/msg00012.html) but as
soon i change the content of "WEB-INF/hibernate.cfg.xml", i got a error with
CGLIB.
Thank for help or files from actually working config.
2006/6/21, Srinivasa Pulugurtha <pulugurtha(a)gmail.com>om>:
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> wrote:
--
-----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------
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.orgmailing list.
To unsubscribe: mailto: xwiki-users-unsubscribe(a)objectweb.org
For general help: mailto: sympa(a)objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
You receive this message as a subscriber of the xwiki-users(a)objectweb.orgmailing list.
To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org
For general help: mailto:sympa@objectweb.org?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
6758
days inactive
6758
days old
2 comments
2 participants
participants (2)
-
Guillaume François -
Srinivasa Pulugurtha