Re: 7.3 Cursors/ResultSets/CallableStatements - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: 7.3 Cursors/ResultSets/CallableStatements
Date
Msg-id 3D6A1247.7070506@xythos.com
Whole thread Raw
In response to 7.3 Cursors/ResultSets/CallableStatements  (Larry Riedel <larryr@saturn.sdsu.edu>)
Responses Re: 7.3 Cursors/ResultSets/CallableStatements
List pgsql-jdbc
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
>
>
>


pgsql-jdbc by date:

Previous
From: Larry Riedel
Date:
Subject: 7.3 Cursors/ResultSets/CallableStatements
Next
From: Dave Cramer
Date:
Subject: Re: 7.3 Cursors/ResultSets/CallableStatements