I am debugging memory leak.
Can anyone explain what happens internally at Informix when a JDBC
application does the following:-
If I am right, ResultSet uses a database cursor internally.
So closing a result set will issue a close cursor command.
PreparedStatment.close() should issue a free prepared statment command.
This way a prepared statement can be reused as long as it is not closed.
In other words every time result set can be closed for a prepared statment
without a memory leak.
Also if onstat -g opn shows growing number of open tables, can it taken
as equivalent of growing open cursors.