Hi,
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?
Thanks,
Ana Roizen
PS:
The server is runnig on a Solaris 2.8 , and the DB version is Oracle 8.1.7.
The pool configuration is the folowing:
true
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
true
120000
900000
1200000
true
false
desa
true
1.0
300
30
desa
intrad
true
jdbc:oracle:thin:@dbserver:1521:db8
true