I was comparing the implementations for RL and JTA, and realized that, for JTA, we manage to delay the acquisition until a Statement is needed to be executed, so I thought we might want to provide a similar behavior for RL as well.

While the current behavior is correct, and we should keep it as the default one, I think it's worth providing that property as well especially for many spring applications that usually run in non-JTA environements.

There, once you enter a @Transactional service method, Hibernate would fetch a Connection from the pool even if the User might do some application-level logic prior to accessing a DAO.