Oracle E-Business Connector is similar to Database Connector utilizing the JDBC capabilities, but a different connection pool implementation is used. Unlike the Database Connector, the Connection Pooling option is not exposed in the Connector.
Below are some of the common questions related to the Connection Pooling and Sessions:
What is the connection pool default setup?
- Total number of Connections: 1
- Available number of Connections: 1
- Minimum number of Connections: 32
- Maximum number of Connections: 32
- Initial number of Connections: 1
What is the maximum number of opened sessions?
Maximum number of opened sessions: 32
The Connection Pool is seeded with a single connection and will create new connections as needed up to the Maximum number of connections. It will only keep the minimum number of connections in the pool, so if there is a discrepancy between minimum and maximum, those connections would be closed on return which is why those numbers are equivalent.
How and when are inactive sessions released?
There is a 10 min dead connection check on the pool itself, and we also have a 30 min dead pool check that will shut down pools which are unused within the last 10 mins. If maintain session is used, the same connection will be used for all executions in the process and returned to the pool on process completion.
What is the maximum time to wait for a connection?
180 seconds is the time to wait for an available connection to be opened.