Get backend SQL Query of CMIS Query

[jigir_shah]

Hello All,

We have ACS 6.2.1 version without Solr or search services. We are using CMIS queries to search documents. When I am executing CMIS Queries, in back-end, Alfresco DB query should be hitting.

I would like to get equivalent SQL Query of my CMIS Query. How can I get that? What all Loggers should I need to enable in log4j.properties?

Can anyone please help me out here? 

[EddieMay]

Hi @jigir_shah 

Here is something about CMIS queries that should help you. And from the same author I think this blog might prove pretty useful too.

HTH,

[cesarista]

Hi:

When you say that you are using ACS 6.2.1 version without Solr or search services sounds quite odd. First not all CMIS queries must be solved directly with the database (just put a TEXT or IN_TREE operator for example) , so not all CMIS queries are transactional. Besides, search subsystem must be configured this way, try first database if possible.

https://docs.alfresco.com/5.2/concepts/intrans-metadata-query.html

If you use some kind of SQL profiler in your database you may have this type of info. It is only useful if by performance considerations, when you have to add additional indexes in your database.

https://hub.alfresco.com/t5/alfresco-content-services-blog/alfresco-6-profiling-with-docker/ba-p/295...

If loggers are not enough, I remember a jdbc profiler too:

https://github.com/p6spy/p6spy

Regards.

--C.

P.S: Thanks Eddie for the links.