Skip directly to content

VoltDB 4.0

VoltDB is a Churning Urn of Groovy Funk

Tuesday, February 11, 2014 - 12:00am

written by Stefano Santoro on February 11, 2014

VoltDB is welcoming Groovy into its ecosystem as its first inline procedure language. Code your procedure logic straight into the DDL, bypassing the java procedure requirements to edit/compile java source files separately.

With VoltDB Groovy stored procedures you can code your procedure implementation as part of CREATE PROCEDURE statements in your DDL file.

CREATE PROCEDURE groovy.procedures.Item AS ###

selectItem = new SQLStmt('SELECT ITEM_ID, DESCRIPTION FROM ITEMS WHERE ITEM_ID = ?')

transactOn = { id ->

    voltQueueSQL(selectItem,