jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes What Does DataSorce Manage Connections 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 "What Does DataSorce Manage Connections" Watch "What Does DataSorce Manage Connections" New topic

What Does DataSorce Manage Connections

ravisha andar
Ranch Hand

Joined: Feb 25, 2011
Posts: 55
Hi All,

How exactly does a datasorce manage connections.

Suppose i have configured a datasource with max connections 50.

What will happen if 51 users login concurrently?

How do I handle a concurrent login of 100 users ?

Do i have to set the maximum connections as 100?

Will it be a performance hit.

Please help me understand this?


Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3749

If each user is holding a database connection, you've got a problem right there. Users should never "hold" database connections except for very specific types of applications. Connections in a pool are shared and swapped out all the time. Users may use 10 different distinct connections during their session without even knowing it.

The limit in your example is that a maximum of 50 concurrent processes can hold a connection at a given time. Any processes passed that will either wait or get an out of resource exception.

[OCA 8 Book] [Blog]
I agree. Here's the link: http://aspose.com/file-tools
subject: What Does DataSorce Manage Connections
It's not a secret anymore!