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

Popular posts from this blog

user interface - How to replace the Python logo in a Tkinter-based Python GUI app? -

objective c - Greedy NSProgressIndicator Allocation -

how to set an OCR language in Google Drive -