X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 572638BA09E for ; Thu, 10 Feb 2005 13:13:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57805-02 for ; Thu, 10 Feb 2005 13:12:56 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr1.postgresql.org (Postfix) with ESMTP id 2838A8B9F85 for ; Thu, 10 Feb 2005 13:12:58 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id j1so91697rnf for ; Thu, 10 Feb 2005 05:12:58 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=f0V8fAaxG0dGGHKmQ3JpjMVTLQtQXd5u/AT3CW6vgimAZssWxJRZ5DzEToQnpjkglv+kSLny31SBFRD8k5vEj29fNfSF9iGvH1+h/PFrpU+pKTnTU7Eat+MLpsibN1X6FPFsF+JBC2gKQzdZmKIH/h39MS2Wvh9RxnzWl5/A75M= Received: by 10.39.3.57 with SMTP id f57mr144073rni; Thu, 10 Feb 2005 05:12:58 -0800 (PST) Received: by 10.38.104.25 with HTTP; Thu, 10 Feb 2005 05:12:58 -0800 (PST) Message-ID: <48f3cd3a05021005123c9b73d4@mail.gmail.com> Date: Thu, 10 Feb 2005 05:12:58 -0800 From: Jimmy P Mani Reply-To: Jimmy P Mani To: pgsql-admin@postgresql.org Subject: stored procedure and java Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.259 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/94 X-Sequence-Number: 16262 hi all , i want to retrieve records from my java program i am getting these exceptions pls help me No class found for refcursor at org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1C onnection.java:693) at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2C onnection.java:117) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2Re sultSet.java:147) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Stat ement.java:329) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat ement.java:48) at UpdateFabric.update(UpdateFabric.java:64) at UpdateFabric.main(UpdateFabric.java:50) CREATE OR REPLACE FUNCTION public.aa() RETURNS refcursor AS 'declare entrys refcursor; begin open entrys for select mat_no,po_no from table; return entrys; end; ' LANGUAGE 'plpgsql' VOLATILE; my java function is public static void update() { try { CallableStatement s1 = con.prepareCall("{?=call aa()}"); s1.registerOutParameter(1,Types.OTHER); s1.execute(); ResultSet rs1 = (ResultSet) s1.getObject(1); while (rs1.next()) { System.out.println((ResultSet)rs1.getObject(1)); } rs1.close(); s1.close(); }catch(Exception e){e.printStackTrace();} } my connection string is Class.forName("org.postgresql.Driver"); Connect = DriverManager.getConnection("jdbc:postgresql://ip/db","72093701",""); ------------------------------------------ is this exception is due to any problem of pgsql driver. if so where we will get the new driver. please help me soon thanks in advance