Connection Pooling , Preferred pool size..?

[jsbhangra]

Hi All...
I have built a web-application , which connects to the 10g Express edition at the backend..
I have set the maximum connection pool size to 1500 connections ..
But while load testing according to the client requirements , 18000 requests per minute.
The connection pool chokes up..
Please tell what should i set the value of the preferred maximum pool size ?

-Jasdeep

[vickyk]

"jsbhangra" wrote:

Please tell what should i set the value of the preferred maximum pool size ?

This cannot be told instantly without looking into your application behavior .You need to perform the stress tests under heavy loads and see what connection pool count helps you .
You application might be causing the connection leaks thus resulting in choking of the pool . look at this
http://wiki.jboss.org/wiki/Wiki.jsp?page=CanJBossTellMeWhenIDontCloseAConnection