Get backend SQL Query of CMIS Query

cancel
Showing results for 
Search instead for 
Did you mean: 
Active Member

Get backend SQL Query of CMIS Query

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? 

2 Replies
Community Manager
Community Manager

Re: Get backend SQL Query of CMIS Query

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,

Digital Community Manager, Alfresco Software.
Problem solved? Click Accept as Solution!
Customer

Re: Get backend SQL Query of CMIS Query

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.