It would be great if we could use a Testcontainer [1] database for local automated testing. Currently OTB is the file based HyperSQL database which doesn't always behave like a production deployment.
I have been able to setup a Docker container with a prepared image of a MS SQL Server database but I have to manually delete the container and recreate it from the image after data is change for a fresh start.
Testcontainers would manage this process automatically every run.
Two requirements to allow this would be:
1. The Testcontainer dependency needs to be on the classpath when the driver attempts the connection to the database.
2. The DatabaseJdbcUrl setting needs to allow a "jdbc:tc:* string.
This would greatly enhance the testing for us.
[1] https://testcontainers.com/guides/getting-started-with-testcontainers-for-java/