groovy-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul King (JIRA)" <j...@apache.org>
Subject [jira] [Issue Comment Deleted] (GROOVY-8128) Breaking change in 2.4.9 with Sql query with GString
Date Thu, 23 Mar 2017 11:13:41 GMT

     [ https://issues.apache.org/jira/browse/GROOVY-8128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Paul King updated GROOVY-8128:
------------------------------
    Comment: was deleted

(was: To authenticate your email, go to http://asp33.mailinblack.com/captchaCom/captcha.jsp?id=NDAyODE2ZGM1Njk4NTVlZTAxNTcyODE2ZmY0NjU4YzE7amlyYUBhcGFjaGUub3JnO0VOOzB3V3ZxbElBQ1NQQW1kVkNHN0l3Si80NUFqVT0=&loc=en
 More information in HTML part
)

> Breaking change in 2.4.9 with Sql query with GString
> ----------------------------------------------------
>
>                 Key: GROOVY-8128
>                 URL: https://issues.apache.org/jira/browse/GROOVY-8128
>             Project: Groovy
>          Issue Type: Bug
>          Components: groovy-runtime
>    Affects Versions: 2.4.9
>         Environment: Windows 7
>            Reporter: Mike Sauer
>            Priority: Critical
>
> The following code worked for releases 2.4.8 and below:
> {code}
>     def query = """\
>     SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED\r\n\
>     select u5f_documenttype from DocVersion dv left outer join ClassDefinition cd on
dv.object_class_id = cd.object_id 
>     where cd.symbolic_name in ('Retail', 'RetailWeb') and dv.is_current = 1
>     and u59_accountnumber = $acctNum and u5f_documenttype = 'Signature Card'
>     """
>     def docFound = 'No Doc'
>     consumerSql.eachRow(query) {
> {code}
> This code now fails in 2.4.9 and 2.4.10 with:
> {noformat}
> Mar 22, 2017 9:23:43 AM groovy.sql.Sql eachRow
> WARNING: Failed to execute:     SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
>     select u5f_documenttype from DocVersion dv left outer join ClassDefinition cd on
dv.object_class_id = cd.object_id 
>     where cd.symbolic_name in ('Retail', 'RetailWeb') and dv.is_current = 1
>     and u59_accountnumber = ? and u5f_documenttype = 'Signature Card'
>      because: com.microsoft.sqlserver.jdbc.SQLServerException: Unable to identify the
table     SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
>     select u5f_documenttype from DocVersion dv left outer join ClassDefinition cd on
dv.object_class_id = cd.object_id 
>     where cd.symbolic_name in ('Retail', 'RetailWeb') and dv.is_current = 1
>     and u59_accountnumber = ? and u5f_documenttype = 'Signature Card'
>      for the metadata.
> {noformat}
> I have tried changing to using placeholders and name parameters and I get similar results.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message