Oracle Sessions / Connection pool growth??

[stephenw]

Hi,
hope this topic finds you all well and happy and full of the joys of enterprise development...
Well Im currently moving into a testing phase of our ejb app utilizing Oracle and Jboss 2.4.3 and have run into a somewhat huge problem..
Basically the Connection pool seems to have got tired of just being a pool and seems to have turned into a flood..
The scenerio :-
Sun server
Jboss 2.4.3 Jetty
Monitoring Oracle sessions on sun server with Toad
Loading the app with Rational Robot

The robot contains a script that bombbards our web app with requests and searchs, simulating uses.
When monitoring the Oracle Sessions in Toad we seem to get a new Session created each time a call to oracle is made ( select insert etc ).
In Jboss.jcml I have set up the usual oracle datasource properties and made sure the Min (0) and Max (10) sizes are there.
Because of the min and max sizes set on the datasource on e would imagine only ten Oracel sessions :-
One Oracel session for one connection in the pool (??)
But instead we're getting a new session for each DB call. In toad we can see the sessions and even the sql that has been committed, of which we got to about 400 Oracle sessions before the server collapsed under the pool bursting it's banks...
If any one has any info on setting up and closeing connection pools ( thought it was as simple as :-
#
#Wed Aug 15 16:17:29 EDT 2001
BlockingTimeoutMillis=50000
IdleTimeoutMinutes=30
MaxSize=10
CleanupIntervalMinutes=10
MinSize=0
MaxIdleTimeoutPercent=1.0

) then plase reply asap..
Look forward to a reply,
Stephen.

[davidjencks]

If you set logging detailed enough you should see a lot of messages like

handing out object [0/0/10] from pool xxx

returning object [1/3/99] to pool yyy
in server.log.

Can you find them and what do they say?

Does session == connection?

XA or local transactions?

[stephenw]

Hi David,
many thanks for the swift reply.
Iv been trying to set logging on the sql and may need some help.
1. set logging in the mbean descriptor for the datasource :-

jdbc/Oracle/gaxdev6/br01
org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
jdbc:oracle:thin:@gaxdev6:1526:BR01

ba_adm
ba_adm
1.0
true
1000
60000
60000
true
false
true
true

true

1
2

2. have set loggin enabled in the standardjaws.xml file ( however not useing CMP only using BMP so a little confused about this ) : -
true

sooo is there some place else I need to set logging??
Iv brought the documentation ( have actually read it ) and still little confused..
Help appreciated,
Stephen.