I am trying to create a scrollable recordset using the CallableStatement with MS SQL SERVER 2000. When I test the stored proc FORWARD only its fine, but when I try to move through the record set I get an error saying recordset is forward_only.
here is my snippet:
DBMS.JDBCsetup();
Connection conn = DBMS.getConnected ("reports_portal","portal","portal$"
;
CallableStatement cs = conn.prepareCall("{call USP_YOUR_REPORTS (?,?,?)}", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
cs.setInt(1,logge_in.get_accountID());
cs.setInt(2,logge_in.get_access_level());
cs.setString(3,get_user_reports(req));
ResultSet report = cs.executeQuery();
Is this driver sensitive, I am using the jdbcdbc:<database> driver.
I am coverting all my sql statements to stored procs, what I have created works fine if I make a statement.
Is there anyway to set the cs type after the fact.
Thanks in Advance,
Bygs
here is my snippet:
DBMS.JDBCsetup();
Connection conn = DBMS.getConnected ("reports_portal","portal","portal$"
;CallableStatement cs = conn.prepareCall("{call USP_YOUR_REPORTS (?,?,?)}", ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
cs.setInt(1,logge_in.get_accountID());
cs.setInt(2,logge_in.get_access_level());
cs.setString(3,get_user_reports(req));
ResultSet report = cs.executeQuery();
Is this driver sensitive, I am using the jdbc
dbc:<database> driver.I am coverting all my sql statements to stored procs, what I have created works fine if I make a statement.
Is there anyway to set the cs type after the fact.
Thanks in Advance,
Bygs