Thread: Database Connection pool

Database Connection pool

From
Chetan Bob
Date:
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.

Re: Database Connection pool

From
Dave Cramer
Date:
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.

Re: Database Connection pool

From
John R Pierce
Date:
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.

Re: Database Connection pool

From
Chetan Bob
Date:
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
>
>

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