Monitoring DB cursor leaks

  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.