This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem : accessing record from a cursor returned from postgresql

 
Kumar
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have written a stored function in postgreSQL which returns a cursor and trying to access the records of the RecordSet using jdbc callable statements. The result is that it is not displaying anything and the resultset seems to be empty. kindly please guide me as how to approach to achieve the said task. My code looks like this

stored function
---------------
CREATE or REPLACE FUNCTION doQuery(refcursor) RETURNS refcursor AS '
DECLARE
ref refcursor;
BEGIN
open $1 for select * from test;
RETURN $1;
END;
' LANGUAGE plpgsql;

Client Application
------------------
private void listData() {
String cur_name="funccursor";
try {
CallableStatement cst = c.prepareCall("{?=call doQuery(?)}");
cst.registerOutParameter(1, Types.OTHER);
cst.setString(2,cur_name);
cst.execute();
rs = (ResultSet) cst.getObject(1);
while (rs.next()) {
log(rs.getString("name"));
}
} //try
rs.close();
cst.close();
log("Records Retrieved Successfully");
} catch (SQLException sqle) {
log(sqle.getMessage());
log("Error while retrieving Records");
}
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64623
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Kumar JC",

We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Thanks!
bear
Forum Bartender
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic