This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB connection pooling" Watch "DB connection pooling" New topic
Author

DB connection pooling

Robin John
Ranch Hand

Joined: Sep 10, 2008
Posts: 270

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30123
    
150

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
 
subject: DB connection pooling
 
Similar Threads
Tomcat Server.xml problem in WSSAD 5.1
Multi-threaded, jdbc applications.
data source and connection pooling ?
JDBC Connection
(Application scoped) DB connection pooling