Home > Archive > PostgreSQL JDBC > April 2005 > Version 8.0-310 and PreparedStatement.getParameterMetaData()









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Version 8.0-310 and PreparedStatement.getParameterMetaData()
Bruce Raggett

2005-04-07, 8:03 pm

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. getParameterClassNam
e() 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.

Kris Jurka

2005-04-09, 8:26 pm



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. getParameterClassNam
e() 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Kris Jurka

2005-04-11, 7:24 am



On Fri, 8 Apr 2005, Kris Jurka wrote:

> On Thu, 7 Apr 2005, Bruce Raggett wrote:
>
> 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

Bruce Raggett

2005-04-11, 7:24 am

Hello Kris,

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

Thank you very much for your efforts.

Bruce.


----- Original Message -----
From: "Kris Jurka" <books@ejurka.com>
To: "Bruce Raggett" <phicorp@iinet.net.au>
Cc: <pgsql-jdbc@postgresql.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:
>
>
> 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
>
>



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com