final Sql sql = ...
sql.setEnableMetaDataChecking(false)
(Also see the comment by Saravanan Subiramaniam at the end of the
comments section; have not tried this myself...)
Cheers,
mg
On 10.05.2018 18:15, Avinash Nanda wrote:
Unfortunately i couldnt combine the queries as i have logic which
determines what data to update.
Also i tried looking at the below link but could know where i need to
update the flag:
https://issues.apache.org/jira/browse/GROOVY-8397?page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel&focusedCommentId=16273333#comment-16273333
<https://issues.apache.org/jira/browse/GROOVY-8397?page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel&focusedCommentId=16273333#comment-16273333>
Sorry i tried googling around the issue but didnt find anything relavent
On Thu, May 10, 2018 at 12:08 PM, Daniel.Sun <sun...@apache.org
<mailto:sun...@apache.org>> wrote:
Hi Avinash,
FYI,
https://issues.apache.org/jira/browse/GROOVY-8397?page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel&focusedCommentId=16273333#comment-16273333
<https://issues.apache.org/jira/browse/GROOVY-8397?page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel&focusedCommentId=16273333#comment-16273333>
https://stackoverflow.com/questions/12192592/java-sql-sqlexception-ora-01000-maximum-open-cursors-exceeded
<https://stackoverflow.com/questions/12192592/java-sql-sqlexception-ora-01000-maximum-open-cursors-exceeded>
In addition, I suggest you try to combine update statement and select
statement and execute only one statement, or write an anonymous block
`BEGIN...END` to finish your query and update.
Cheers,
Daniel.Sun
--
Sent from:
http://groovy.329449.n5.nabble.com/Groovy-Users-f329450.html
<http://groovy.329449.n5.nabble.com/Groovy-Users-f329450.html>
--
Regards
Avinash