X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E534BD1B498 for ; Fri, 23 Apr 2004 15:10:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 17003-04 for ; Fri, 23 Apr 2004 15:10:53 -0300 (ADT) Received: from ind-iport-1.cisco.com (ind-iport-1-sec.cisco.com [64.104.129.9]) by svr1.postgresql.org (Postfix) with ESMTP id A752DD1DB8F for ; Fri, 23 Apr 2004 15:10:50 -0300 (ADT) Received: from india-core-1.cisco.com (64.104.129.221) by ind-iport-1.cisco.com with ESMTP; 24 Apr 2004 05:21:09 +0530 X-BrightmailFiltered: true Received: from cisco.com (charminar.cisco.com [192.135.240.11]) by india-core-1.cisco.com (8.12.10/8.12.6) with ESMTP id i3NIAP8s026069; Fri, 23 Apr 2004 11:10:25 -0700 (PDT) Received: from amtripatw2k07 (dhcp-64-101-101-220.cisco.com [64.101.101.220]) by cisco.com (8.8.8-Cisco List Logging/8.8.8) with ESMTP id XAA05603; Fri, 23 Apr 2004 23:40:05 +0530 (IST) From: "Sumita Biswas" To: "'Tom Lane'" Cc: Subject: Postgres DB Date: Fri, 23 Apr 2004 11:10:41 -0700 Message-ID: <049b01c4295e$4c24c7c0$dc656540@amer.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 Importance: Normal In-Reply-To: <20409.1077506948@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/278 X-Sequence-Number: 17653 Hi All, Our application is using the Postgres 7.3.4-RH database that is packaged with the AS3.0 for CCM. There is a variable type called refcursor that is being used by CAR Functions in Postgres database. This variable works fine when we execute the postgres Function from the database i.e through psql. When we try to execute the Function from java code, it uses pg73jdbc3.jar which is bundled with the Postgres 7.3.4, and pg73jdbc3.jar does not support this variable type refcursor. It works fine with pg74jdbc3.jar which comes along with Postgres 7.4. Is this a bug? Regards, Sumita