Stored Procedures in der VoltDB

• erzeuge Java-File:

import org.voltdb.*;

public class <class_name> extends VoltProcedure {
  public final SQLStmt <func_name> = new SQLStmt(
    " SELECT *"
    + " FROM foo WHERE bar=?"
    + " ORDER BY whatever ASC;" );
    
  public VoltTable[] run(int bar_value)
    throws VoltAbortException {
    voltQueueSQL( <func_name>, bar_value );
    return voltExecuteSQL();
  }
}

• kompilieren

javac -cp "$CLASSPATH:/opt/voltdb/voltdb/*"  <name>.java

• packen

jar cvf <name>.jar *.class

• Klassen in die VoltDB laden (sqlcmb in /opt/voltdb/bin)

sqlcmd --user=admin --password=<pwd>
1> load classes <name>.jar;

• stored procedure erstellen (bei create procedure ist mehr möglich https://docs.voltdb.com/UsingVoltDB/ddlref_createprocjava.php)

sqlcmd --user=admin --password=<pwd>
1> CREATE PROCEDURE FROM CLASS <class_name>;