1. Resultset returned by stored proc not forward only coderanch.com |
2. ResultSet in forward direction error coderanch.comEven if i change scroll insesnsitive to scroll sensitive no change in error .I think scroll-insensitive result set ignores changes that are made while it is open. It provides a static view of the underlying data it contains.If that was the case then why it work when i execute query using execute method |
3. Forward only ResultSet coderanch.com |
4. FORWARD_ONLY Resultset coderanch.comHi All, java version : 1.5.0_06 jdbc driver : ojdbc14dms.jar database : Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi public class RSTest { public static void main(String[] args) throws Exception { DriverManager.registerDriver(new OracleDriver()); Connection c = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:TEST","xxcm","xxcm"); String sql = "select papf.person_id,papf.effective_end_date,papf.person_type_id,papf.current_employee_flag,papf.sex " + " from per_all_people_f papf where employee_number like ? "; PreparedStatement ps = c.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE); ps.setString(1,"4583%"); ResultSet ... |