mysql - Java jdbc Resultset data not updated if any change in database -
i'm using type_scroll_sensitive resultset sensitive changes, have understood, while reading database resultset maintained cursor in database .any (commit)changes tuples in database while reading must reflected in result. not happening in scenario. m using mysql. resultset caching in memory ????
preparedstatement st = con.preparestatement("select name user",resultset.type_scroll_sensitive,resultset.concur_read_only); resultset res = st.executequery(); res.setfetchsize(1); while (res.next()) { system.out.println(res.getstring("name")); bufferread.readline(); //hold }
Comments
Post a Comment