Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.2K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Compression blob ORDS + TOMCAT

Hello,
How does the compression of a blob data via ORDS work?
I tried to enable compression in tomcat:
server.xml
<Connector port=“8443” protocol=“HTTP/1.1" relaxedPathChars=“[]|{}” relaxedQueryChars=‘[]|{}^\`"<>’
maxThreads=“150" SSLEnabled=“true” scheme=“https” secure=“true” compression=“on” compressionMinSize=“1024”
clientAuth=“false” sslProtocol=“TLS” keystoreFile=“/u01/certificat/keystore_tomcat.keystore” keystorePass=“XXX” />
and try the header:
"Accept-Encoding: gzip"
but compression doesn't work
Do you have any idea?
Thank you
Answers
-
What is the mime type of the blob? If compression is on, only these mime types will be compressed by default:
text/html,text/xml,text/plain,text/css,text/javascript,application/javascript,application/json,application/xml
If what mime type you are sending is not in this list, you will need to add the compressibleMimeType attribute to your connector. Documentation can be referenced here: https://tomcat.apache.org/tomcat-9.0-doc/config/http.html
-
I'm having the same issue here. I have ORDS 21.4 being served through Tomcat 8.5. I have compression turned "on" and compressableMimeType set to "text/html,text/xml,application/json"
I can see that the response is of mime type "application/json" and all looks good but no compression has been applied whereas if I do the same test with an HTML page I can see the compression happening.
Am I missing something?
Thanks,
John