{"id":442,"date":"2010-03-06T00:02:48","date_gmt":"2010-03-05T18:32:48","guid":{"rendered":"https:\/\/2thenew.xyz\/blog\/?p=442"},"modified":"2016-12-19T15:29:23","modified_gmt":"2016-12-19T09:59:23","slug":"grails-handling-staleobjectstateexception-and-making-executeupdate-transactional","status":"publish","type":"post","link":"https:\/\/2thenew.xyz\/blog\/grails-handling-staleobjectstateexception-and-making-executeupdate-transactional\/","title":{"rendered":"Grails: handling StaleObjectStateException and making executeUpdate transactional"},"content":{"rendered":"

Recently I encountered a StaleObjectStateException which said “Row was updated or deleted by another transaction.” We were just updating multiple objects of the same domain inside a loop. So we used executeUpdate statement instead of myClass.save() method to update the records, which worked.<\/p>\n

\n
\n
ReserveAccount.executeUpdate(\"update ReserveAccount set currentBalance=(:balance) where id=(:id)\", [balance: currBalance, id: reserveAccount.id])\r\n<\/pre>\n<\/div>\n<\/blockquote>\n
Later we also needed to update multiple objects of the same domain with same values. But grails executeUpdate statement doesn’t support list as a parameter. So here on the mailing list I found the solution  <\/p>\n
\n
\n
AccountTransactionStatus.withSession {session ->\r\n      session.createQuery(\"\"\"update AccountTransactionStatus t set t.thru=(:today) where\r\n                            t.statusFor in (:selectedList)\"\"\")\r\n\t\t\t     .setParameterList('selectedList', transactions)\r\n\t\t\t     .setParameter('today', new Date()).executeUpdate()\r\n    }\r\n<\/pre>\n<\/div>\n<\/blockquote>\n
Now the concern was to retain my service as transactional since with executeUpdate statement in there, it couldn’t be transactional anymore.  So then we used withTransaction on the parent domain as a block to sorround the executeUpdate statement and along with other statements, which worked.<\/p>\n
\n
\n
 Servicer.withTransaction {\r\n\tmyMap.each {servicerId, amount ->\r\n\t      def servicer = Servicer.read(servicerId)\r\n\t      BigDecimal currBalance = servicer.reserveAccount.currentBalance\r\n\t      currBalance -= amount\r\n\t      ReserveAccount.executeUpdate(\"update ReserveAccount set currentBalance=(:balance) where id=(:id)\", [balance: currBalance, id:\r\n\t\t servicer.reserveAccount.id])\r\n    }\r\n }\r\n<\/pre>\n<\/div>\n<\/blockquote>\n
And other solution to handle StaleObjectStateException exception is given here in the mailing list <\/p>\n
Hope it helped! <\/p>\n
~~Amit Jain~~
\namit@intelligrape.com
\nhttps:\/\/2thenew.xyz<\/p>\n","protected":false},"excerpt":{"rendered":"
Recently I encountered a StaleObjectStateException which said “Row was updated or deleted by another transaction.” We were just updating multiple objects of the same domain inside a loop. So we used executeUpdate statement instead of myClass.save() method to update the records, which worked. ReserveAccount.executeUpdate(“update ReserveAccount set currentBalance=(:balance) where id=(:id)”, [balance: currBalance, id: reserveAccount.id]) Later we […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":13,"footnotes":""},"categories":[7],"tags":[181,4840,179],"class_list":["post-442","post","type-post","status-publish","format-standard","hentry","category-grails","tag-gorm-executeupdate","tag-grails","tag-staleobjectstateexception"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t