Backport "DatabasePopulatorUtils uses non-transactional connection" [SPR-9465]

[spring-projects-issues]

Chris Beams opened SPR-9465 and commented

---

This issue is a backport sub-task of #14092

[spring-projects-issues]

Chris Beams commented

commit a9c80bfd7b62b59a225d06165f09ca760b0b3b0f
Author: Oliver Gierke <ogierke@vmware.com>
Commit: Chris Beams <cbeams@vmware.com>

    Use transactional connection during db population
    
    Previously, DatabasePopulatorUtils#execute looked up a Connection from
    the given DataSource directly which resulted in the executed statements
    not being executed against a transactional connection (if any) which in
    turn resulted in the statements executed by the populator potentially
    not being rolled back.
    
    Now DataSourceUtils#getConnection is used to transparently take part in
    any active transaction and #releaseConnection is used to ensure the
    connection is closed if appropriate.
    
    Issue: SPR-9465
    Backport-Issue: SPR-9457
    Backport-Commit: 49c9a2a9157861bad53ec47b67c8d821b0b4655a