Hello,
We are currently experiencing an increase of user activity on our ORDS Tomcat web servers. For some requests the current state is that there are no available connections left in the UCP, causing the following error to occur:
Caused by: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use
This is unwanted behavior for our use-cases, since endusers using Oracle forms now see a generic HTTP 500 error appear.
We don't want to increase the maximum connection size for UCP since we don't want to overload the database.
Therefor I wanted to increase UCP's connection wait timeout, so endusers don't receive the HTTP 500 error, but instead are forced to wait some more until the HTTP requests respond when a DB connection becomes available from UCP. However, the documentation of ORDS nowhere specifies how to configure this.
Setup:
ORDS 3.0.5.78
Apache Tomcat 8.5.15 (3 instances)