problems returning a resultset from a function

Поиск
Список
Период
Сортировка
От Leo Martin Orfei
Тема problems returning a resultset from a function
Дата
Msg-id 20040904160747.66889.qmail@web51806.mail.yahoo.com
обсуждение исходный текст
Ответы Re: problems returning a resultset from a function
Список pgsql-jdbc
hi.

I have a problem with postgres functions.
I need return a resultset from a postgres function and
browse the resultset in a java app.
I try with this simple function:

create function test() returns catalog.refcursor as'
declare aux refcursor;
BEGIN
    OPEN aux FOR SELECT name, address FROM table;
    RETURN aux;
END;
'LANGUAGE 'plpgsql';


and the java

CallableStatement cs = null;
ResultSet rs = null;
cs = con.prepareCall("{ ? = call test()}");
cs.registerOutParameter(1, java.sql.Types.OTHER);
rs = cs.executeQuery();
rs.next();
System.out.println("name: " +rs.getString(1));

but throws te following error:

cursor "<unnamed portal 1>" does not exist

I try this too:

Statement s = null;
rs = s.executeQuery("select test()");
rs.next();
System.out.println("name: " +rs.getString(1));

and don't throws an error, but show me the following
result:

name: <unnamed portal 1>

anybody can help me with this?

thnx;





__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: TREPOS Gwenaël
Дата:
Сообщение: JDBC driver for Postgresql 7.5-devel version
Следующее
От: chinmoy
Дата:
Сообщение: Customizing SSL with jdbc