I am implementing Apache DBCP connection to improve efficiency of my program that executes multiple queries.
The issue is that just having a connections pool is not enough because I have multiple data sources as well (I have m - datasaources and each data source has n- connections).
How can solve this issue?
Do I need connection pools for every data source? Is there a pool for datasources?
Yes, you need a pool for each datasource.