Re: JDBCCTS issues

Dave Cramer wrote:
> Does anyone know what the spec says if a parameter is registered and
> the underlying type is not the same as the registered type?
>
> for instance registerOutParameter( n, Types.Real ) where the underlying
> type is float8
>
> In general should we be attempting to convert to the case requested ?

Ok I stared at the spec a bit..

It seems like the type you specify when registering is the type you
intend to retrieve via a get...() method, and the spec seems to imply
that the driver should cast the parameter to that type.. but it's vague
as usual.

The datatype conversion tables appendix does not talk about datatype
conversion on CallableStatement.get...() at all (though it does talk
about conversion in ResultSet).

So I suppose we should probably accept it and do a cast to the
appropriate type on return.

Am I right in thinking that OUT parameter types aren't considered part
of a function's signature and don't contribute to overloading at all?

-O