Re: Version 8.0-310 and PreparedStatement.getParameterMetaData()

Hello All,

I have used PreparedStatement.getParameterMetaData() with version 8.0-310 and obtained the following results:
(1) parameterMetaData.getParameterCount() worked correctly.
(2) parameterMetaData.getParameterType() worked correctly.
(3) parameterMetaData.getParameterClassName() returned null instead of java.lang.String.

Does the third result above indicate a bug, or is this result expected at this stage of development?

Many thanks,
Bruce.

On Thu, 7 Apr 2005, Bruce Raggett wrote:

> I have used PreparedStatement.getParameterMetaData() with version
> 8.0-310 and obtained the following results:
> (1) parameterMetaData.getParameterCount() worked correctly.
> (2) parameterMetaData.getParameterType() worked correctly.
> (3) parameterMetaData.getParameterClassName() returned null instead of
> java.lang.String.
>
> Does the third result above indicate a bug, or is this result expected
> at this stage of development?

Both. It clearly doesn't work, so it's a bug, but at the same time the
method is hardcoded to always to return null, so it's missing code instead
of non-working code. I suppose it should throw an Exception instead of
failing silently, but getting it to work can't be that hard.

Kris Jurka

On Fri, 8 Apr 2005, Kris Jurka wrote:

> On Thu, 7 Apr 2005, Bruce Raggett wrote:
> > [ParameterMetaData.getParameterClassName() doesn't work]
>
> I suppose it should throw an Exception instead of failing silently, but
> getting it to work can't be that hard.

I've made implemented this method in the newly released 8.1dev-400 build.

Kris Jurka

Hello Kris,

I have rerun my test using the newly released 8.1dev-400 build and
ParameterMetaData.getParameterClassName() now returns a valid class.

Thank you very much for your efforts.

Bruce.

----- Original Message -----
From: "Kris Jurka" <books(at)ejurka(dot)com>
To: "Bruce Raggett" <phicorp(at)iinet(dot)net(dot)au>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Monday, April 11, 2005 1:25 PM
Subject: Re: [JDBC] Version 8.0-310 and
PreparedStatement.getParameterMetaData()

>
>
> On Fri, 8 Apr 2005, Kris Jurka wrote:
>
>> On Thu, 7 Apr 2005, Bruce Raggett wrote:
>> > [ParameterMetaData.getParameterClassName() doesn't work]
>>
>> I suppose it should throw an Exception instead of failing silently, but
>> getting it to work can't be that hard.
>
> I've made implemented this method in the newly released 8.1dev-400 build.
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.9.5 - Release Date: 7/04/2005
>
>