[jira] [Commented] (GROOVY-5436) Enable use of parameter list in SQL IN Clause

["Mauro Molinari (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/GROOVY-5436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16913304#comment-16913304 ] 

Mauro Molinari commented on GROOVY-5436:
----------------------------------------

This would be extremely handy. What is the fate of John's pull request?

> Enable use of parameter list in SQL IN Clause
> ---------------------------------------------
>
>                 Key: GROOVY-5436
>                 URL: https://issues.apache.org/jira/browse/GROOVY-5436
>             Project: Groovy
>          Issue Type: Improvement
>          Components: SQL processing
>    Affects Versions: 1.8.6
>            Reporter: Gerhard Stuhlpfarrer
>            Priority: Major
>
> Groovy SQL (groovy.sql.Sql) provides methods to bind an Array of parameters to sql (e.g. rows, eachRow, execute, executeUpdate, ...).
> But you have a problem if you need to pass parameter lists to your sql statement which has a IN clause.
> There exists a workaround for this problem, but this is not very groovy.
> see discussions here:
> http://groovy.329449.n5.nabble.com/In-operator-in-Groovy-SQL-td4768856.html
> http://stackoverflow.com/questions/2861230/what-is-the-best-approach-using-jdbc-for-parameterizing-an-in-clause



--
This message was sent by Atlassian Jira
(v8.3.2#803003)