I was wondering if someone could shed some light on the difference between the JDBC connection caching that is configured in the JDBC Connection Pools section and connection caching provided by the driver. For example, if I use oracle.jdbc.pool.OracleDataSource I see in the "Additional Properties" section the following properties which are both set to false by default:
ExplicitCachingEnabled
ImplicitCachingEnabled
If I used the caching provided by GF which is driver independent would I ever need to enable these properties? My guess is no. Are there any advantages to using the Oracle connection caching instead of that provided by Glassfish aside from the driver neutrality?
Thanks,
-Noah