-
1. Re: Oracle Sessions / Connection pool growth??
davidjencks Feb 14, 2002 4:49 PM (in response to stephenw)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? -
2. Re: Oracle Sessions / Connection pool growth??
stephenw Feb 15, 2002 5:34 AM (in response to 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.