Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
I am debugging memory leak.
IDS 9.21.UC4
Solaris 2.6
Can anyone explain what happens internally at Informix when a JDBC
application does the following:-
ResultSet.Close()
PreparedStatment.Close()
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.
TIA.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.