We have a JDBC connection to some external DB, which can not be easily dumped and deployed somewhere on our side, since it is a secret; we just know that several our SQL requests sent via jdbc connection are working for it; now we need an integration test emulating the real connection to the external machine, not the mock; however, we’d like to introduce some kind of docker container with the java code accepting the jdbc connection in the manner the real db does it; then just to parse the incoming requests and verify the extracted data; the particular jdbc driver on the jdbc client side is not the problem; the problem is that I can’t fugure out is there the api of any Java-written databases to accept the incoming SQL request as an event for this kind of application?
The integration test needing is is due to microservice architecture; we prefer the integration tests with real network connections than mocks.