| 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 |