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.