Thread: 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 >