Oracle offers 4 different JDBC connection pooling mechanisms when the OCI driver is used for JDBC connections:
- Oracle DataSource
- Oracle OCI Connection Pooling
- Oracle UCP (Universal connection pooling -recommended over OracleDataSource)
- Oracle Database Resident Connection pooling
What are the pros and cons of using Oracle UCP (Universal Connection Pooling) as compared to Oracle OCI Connection Pooling provided by the OCI driver?