I dont have the test case for the given scenrio as per your template but i will explain you in detail
- Using Spring4.1.3 + JPA + Hibernate 4.3.8 Final
- Using MS SQL Server + Tomcat 8 with Connection Pool (with 2 connections)
- I have a Stored Procedure which is having an insert statement (that includes Select clause -Ex: Insert into temp(column1,column2) Values((select colx from tab1 where id=12),(select coly from tab2 where id=33)).
- I am calling this SP from SPring code using Hibernate and passing the required parameters to SP.
- System is completing the process and returingin the required results but it is hanging / not releasing the connections to Pool.
- I see in MS SQL server in the systems table connections are not released.
|