The ultimate outcome of this work is recognition of the following valid selections (represented by the org.hibernate.resource.jdbc.spi.PhysicalConnectionHandlingMode enum):

• IMMEDIATE_ACQUISITION_AND_HOLD - (this is the new option) The Connection will be acquired as soon as the Session is opened and held until the Session is closed. This is the only valid combination including immediate acquisition of the Connection
• DELAYED_ACQUISITION_AND_HOLD - (original legacy behavior) The Connection will be acquired as soon as it is needed and then held until the Session is closed. This is the original Hibernate behavior.
• DELAYED_ACQUISITION_AND_RELEASE_AFTER_STATEMENT - The Connection will be acquired as soon as it is needed; it will be released after each statement is executed.
• DELAYED_ACQUISITION_AND_RELEASE_AFTER_TRANSACTION - The Connection will be acquired as soon as it is needed; it will be released after each transaction is completed.