This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "DB connection pooling" Watch "DB connection pooling" New topic
Author

DB connection pooling

Robin John
Ranch Hand

Joined: Sep 10, 2008
Posts: 271

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
Marshal

Joined: May 26, 2003
Posts: 32633
    
215

Robin,
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: http://aspose.com/file-tools
 
subject: DB connection pooling
 
It's not a secret anymore!