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
Hello.

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(?,?,?,?,?,?,?,?,?,?)"
, ResultSet.TYPE_SCROLL_INSENSITIVE
, ResultSet.CONCUR_READ_ONLY
);
---
But when I try to execute rs.previous() (where rs is ResultSet object),
I get next exception:
--
com.ibm.db2.jcc.c.SqlException: This method should only be called on
ResultSet objects that are scrollable(type TYPE_SCROLL_SENSITIVE or
TYPE_SCROLL_INSENSITIVE)
at com.ibm.db2.jcc.c.rc.ob(rc.java:3438)
at com.ibm.db2.jcc.c.rc.A(rc.java:1968)
at com.ibm.db2.jcc.c.rc.previous(rc.java:1955)
at mark.Main.test_sp(Main.java:669)
--
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...

Sincerely,
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.