FORWARD « Resultset « Java Database Q&A

2. ResultSet in forward direction error

Even 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

4. FORWARD_ONLY Resultset

Hi All, java version : 1.5.0_06 jdbc driver : ojdbc14dms.jar database : Oracle Database 10g Enterprise Edition Release - 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, " + " 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 ...