I´m running a J2EE app under JBoss 2_4_10 and I have a question about the behaviour of the pool.
I configured the pool for my user "desa" with a minsize of 30. (I include the whole datasource configuration below)
When I do start the JBoss, I can see at my DB's Monitor that 30 new sessions have been created for user "desa".That´s great.
...But as soon as I run my application, other 3 new sessions/connections are created for user "desa".
So I look at every session's last call time: the first 30 have never been called since start up time. The other 3 have a recent lastcall time.
So a question arises: why does the pool create new sessions instead of using one of the first 30 ?
Lately it´s been happening that the pool exceeds the DB's maximum connection size(450), and my application dies...
Is there a way to track the pools's behaviour?
Can anyone help me?
The server is runnig on a Solaris 2.8 , and the DB version is Oracle 8.1.7.
The pool configuration is the folowing: