Optional Parameters

Jump to bottom

Philippe Marschall edited this page Oct 12, 2016 · 2 revisions

If your stored procedures have optional parameters with default values the best way to deal with them is to overload them on the Java side.

Says for example the salesTax stored procedure takes an optional state parameter the best way to model this would be like this:

public interface TaxProcedures {

  BigDecimal salesTax(BigDecimal subtotal);

  BigDecimal salesTax(BigDecimal subtotal, String state);

}