« Return to Thread: Database Connection pool

Re: Database Connection pool

by Chetan Bob :: Rate this Message:

Hi John ,

Thanks for reply ,
See i have application running already which takes data from one db and performs.
Now i want this application should take data from the database depending on the login id i have database designed and running fine so its costly to change either db or code.
If i could do this connection pool and could pick up connection as per the login client the application can l show data and behave as per the data associated with this client. For anther client Db Connection is different as result db is different so here this second client will get different data as well behavior . Like wise i may have about 50 clients in all ....
Please suggest on this ..or any other approach .

Thanks
-Bob

John R Pierce wrote:

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

I'm kind of curious why 50 diifferent databases, and not one database
with some distinguishing data in the tables... are these for 50
different customers or websites or something, and never the data shall
meet? Your request for a connecction pool makes it sounds like one
program would be accessing all 50 of these databases, how does it decide
which, whats the differentiating characteristic?

Normally a pool is used when one program is repeatedly
connecting/disconnecting from a single database, classically like
webpages... with 50 different databases, you'd need 50 different pools.

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

« Return to Thread: Database Connection pool