[
https://issues.apache.org/jira/browse/CONNECTORS-110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Karl Wright updated CONNECTORS-110:
-----------------------------------
Summary: Max activity and Max bandwidth reports don't work properly under
Derby (was: Max activity and Max bandwidth reports fail under Derby with a
stack trace)
> Max activity and Max bandwidth reports don't work properly under Derby
> ----------------------------------------------------------------------
>
> Key: CONNECTORS-110
> URL: https://issues.apache.org/jira/browse/CONNECTORS-110
> Project: ManifoldCF
> Issue Type: Bug
> Components: Framework crawler agent
> Reporter: Karl Wright
>
> The reason for the failure is because the queries used are doing the
> Postgresql DISTINCT ON (xxx) syntax, which Derby does not support.
> Unfortunately, there does not seem to be a way in Derby at present to do
> anything similar to DISTINCT ON (xxx), and the queries really can't be done
> without that.
> One option is to introduce a getCapabilities() method into the database
> implementation, which would allow ACF to query the database capabilities
> before even presenting the report in the navigation menu in the UI. Another
> alternative is to do a sizable chunk of resultset processing within ACF,
> which would require not only the DISTINCT ON() implementation, but also the
> enclosing sort and limit stuff. It's the latter that would be most
> challenging, because of the difficulties with i18n etc.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
