Revert "GRAILS-11133 assign Connection of current session to session created in withNewSession"

This reverts commit 5a6a999c854e83c721c2cab467becd0ea12bbdec.

- The connection of the previous Hibernate session might not belong to the current transaction.
- Let the TransactionAwareDataSourceProxy return the connection for the new Hibernate session instead.