aspose file tools
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 Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "One Connection is sufficient?" Watch "One Connection is sufficient?" New topic

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 in Advance,
Jan Cumps

Joined: Dec 20, 2006
Posts: 2535

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

Joined: May 26, 2003
Posts: 32089

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

Expanding on Jan's reply: Suppose you are running 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
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: One Connection is sufficient?