File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 3753

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:
subject: What Does DataSorce Manage Connections
It's not a secret anymore!