[
http://jira.xwiki.org/jira/browse/XPWATCHLIST-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_21554
]
Vincent Massol commented on XPWATCHLIST-6:
------------------------------------------
I've tested it works on Oracle (although this triggered another bug on oracle -
more on that tomorrow)
> Invalid query in watch list plugin and Oracle
> ---------------------------------------------
>
> Key: XPWATCHLIST-6
> URL: http://jira.xwiki.org/jira/browse/XPWATCHLIST-6
> Project: XWiki Watch List Plugin
> Issue Type: Bug
> Affects Versions: 1.0.2
> Environment: Oracle
> Reporter: Ludovic Dubost
> Assigned To: Jean-Vincent Drean
> Fix For: 1.1
>
> Attachments: watchlist_oracle.patch
>
>
> 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
[email protected]
http://lists.xwiki.org/mailman/listinfo/notifications
