There are a number of good pools around. apache dbcp, cp30

Yes, it can be done, and it is the recommended way to go for web
applications.

Dave
On 28-Apr-08, at 3:05 AM, Chetan Bob wrote:

> Basically i have one web application and one database associated
> with it Now i want some thing like this I will have about 50
> database of same schema with different data (ofcource) now i will
> have some connection pool like thing which will have database
> connections for each of 50 database Question ) Can i serialize this
> db connections. ? will it rise to performance problem ? basically
> whats the way i can have db connection pool In this way when ever My
> Application make database acsess I will return any of the connection
> i select and so with effect different database and data. Question )
> can it be done ...?? I m using postgres Sql as DB Server. Thanks
> View this message in context: Database Connection pool
> Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.