Uploaded image for project: 'Hibernate ORM'
  1. HHH-13215

ProcedureCall should implement AutoCloseable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.2.18, 5.3.7, 5.4.0
    • Fix Version/s: 6.0.0.Alpha2
    • Component/s: hibernate-core
    • Labels:
      None
    • backPortable:
      Backport?
    • Last commented by a user?:
      true
    • Sprint:

      Description

      It's not obvious for Hibernate users that both ProcedureCall and the JPA StoredProcedureQuery are leaking the underlying CallableStatement which only gets closed at transaction commit/rollback time.

      Without making this ore obvious, many devs will bump into this issue described here and face ORA-01000 issues.

      I think we should make the ProcedureCall implement the AutoCloseable interface so that we can also use it with JPA StoredProcedureQuery via unwrapping.

      This issue should also explain the behavior in the User Guide.

        Attachments

          Activity

            People

            • Assignee:
              mih_vlad Vlad Mihalcea
              Reporter:
              mih_vlad Vlad Mihalcea
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: