Is there an inmemory database that supports the stored procedure?

I have a spring boot application that has spring ws and a backend as a stored procedure, I am trying to write integration tests for this and look for an inmemmory database that supports the stored procedure?

I tried with h2 database but it is looking for java functions to work with stored procedure. Do I have any direct mechanism where I can put my stored procedure with minimal effort?


source to share

1 answer

therefore there is no ready-made solution. I needed this to test the integration, but the solution provided by the h2 database required me to rewrite the stored procedure in Java classes.

Given the pain to write an integration test and the amount of effort, I decided to go against it. Hope this can help someone else.



All Articles