This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes One Connection is sufficient? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "One Connection is sufficient?" Watch "One Connection is sufficient?" New topic
Author

One Connection is sufficient?

Kousik Majumder
Ranch Hand

Joined: Sep 30, 2007
Posts: 234
Hi all,

I have a query about jdbc that whether a(one) connection is enough for an application.
If not why?
And why do I need multiple connection for an application?


Thanks,
Kousik

Thanks in Advance,
Kousik
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2531
    
  10

If your application only needs one connection, then one connection is sufficient.
A single user application that does no parallel processing might only need one connection.

OCUP UML fundamental and ITIL foundation
youtube channel
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31585
    
185

Kousik Majumder wrote:And why do I need multiple connection for an application?

Expanding on Jan's reply: Suppose you are running Amazon.com and have tons of users. Do you want them waiting on the single connection. The same idea for this site. Do you want to wait in a queue with everyone who wants to post. That would make things unbearably slow!


[OCA 8 book] [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: One Connection is sufficient?