Derby always maps SMALLINT, INTEGER, REAL, DOUBLE, BIGINT SQL types to Java primitives (short, int, float, double, long) for procedure and functions. Thus passing SQL NULLS or returning them for OUT parameters is not supported.
That's rather unfortunate. Is this due to some restriction in the SQL standard or is it just something missing from Derby?
CHAR, VARCHAR, DECIMAL map to Java object types (String, String, BigDecimal) and thus can be used to pass & return NULL values.
Yes but it would be useful to have the full range of datatypes available.
-- Jeremy
