groovy-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avinash Nanda <avinashonlin...@gmail.com>
Subject Question: Updating a database table
Date Thu, 10 May 2018 15:48:57 GMT
Hi All,

This is my first post here,I am using groovy 2.4.13

Problem: I need to update a value in the oracle database for large
table(754508 records)

Error: Max cursors exceeded

Here is a same code i am using

selectQuery = "select stament goes here"
updateQuery = "Update query with parameters"

sql.row(selectQuery).each{it ->
             sql.execute(updateQuery, [it.name])}
sql.close()

This throws max cursors exceeded and i dont know how to resolve it. Any
help would be appreciated.

Also let me know if there is any additional information is needed.

-- 
Regards
Avi

Mime
View raw message