It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes DB connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "DB connection pooling" Watch "DB connection pooling" New topic

DB connection pooling

Robin John
Ranch Hand

Joined: Sep 10, 2008
Posts: 281

Hi All,

This will be a quick one..

I wanted to know, Lets assume I have 10 small java applications and they have their own Database configurations ( max wait, connection pooling settings, user id/pass, driver settings etc.... ) so my question is if all the 10 applications use the same database at the same time, will there be that many times the number of connection pooling happening ?? or all the applications would use the same connections from the pool as that's the same database?

Application: just jar files, no web application or web servers involved...

Please advice, thanks in advance !

Time is what we want the most, but what we use the worst. -- William Penn
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

Each application would have its own connection pool. Since there is no shared memory location (due to no app server), there isn't a way to share the Java end of the resources.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: DB connection pooling
It's not a secret anymore!