Single Connection Pool to quey multiple database servers - TechRepublic
General discussion
July 27, 2009 at 12:11 AM
thirupathik

Single Connection Pool to quey multiple database servers

by thirupathik . Updated 16 years, 11 months ago

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

This discussion is locked

All Comments