File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
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

calling postgres 7.3 functon from java

Raghuveer Rawat
Ranch Hand

Joined: Apr 03, 2003
Posts: 102
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);
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
I agree. Here's the link:
subject: calling postgres 7.3 functon from java
It's not a secret anymore!