chemistry-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Streit <mcs...@gmail.com>
Subject CMIS SQL query String limits: question
Date Thu, 06 Jun 2013 20:05:38 GMT
Hello

I have question which appears to have been raised some time ago:
http://mail-archives.apache.org/mod_mbox/chemistry-dev/201106.mbox/%3C4DF8D70D.7000200%40alfresco.com%3E

In that thread, there is reference made to this:
http://tomcat.apache.org/tomcat-6.0-doc/config/http.html#Standard_Implementation
-> maxHttpHeaderSize

In the thread, it is also mentioned that:

*The CMIS specification says that the server has to add a Location
header to its query response
that is "representing the feed for that query". That basically means
that the query is repeated
in the HTTP header*.
The default header buffer size in Tomcat 6 and 7 is 8k. If you remove
all other headers you
end up with about 7884 byte -- plus/minus a few bytes.
You can increase header buffer size in Tomcat.
in the HTTP header.
The default header buffer size in Tomcat 6 and 7 is 8k. If you remove
all other headers you
end up with about 7884 byte -- plus/minus a few bytes.
You can increase header buffer size in Tomcat.

Just curious - is this something in the specification that can only be
addressed by placing the entire query String in the header?

We have a use case for which the WHERE IN( ) clause could contain up to
1000 or more 16-digit String values inside the WHERE acme:userID IN(
value1, value2, value3....)  part of the query - the acme:employeeID is a
custom metadata property of the implemented content model.

FWIW... we use:

OpenCMIS 0.8.0
Alfresco Enterprise 4.1.3


Thanks

Mark
* *

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message