groovy-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MG <mg...@arscreat.com>
Subject Re: Question: Updating a database table
Date Thu, 10 May 2018 18:02:51 GMT
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 <sunlan@apache.org 
> <mailto:sunlan@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


Mime
View raw message