Re: JDBCCTS issues - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: JDBCCTS issues
Date
Msg-id 42CB122B.6070708@opencloud.com
Whole thread Raw
In response to JDBCCTS issues  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: JDBCCTS issues
List pgsql-jdbc
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

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Streaming blob to db
Next
From: Dave Cramer
Date:
Subject: Re: JDBCCTS issues