Forum Stats

  • 3,734,236 Users
  • 2,246,916 Discussions


Steps to update jdbc.MaxLimit for a REST data service

There is a REST data source based WAR file deployed in Oracle FMW environment. Oracle report module uses this data source to populate data in static HTML pages. The end-users received 505 internal server error while trying to run reports. The managed server log showed the following errors:

Error: Could not obtain a database connection because all connections in the pool: |apex|| were in use. Borrowed Connections: 10 Available Connections: 0 Maximum Connections: 10 ***

[ERROR] [] [oracle.dbtools] [tid: [ACTIVE].ExecuteThread: '29' for queue: 'weblogic.kernel.Default (self-tuning)'] java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: All connections in the Universal Connection Pool are in use[[

InternalServerException [statusCode=500, reasons=[]]

Based on Metalink doc 1592840.1, it is clear that the data source ran out of its default jdbc.MaxLimit of 10.

How can I increase the limit? Do I need to rebuild the WAR file? Could you please share the detailed steps involved?

Thanks in advance!



Sign In or Register to comment.