Clever Geek Handbook

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?

+3


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. http://www.h2database.com/html/features.html#user_defined_functions



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.

0


source






More articles:


All Articles