posted 13 years ago
Normally a connection pool is used for giving connections to the users based on the request for a connection by the user. now let us say i have a connection pool where i have a max of 10 connections and i open these 10 connections but after sometime i close all the connections. therefore when i do that all the connections will be open in the connection pool but i would not again request for these connections until the next day. let us say the request of the connections and closing happens at particular time of the day. then how do the connections get closed should the application accomodate the functionality to close the connections after certain time or how do we do it?