Skip site navigation (1) Skip section navigation (2)

Re: Database Connection pool

From: Chetan Bob <chetanpadhye(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Database Connection pool
Date: 2008-04-29 05:55:00
Message-ID: 16953692.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
> 
> 

-- 
View this message in context: http://www.nabble.com/Database-Connection-pool-tp16930362p16953692.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.


In response to

pgsql-jdbc by date

Next:From: Robert WimmerDate: 2008-04-29 06:41:05
Subject: Re: ERROR: insufficient data left in message
Previous:From: Oliver JowettDate: 2008-04-29 04:37:03
Subject: Re: ERROR: insufficient data left in message

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group