====== Stored Procedures in der VoltDB ======



===== Mit Java =====


  * erzeuge Java-File:

<code>
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();
  }
}
</code>

  * kompilieren

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

  * packen

<code>
jar cvf <name>.jar *.class
</code>

  * Klassen in die VoltDB laden (''%%sqlcmb%%'' in ''%%/opt/voltdb/bin%%'')

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

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

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