Invalid query in watch list plugin and Oracle
---------------------------------------------
Key: XE-180
URL: http://jira.xwiki.org/jira/browse/XE-180
Project: XWiki Enterprise
Issue Type: Bug
Affects Versions: 1.2 RC2
Environment: Oracle
Reporter: Ludovic Dubost
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.xwiki.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
notifications mailing list
notifications@xwiki.org
http://lists.xwiki.org/mailman/listinfo/notifications
