B.2. Invoking Stored Procedures

Documentation

VoltDB Home » Documentation » Upgrade Guide

B.2. Invoking Stored Procedures

After your client creates the connection to the database, it is ready to call the stored procedures. You invoke a stored procedure using the callProcedure() method, passing the procedure name and variables as arguments. For example:

VoltTable[] results;
 
try { results = client.callProcedure("LookupFlight",              
                                     origin,
                                     dest,
                                     departtime).getResults();    
} catch (Exception e) {                                           
     e.printStackTrace();
     System.exit(-1);
}

	The `callProcedure()` method takes the procedure name and the procedure's variables as arguments. The `LookupFlight()` stored procedure requires three variables: the originating airport, the destination, and the departure time.
	Once a synchronous call completes, you can evaluate the results of the stored procedure. The `callProcedure()` method returns a `ClientResponse` object, which includes information about the success or failure of the stored procedure. To retrieve the actual return values you use the `getResults()` method.
	Note that since `callProcedure()` can throw an exception (such as `VoltAbortException`) it is a good practice to perform error handling and catch known exceptions.

< previous

table of contents

next >