aspose file tools*
The moose likes JDBC and the fly likes what will happen if we access more than the maximum pool size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "what will happen if we access more than the maximum pool size" Watch "what will happen if we access more than the maximum pool size" New topic
Author

what will happen if we access more than the maximum pool size

Sivaraman Lakshmanan
Ranch Hand

Joined: Aug 02, 2003
Posts: 231
Hi All,
I have configured tomcat for connection pooling and made minimum connection size is 20 and maximum allowed is 30. What will happen if we try to access more than 30 connections. Will the system through an error or will the connection wait until next one is available or the pool size will be increased?

My guess is the connection will wait until the timeout and then will throw an error.

Can someone please explain the same. Any help on this is very much appreciated.


Regards,
Sivaraman.L
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5836
    
    7

The thread will wait for maxTime for a connection to become available, after which an exception is thrown.


JBoss In Action
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: what will happen if we access more than the maximum pool size