Test an app that uses JDBC

[aguibert]

User story:

As a user of this test framework, I want to test an app that uses JDBC.

Additional detail:

It is very common for microservice applications to persist data to a database. Relational databases are commonly used for microservices. Some databases we should consider testing with are:

• PostgreSQL
• MySQL
• Microsoft SQLServer
• Oracle XE
• IBM DB2

Recommend that developers use Testcontainers to create an instance of their DB using a Docker container.
Since container start can be expensive, it would be best if we can keep the same database up for all tests, and just wipe the DB clean after every test method and/or class. This behavior should have a reasonable default, and other options should be easily configurable. If users want a more fine-grained direct control over how data is managed between tests, there should be a way that users can plug-in their own pre-populating/clearing logic.

Coordinate design with testing NoSQL databases.

[aguibert]

Covered by this sample app: https://github.com/MicroShed/microshed-testing/tree/master/sample-apps/jdbc-app