No it was specifically the set up issues that made me use Derby for testing this. That and H2's lack of support for INOUT parameters.

https://groups.google.com/forum/#!topic/h2-database/VLbCEJoGXdA
https://groups.google.com/forum/#!topic/h2-database/-5JJ1xWF9HU

I have had no luck getting procedures/functions defined using their "on the fly" syntax when that procedure/function needs to return a ResultSet. And with regards to the approach you suggest, how do I practically compile the "procedure class" such that it "is available on the H2 database engine classpath"? Remember that for us, the procedure needs to be defined in src/test/java and the test itself is defined in that same src/test/java.