Originally posted by Chhaya Dhanani:
hi all,
i have a connection pool which is allocating 10 connections in my classes..
i have used only one connection per session.. and taken care of returning it back to the pool.This is logged in a log file which lets me know which class has not returned a connection..
the problem i am facing is although connections are closed , i am getting a maximum cursors exceeded exception on oracle..
i have taken care to close all resultsets and statements..
Why is this still happening.. can any one suggest a way out
is it possible to find out which class is not closing the statements and resultsets by writing a small java utility code. or any other work around...(as i have around 80 classes and going thru each one of them will not be possible)
PLEASE REPLY ASAP!!!
Thanx in advance..
Chhaya
Consider Paul's rocket mass heater. |