How to CREATE PROCEDURE in H2

database stored-procedures db2 h2
egbokul picture egbokul · Feb 10, 2011 · Viewed 7.9k times · Source

This seems to be a duplicate of the other question with the same title, but it actually isn't.

We have our business logic implemented mostly as DB2 stored procedures (I see that H2 has a DB2-compatibility mode - nice!).

How can we use H2 for in-memory unit testing with these procedures?

Unfortunately H2 seems to lack the CREATE PROCEDURE command from its grammar.

I don't want to use Java functions as stored procedures. It would be best if the very same sql files could be used for testing and production as well... am I asking too much?

EDIT: we also use SQL cursors... again, no sign of support :-(

Answer

Thomas Mueller picture Thomas Mueller · Feb 11, 2011

Unfortunately, the compatibility mode doesn't go as far as supporting SQL prodecures. Currently, the only solution is to use Java functions. SQL cursors are also not supported, sorry. But I will add these feature requests to the roadmap. Patches are welcome of course :-)

Related questions

Store query result in a variable using in PL/pgSQL

How to assign the result of a query to a variable in PL/pgSQL, the procedural language of PostgreSQL? I have a function: CREATE OR REPLACE FUNCTION test(x numeric) RETURNS character varying AS $BODY$ DECLARE name character varying(255); begin …

Read More
How can I check if a View exists in a Database?

I have some SQL code that needs to be executed if a certain View exists in a database. How would I go about checking if the View exists? EDIT: The DBMS being used is Microsoft SQL Server

Read More
How do you debug MySQL stored procedures?

My current process for debugging stored procedures is very simple. I create a table called "debug" where I insert variable values from the stored procedure as it runs. This allows me to see the value of any variable at a …

Read More