Which connection cache should I use, OracleConnectionCacheImpl or the new Implicit connection cache?
You should use the new Implicit connection caching mechanism. This new connection caching mechanism is driver independent. It provides access to connection caching via OracleDataSource, and supports a number of new features such as • connection attributes to stripe and reuse connections • a connection cache manager per VM to manage one or more connection caches • abandoned connection timeout to reclaim idle checked out connections etc. • Runtime Connection Load Balancing to allocate work to the best performing instancesNote that the old connection cache, OracleConnectionCacheImpl, is deprecated and will be desupported in the next major release.
