Hi,
Currently we are using commons DBCP and as per my project requirement we need connections to two databases located at various locations.We have implemented the DBCP but it is creating two connection pools which is not an efficient way of handling connections. We should have only one connection pool.
Can a single connection pool query multiple databases? Is it possible to do this?
Database Servers: Oracle 10g
Any suggestions are welcome
Thank you in advance
Thiru