Uploaded image for project: '{RETIRED} XWiki Watch List Application'
  1. {RETIRED} XWiki Watch List Application
  2. XPWATCHLIST-6

Invalid query in watch list plugin and Oracle

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 1.1
    • 1.0.2
    • Plugin
    • None
    • Oracle
    • oracle

    Description

      19:00:00,973 http://localhost:8080/xwiki/bin/view/Main/WebHome [DefaultQuartzScheduler_Worker-8] DEBUG util.JDBCExceptionReporter - could not execute query [select distinct xwikidocum0_.XWD_WEB as col_0_0_, xwikidocum0_.XWD_NAME as col_1_0_, xwikidocum0_.XWD_DATE as col_2_0_ from xwikidoc xwikidocum0_ where extract(year from xwikidocum0_.XWD_DATE)=extract(year from current_date) and extract(month from xwikidocum0_.XWD_DATE)=extract(month from current_date) and extract(day from xwikidocum0_.XWD_DATE)=extract(day from current_date) and extract(hour from xwikidocum0_.XWD_DATE)>extract(hour from current_timestamp)-1 order by xwikidocum0_.XWD_DATE desc]

      java.sql.SQLException: ORA-30076: invalid extract field for extract source

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)

      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)

      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:499)

      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:941)

      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:531)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1036)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2904)

      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2945)

      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:139)

      at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)

      at org.hibernate.loader.Loader.doQuery(Loader.java:662)

      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)

      at org.hibernate.loader.Loader.doList(Loader.java:2145)

      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)

      at org.hibernate.loader.Loader.list(Loader.java:2024)

      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)

      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)

      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)

      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1129)

      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)

      at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNamesInternal(XWikiHibernateStore.java:1853)

      at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:1822)

      at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2242)

      at com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:200)

      at com.xpn.xwiki.api.XWiki.searchDocuments(XWiki.java:402)

      at com.xpn.xwiki.plugin.watchlist.WatchListJob.retrieveUpdatedDocuments(WatchListJob.java:236)

      at com.xpn.xwiki.plugin.watchlist.WatchListJob.execute(WatchListJob.java:89)

      at org.quartz.core.JobRunShell.run(JobRunShell.java:203)

      at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

      19:00:00,973 http://localhost:8080/xwiki/bin/view/Main/WebHome [DefaultQuartzScheduler_Worker-8] WARN util.JDBCExceptionReporter - SQL Error: 30076, SQLState: 99999

      19:00:00,973 http://localhost:8080/xwiki/bin/view/Main/WebHome [DefaultQuartzScheduler_Worker-8] ERROR util.JDBCExceptionReporter - ORA-30076: invalid extract field for extract source

      Attachments

        Issue Links

          Activity

            People

              jvdrean Jean-Vincent Drean
              ludovic Ludovic Dubost
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: