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.