aspose file tools
The moose likes JDBC and Relational Databases and the fly likes calling postgres 7.3 functon from java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "calling postgres 7.3 functon from java" Watch "calling postgres 7.3 functon from java" New topic
Author

calling postgres 7.3 functon from java

Raghuveer Rawat
Ranch Hand

Joined: Apr 03, 2003
Posts: 102
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.


Raghuveer Rawat<br />SCJP2
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: calling postgres 7.3 functon from java