Re: 7.3 Cursors/ResultSets/CallableStatements

Larry,

The jdbc driver will not support returning result sets from
callableStatements in 7.3.  You will need to use a regular
Statement/Prepared Statement object and execute a 'select * from func()'
sql statement.  Off the top of my head, I'm not sure how the jdbc
callableStatement syntax is supposed to handle resultsets.

Dave,  correct me if I am wrong here.

thanks,
--Barry


Larry Riedel wrote:

> I am interested in calling a stored procedure through
> a CallableStatement and fetching a ResultSet a
> few rows at a time.  I have seen a few messages
> suggesting all the pieces may be in place for doing
> this kind of thing nicely in 7.3.  Any idea when it
> will become clear what will actually go into 7.3?
>
>
> Larry
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>