Hi all, Experiencing some MAX OPEN CURSOR oracle errors (ORA -01000) , i'm looking for the cursors leaks ( unclosed ResultSet it seems) in code.
I guess that broker queries well close the result set. So when report queries results iteration are closed ? on HasNext()==false ? Is it possible to check open cursors when releasing connections ? and by the way, close them if needed ? Note : MAX_OPEN_CURSOR Oracle parameter is actually set at 500 by connection ( and 1000 sooner ) Oracle 10, OJB 1.0.4 with some litle updates Regards.