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
Can you find them and what do they say?
Does session == connection?
XA or local transactions?
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 :-
2. have set loggin enabled in the standardjaws.xml file ( however not useing CMP only using BMP so a little confused about this ) : -
sooo is there some place else I need to set logging??
Iv brought the documentation ( have actually read it ) and still little confused..