Network Server should release prepared statements as they are closed on the
client instead of waiting until the section is reused
---------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-1012
URL: http://issues.apache.org/jira/browse/DERBY-1012
Project: Derby
Type: Improvement
Components: Network Server
Versions: 10.2.0.0
Reporter: Kathey Marsden
Priority: Minor
Because DRDA has no CLSSTMT command the client cannot notify the server when a
prepared statement is closed. Currently the server finds out that a statement
has been closed when the client sends a prepare with the same package and
section number. The server then closes the statement and prepares the new one.
This means for example if 20000 statements are valid and open and then all
closed, 20000 prepared statements will stay open on the server until the
connection is closed.
I tend to think that DRDA will have to be enhanced to make this improvement,
but maybe someone has some other ideas.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
