Update more than one row atomically

I need to execute a select and then update some of the rows in the `ResultSet` in an atomic way. The code I am using looks like (simplified): stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery("SELECT ..."); while (rs.next()) { if (conditions_to_update) { rs.updateString(...); rs.updateRow(); } } - Can I guarantee that the updates are going to be executed atomically ? If not, how could I assure that ? - What happens if any other process has changed the database row that you are updating via `updateRow()` ? Is there any way to lock the rows in the `ResultSet` ?

以上就是Update more than one row atomically的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » JavaScript 答疑

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准