This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
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