Error messages in diagnostic files:Is this fixed in the kernel too? or is it not a real memory leak (=unrecovereable memory is wasted).
diagnostic file: none Error message: none (memory leak)
Appearance: Garbage Collection of unclosed resultset objects in conjunction with closing a connection leads to a memory leak inside the database kernel.
Preconditions and circumstances
The garbage collection of the java virtual machine runs the finalize method of unclosed resultset objects. At the same time the application closes the corresponding connection.
Then the jdbc driver will send a combined "commit work release" and "close cursor <cursorname>"-order to the database kernel. If the kernel process closing the cursor after closing the connection a memory leak inside the database kernel will occur.
Probability that the error occurs
The probability of this memory leak is high in applications which opens/closes connections very often and using the garbage collector for closing resultsets. It is low in applications which uses the resultset.close() method.
Workaround
Decrease the number of opening/closing a connection. U
sing ResultSet.close() for closing your resltsets.
Further documentation
none
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
