With JDBC, you can call your function either with PreparedStatement or with
CallableStatement:
try (Connection c = DriverManager.getConnection("jdbc:h2:mem:1")) {
Statement s = c.createStatement();
s.execute("CREATE ALIAS my_stored_proc AS 'BigDecimal send() { return
BigDecimal.ONE; }'");
//
My code is the following:
CREATE ALIAS my_stored_proc AS '
import java.math.BigDecimal;
@CODE
BigDecimal send() {
return BigDecimal.ONE;
}
';
// call the send routine to csmp
SimpleJdbcCall jdbcCall = new SimpleJdbcCall(jdbcTemplate)