db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Boynes <jboy...@gluecode.com>
Subject Re: How to return null param from a stored procedure?
Date Sun, 03 Oct 2004 07:24:02 GMT
Daniel John Debrunner wrote:
> 
> 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

Mime
View raw message