spanner/r2dbc test(s) are failing #8978

[ssvir]

Description

added creation of the instance and only then the creation of database, added after block to close delete an instance, db and close all connections Fixes #8978

Note: Before submitting a pull request, please open an issue for discussion if you are not associated with Google.

Checklist

• [ ] I have followed Sample Format Guide
• [ ] pom.xml parent set to latest shared-configuration
• [ ] Appropriate changes to README are included in PR
• [ ] These samples need a new API enabled in testing projects to pass (let us know which ones)
• [ ] These samples need a new/updated env vars in testing projects set to pass (let us know which ones)
• [ ] Tests pass: mvn clean verify required
• [ ] Lint passes: mvn -P lint checkstyle:check required
• [ ] Static Analysis: mvn -P lint clean compile pmd:cpd-check spotbugs:check advisory only
• [ ] This sample adds a new sample directory, and I updated the CODEOWNERS file with the codeowners for this sample
• [ ] This sample adds a new Product API, and I updated the Blunderbuss issue/PR auto-assigner with the codeowners for this sample
• [ ] Please merge this PR for me once it is approved