Meaningless Drivel is fun!
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
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: 237
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: 2565

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
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

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]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: One Connection is sufficient?
It's not a secret anymore!