Connection acquired while calling a stored procedure via JPA is not released [SPR-16826]

[spring-projects-issues]

Gaurav Khandelwal opened SPR-16826 and commented

When a DB stored procedure is called via Spring JPA, connection acquired from Connection Pool is not release back after calling.

 

Inside Class org.springframework.orm.jpa.SharedEntityManagerCreator and method invoke()

entity manager is only closed if method name matches "queryTerminatingMethods" set which does not include "execute" method used for calling Stored Procedure.

---

Affects: 4.3.17, 5.0.6

Attachments:

• Connection Not Closed.JPG (102.95 kB)

Issue Links:

• SharedEntityManagerCreator should support deferred access to StoredProcedureQuery output parameters [SPR-17115] #21652 SharedEntityManagerCreator should support deferred access to StoredProcedureQuery output parameters

Referenced from: commits 997ca5c, 3978d55, 3c8c996

Backported to: 4.3.18

[spring-projects-issues]

Gaurav Khandelwal commented

@Juergen

 

Thanks for resolving this issue.

Please let me know how we can get this fix?

[spring-projects-issues]

Juergen Hoeller commented

This fix is available in the latest 5.0.7.BUILD-SNAPSHOT as well as 4.3.18.BUILD-SNAPSHOT now (available from repo.spring.io/libs-snapshot). See https://projects.spring.io/spring-framework/ for convenient POM snippets for the snapshots.