Daily Archives: Monday, September 17, 2012

Stored procedures in HSQLDB

Posted by & filed under Uncategorized.

The only way to implement stored procedures in older versions of HSQLDB involved calling static methods in Java code.  Starting in version 2.2, HSQLDB supports stored-procedures as predefined SQL calls.  Documentation and examples of how to do this are not ideal or abundant.  Here is an example. DROP SCHEMA IF EXISTS example cascade CREATE SCHEMA […]