Обсуждение: Is getProcedureColumns working for pgjdbc2.jar?

Hi,

I am trying to use getProcedureColumns and don't seem to be getting any
responses.

Has anyone else tried to use this functionality and had problems?
getProcedures seems to work fine.

Setup:
SDK 1.3.1_01 - Windows 2000
PostgreSQL - 7.1.3 - Linux, Redhat 7.1 (maybe 7.2)
Latest pgjdbc2.jar driver for JDBC 2.

Tim

Tim,

Looking at the source I see the following comment:

        // for now, this returns an empty result set.

So the answer would be no, getProcedureColumns isn't really implemented
currently.  Patches are welcome to fix this up.

thanks,
--Barry


Tim McAuley wrote:
 > Hi,
 >
 > I am trying to use getProcedureColumns and don't seem to be getting any
 > responses.
 >
 > Has anyone else tried to use this functionality and had problems?
 > getProcedures seems to work fine.
 >
 > Setup:
 > SDK 1.3.1_01 - Windows 2000
 > PostgreSQL - 7.1.3 - Linux, Redhat 7.1 (maybe 7.2)
 > Latest pgjdbc2.jar driver for JDBC 2.
 >
 > Tim
 >
 >
 >
 >
 > ---------------------------(end of broadcast)---------------------------
 > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
 >

I have a patch for this which I will submit this weekend.

Kris Jurka


On Thu, 12 Sep 2002, Barry Lind wrote:

> Tim,
>
> Looking at the source I see the following comment:
>
>         // for now, this returns an empty result set.
>
> So the answer would be no, getProcedureColumns isn't really implemented
> currently.  Patches are welcome to fix this up.
>
> thanks,
> --Barry
>
>
> Tim McAuley wrote:
>  > Hi,
>  >
>  > I am trying to use getProcedureColumns and don't seem to be getting any
>  > responses.
>  >
>  > Has anyone else tried to use this functionality and had problems?
>  > getProcedures seems to work fine.
>  >
>  > Setup:
>  > SDK 1.3.1_01 - Windows 2000
>  > PostgreSQL - 7.1.3 - Linux, Redhat 7.1 (maybe 7.2)
>  > Latest pgjdbc2.jar driver for JDBC 2.
>  >
>  > Tim
>  >
>  >
>  >
>  >
>  > ---------------------------(end of broadcast)---------------------------
>  > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>  >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>