aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 29219
    
135

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB connection pooling
 
Similar Threads
data source and connection pooling ?
Multi-threaded, jdbc applications.
(Application scoped) DB connection pooling
JDBC Connection
Tomcat Server.xml problem in WSSAD 5.1