I dont have the test case for the given scenrio as per your template but i will explain you in detail
If you could provide one, it would certainly expedite providing you a solution.
5. System is completing the process and returingin the required results but it is hanging / not releasing the connections to Pool.
I want to be clear.
- You are creating a StoredProcedureQuery and registering parameters. What are your inputs and outputs? What are their types?
- You set their values, execute the query and then attempt to obtain the output values.
Is it when you're waiting for the outputs of the above that you observe this "hang" and the code does not proceed? Or is it just the concern that the connection remains listed in a system table and you expect that connection to be dropped entirely? |