FTS Queries For Alfresco Implemention

[mkolas]

In order to take advantage of transactional database queries in 4.2, we need to use FTS or CMIS in place of Lucene throughout the Alfresco Implementation. We're mostly focused on the executeQuery method that is used throughout HPI, but we need to check to see if we need to replace Lucene anywhere else (EnhancedQueryCriteriaBeans, for example)

[gsteimer]

For future reference the benefit of moving to FTS (or CMIS) for the OC query implementation is that these tools solve the Solr "eventual consistency" problem.

Also, from the HPI group discussion, we think that FTS will be easier to migrate to since it is formatted much like Lucene queries. CMIS would be a complete rewrite.

Other Notes:

• This should be in a new query Impl so that we can still support 4.0 and 4.1 Alfresco clients.
• The existing AlfrescoEmbQueryimpl should be deprecated
• Are there any other places that query against Lucene? If so, should this code be using IQuery instead?

[gsteimer]

@mkolas @dgrumieaux @cmlewis - can this be closed out? I thought we migrated to FTS as part of the Alfresco 5 upgrade...

[dgrumieaux]

@gsteimer - The query implementation code now uses FTS as a part of the Alf 5 upgrade, but there are still multiple other places in OpenContent that utilize Lucene if I'm not mistaken. I don't think the list is very long though.