This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

calling postgres 7.3 functon from java

 
Raghuveer Rawat
Ranch Hand
Posts: 102
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
I am calling postgres 7.3 function that return refcursor from java but I am not successful in my attempt. Any one who has done this before.
I have tried this;
cstmt = con.prepareCall("{ ? = call fnc_get_campaigns () }");
System.out.println("Store Procedure Called");
cstmt.registerOutParameter(1, Types.Other);
cstmt.executeQuery();
rs = (ResultSet) cstmt.getObject(1);
but I came to know this is not possible in postgres7.3
is any one solution which will hanlde refcursor return by postgres.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic