Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORDS - How to increase DB connection wait timeout

User_IIBJ5Nov 25 2022

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)

Comments
Post Details
Added on Nov 25 2022
1 comment
1,134 views