This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC 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

Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
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: 3704

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.

My Blog: Down Home Country Coding with Scott Selikoff
Don't get me started about those stupid light bulbs.
subject: What Does DataSorce Manage Connections