ORA-01000: Maximum open cursors exceeded

[NiceButDim]

Hi,
I hope that this is the correct forum for this question.

I am looking at an intermittant problem in a java program; 'Maximum open cursors exceeded'. The bit of code at fault accesses many tables inside a large loop. Each time it accesses a table it does the following at the start of the block;

Statement st2 = con.createStatement();
ResultSet rs2 = st2.executeQuery(sql);

and then at the end of the block;

rs2.close()
st2.close()

However, I have spotted in 1 instance that the createStatement object is not being closed.

My question is, could this possibly be the source of the problem?

Thanks a lot.

john.

 

[LKBrwnDBA]

Yes.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[NiceButDim]

Great.
Thanks for your help.

john.