- xwiki-users@xwiki.org - lists.xwiki.org

Quick tutorial on database pages
by Adrian Hall 24 Jun '06

24 Jun '06

Does someone have a tutorial on producing a page that takes data from an SQL database and puts it in a table, or even better, a graphic? -Adrian

1 0

Re: [xwiki-users] all the xwiki.com sites seem to be down?
by wangwh＠att.net 23 Jun '06

23 Jun '06

Hi, Ludovic, I am trying to convince the central New Jersey (in USA) area to set up the Einstein's Alley Web site (regional economic group) based on XWiki. It will bring lots of usage and exposure to XWiki. Could you move einsteinsalley.xwiki.com to a separate server also. Thanks. Regards, Wei-hsing -------------- Original message ---------------------- From: Ludovic Dubost <ludovic(a)xwiki.com> > > While we work on this issue, for those who have an interesting and open > wiki (not private), please let me know here. > We can move these wikis to separate servers. > > Ludovic > > wangwh(a)att.net a écrit : > > Hi, Ludovic, > > > > Bravo! The performance issue is THE worry I have before getting more important > tasks (and groups) on XWiki. > > > > Wei-hsing > > > > -------------- Original message ---------------------- > > From: Ludovic Dubost <ludovic(a)xwiki.com> > > > >> Hi, > >> > >> We are still getting some spam attack. I'm looking to plan the upgrade > >> to xwiki.com very soon (the new version has big performance improvements). > >> This would also allow to start testing the cluster mode > >> > >> Ludovic > >> > >> Brian Knorr a écrit : > >> > >>> Are all the xwiki.com <http://xwiki.com> sites down? > >>> ------------------------------------------------------------------------ > >>> > >>> > >>> -- > >>> You receive this message as a subscriber of the xwiki-users(a)objectweb.org > >>> > >> mailing list. > >> > >>> To unsubscribe: mailto:[email protected] > >>> For general help: mailto:[email protected]?subject=help > >>> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws > >>> > >>> > >> -- > >> Ludovic Dubost > >> XPertNet: http://www.xpertnet.fr/ > >> Blog: http://www.ludovic.org/blog/ > >> XWiki: http://www.xwiki.com > >> Skype: ldubost AIM: nvludo Yahoo: ludovic > >> > >> > >> > >> > > > > > > > > > > > > ------------------------------------------------------------------------ > > > > Sujet: > > Re: [xwiki-users] all the xwiki.com sites seem to be down? > > Expéditeur: > > Ludovic Dubost <ludovic(a)xwiki.com> > > Date: > > Thu, 1 Jun 2006 11:10:27 +0000 > > Destinataire: > > xwiki-users(a)objectweb.org > > > > Destinataire: > > xwiki-users(a)objectweb.org > > > > > > -- > > You receive this message as a subscriber of the xwiki-users(a)objectweb.org > mailing list. > > To unsubscribe: mailto:[email protected] > > For general help: mailto:[email protected]?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.org > mailing list. > > To unsubscribe: mailto:[email protected] > > For general help: mailto:[email protected]?subject=help > > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws > > > > > -- > Ludovic Dubost > XPertNet: http://www.xpertnet.fr/ > Blog: http://www.ludovic.org/blog/ > XWiki: http://www.xwiki.com > Skype: ldubost AIM: nvludo Yahoo: ludovic > > >

2 1

Re: [xwiki-users] datetime in xwiki rss feeds
by Sudhir Rao 22 Jun '06

22 Jun '06

Actually I saw that code. The simplest fix I could figure was this... In the page http://.../xwiki/bin/edit/XWiki/WebRssCode, I replaced this line <dc:date>$currentdoc.date</dc:date> with <dc:date>$xwiki.formatDate($currentdoc.date, "yyyy-MM-dd'T'HH:mm:ss")</dc:date> The fix however omits the timezone. There is java code at http://www.dpawson.co.uk/relaxng/schema/datetime.html which handles the timezone as well. The SimpleDateFormat pattern "yyyy-MM-dd'T'HH:mm:ss.SSSZ" is close as it gives 2005-06-29T17:20:46.171-0800 This however does not work because of the missing colon. It needs to be 2005-06-29T17:20:46.171-08:00 The simplest way seems to be to use commons-lang utilities DateFormatUtils.ISO_DATETIME_TIME_ZONE_FORMAT.format(new Date()) Since commons-lang is already part of the distribution is there a easy way to add this code? I just don't know how to incorporate it in here at this point due to unfamiliarity with velocity, groovy etc. Thanks very much. regards Sudhir On 6/29/05, Ludovic Dubost <ludovic(a)xwiki.com> wrote: > > Yes.. You need to customize the code in BlogRssCode > > http://www.xwiki.com/xwiki/bin/view/XWiki/BlogRssCode?xpage=code > > You can get this code and put it in your wiki and modify it. > The line <dc:date>$currentdoc.display("date", "view", $currentobj)</dc:date> > Should be changed to some conversion.. I'm not sure which one though > If you send us some java code that does the conversion and right > formatting we can adapt it for the scripting > > Ludovic > > Sudhir Rao a écrit : > > >Is there any easy way to change the timestamp format in the rss feed > >which gets generated without modifying xwiki source code? > > > >The field > ><dc:date>Tue Jun 28 16:31:33 PDT 2005</dc:date> > >should have been formatted as per the dateTime spec at > >http://www.w3.org/TR/xmlschema-2/#dateTime > > > >The current behavior seems to throw off the date/time sorting in RSS > >readers as they just ignore the value. > > > >A SimpleDateFormat conversion has been given here.. > > > >http://lists.xml.org/archives/xml-dev/200311/msg00153.html > >which uses the format > >"yyyy-MM-dd'T'HH:mm:ss,SSS'Z'" > > > >Any thoughts? > > > >-Sudhir > > > > > > > >------------------------------------------------------------------------ > > > > > >-- > >You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list. > >To unsubscribe: mailto:[email protected] > >For general help: mailto:[email protected]?subject=help > >ObjectWeb mailing lists service home page: http://www.objectweb.org/wws > > > > > > > -- > Ludovic Dubost > XPertNet: http://www.xpertnet.fr/ > Blog: http://www.ludovic.org/blog/ > XWiki: http://www.xwiki.com > Skype: ldubost AIM: nvludo Yahoo: ludovic > >

4 3

RE: [xwiki-users] Xwiki and Oracle
by Turner, John 22 Jun '06

22 Jun '06

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:[email protected]] 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:[email protected]> > 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:[email protected]> mailing list. To unsubscribe: mailto: xwiki-users-unsubscribe(a)objectweb.org For general help: mailto: sympa(a)objectweb.org <mailto:[email protected]> ?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:[email protected]> ?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------

1 0

RE: [xwiki-users] Xwiki and Oracle
by Turner, John 22 Jun '06

22 Jun '06

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:[email protected]] 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 ?

1 0

internal redirect
by Duke Tantiprasut 21 Jun '06

21 Jun '06

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

1 0

RSS Date problems
by THOMAS, BRIAN M (SBCSI) 21 Jun '06

21 Jun '06

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

2 2

bounty on XWiki?
by jeremi joslin 21 Jun '06

21 Jun '06

Hi everyone, What do you think about enabling anyone to suggest bounty on XWiki ? Example: I need a script for listing all the page in the wiki who contain the word "hate". I don't know how to do it. I'm ready to pay 50$ for this. We need to define some rule, but what do you think about this idea? For example, ubuntu: http://www.ubuntulinux.org/community/bounties/ Jérémi -- Blog: http://www.jeremi.info LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724 http://www.xwiki.org skype: jeremi23 -- msn et gtalk : jeremi23(a)gmail.com

5 8

Xwiki and Oracle
by Guillaume François 21 Jun '06

21 Jun '06

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 ?

2 2

Acting as a user?
by Adrian Hall 20 Jun '06

20 Jun '06

As an administrator of an xwiki, I often find myself debugging permissions problems. When this is done over a wide area (say, the person being in the UK, and I'm on the west coast of the US), it is very problematic. It would be really nice to see what permissions a particular user had on a page, or to "become" the user in question and see it for myself. Is such a function available, and if so - how can I use it? -Adrian

1 0