By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,697 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Trying to get scrollable result set from SQL stored procedure

P: n/a

W2K, v8.2.1, jcc driver

I am trying to get scrollable result set from SQL stored procedure in
my java application using jcc driver.
CallableStatement cs = conn.prepareCall
"call dwhtest.dummyproc(?,?,?,?,?,?,?,?,?,?)"
But when I try to execute rs.previous() (where rs is ResultSet object),
I get next exception:
-- This method should only be called on
ResultSet objects that are scrollable(type TYPE_SCROLL_SENSITIVE or
at mark.Main.test_sp(
I think it means that getting a scrollable cursors from SQL stored
procedures is not supported in java. Am I right?
But can't find any links in documentation about this...

Mark B.

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.