topic Re: Get backend SQL Query of CMIS Query in Alfresco Forum

Get backend SQL Query of CMIS Query

jigir_shah — Tue, 20 Oct 2020 13:02:39 GMT

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?

Re: Get backend SQL Query of CMIS Query

EddieMay — Tue, 20 Oct 2020 15:00:12 GMT

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,

Re: Get backend SQL Query of CMIS Query

cesarista — Wed, 21 Oct 2020 17:22:07 GMT

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/295846

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.