WL#1069: Re-initialize Prepared Statement
Affects: Server-4.1 — Status: Assigned — Priority: Medium
Our customers configure their connects to the server such that they lower wait timeout so as to not increase thread count in the server. With the current prepared statement code this causes a problem in that as soon as they disconnect they lose their prepared statement and must re-issue it on their own. This should be handled by the client library. If a disconnection has occured and the PS is no longer in the server then the client should recreate it. So this logic: Connect; Create PS Use PS !disconnect occurs Client makes a request with the PS, reissue the PS to the server, continue on with the clients request. This is related to, but not the same as the worklog entry for caching PS. That will come in a later version (possibly 5.0).
Copyright (c) 2000, 2017, Oracle Corporation and/or its affiliates. All rights reserved.