Re: 7.3 Cursors/ResultSets/CallableStatements
От | Dave Cramer |
---|---|
Тема | Re: 7.3 Cursors/ResultSets/CallableStatements |
Дата | |
Msg-id | 1030367530.12890.251.camel@inspiron.cramers обсуждение исходный текст |
Ответ на | Re: 7.3 Cursors/ResultSets/CallableStatements (Barry Lind <barry@xythos.com>) |
Ответы |
Re: 7.3 Cursors/ResultSets/CallableStatements
|
Список | pgsql-jdbc |
Barry, I think notionally the idea would be to call a stored proc which returned a cursor, and when result set's supported cursors this would be feasible. I'm still not sure how we tell if the stored proc returned a cursor? Dave On Mon, 2002-08-26 at 07:34, Barry Lind wrote: > 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 > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > >
В списке pgsql-jdbc по дате отправления: