Вызов Stored Procedure с выходными параметрами по JDBC

/**
 * CallableStatement example, (1) output parameter, db returns integer
 *
 * @return Average weight of all products
 */
public double getAverageProductWeightOutCS() {
    CallableStatement cstmt = null;
    double averageWeight = 0;
 
    try {
        cstmt = connection.getConnection().prepareCall(
                "{call dbo.uspGetAverageProductWeightOUT(?)}");
        cstmt.registerOutParameter("averageWeight", java.sql.Types.DECIMAL);
        cstmt.execute();
        averageWeight = cstmt.getDouble("averageWeight");
    } catch (Exception ex) {
        Logger.getLogger(JdbcStoredProcsExample.class.getName()).log(
                Level.SEVERE, null, ex);
    } finally {
        if (cstmt != null) {
            try {
                cstmt.close();
            } catch (SQLException ex) {
                Logger.getLogger(JdbcStoredProcsExample.class.getName()).log(
                        Level.WARNING, null, ex);
            }
        }
    }
    return averageWeight;
}

Оригинал