OPEN DATABASE CONNECTIONS
Error or Problem encountered: When we run the web application with concurrent users it gives an error statement: "Operation timed out" and then the dev team figured from the log that it is attributed to OPEN dB connections
Oracle 9iAS, J2EE, jsp
The test team needs to identify exactly where the dB connections are left open (i.e. page level or class level).
"PLEASE RECOMMEND A TOOL FOR EXACTLY DETERMINING OPEN DB CONNECTIONS"
as of now we have used Silk Performer but not been able to get the most out of it ( probably we are not doing something)
The other promising tool that we have still to work with is JProbe.
Any body who has worked to determine the above info pl. do help.
Re: OPEN DATABASE CONNECTIONS
if it is j2ee, u are using JDBC? U probably have a proc that is not closing its connections. your dba or database developer should be able to look into that.