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
- depends on
-
XWIKI-2013 Named HQL queries only support String values HibernateStore.
- Closed