[
https://issues.apache.org/jira/browse/NIFI-1597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matt Burgess closed NIFI-1597.
------------------------------
> Error with ExecuteSQL Name: Empty
> ---------------------------------
>
> Key: NIFI-1597
> URL: https://issues.apache.org/jira/browse/NIFI-1597
> Project: Apache NiFi
> Issue Type: Bug
> Environment: MsSQL Server Connection
> Reporter: George
>
> In {{[nifi.git] / nifi-nar-bundles / nifi-standard-bundle /
> nifi-standard-processors / src / main / java / org / apache / nifi /
> processors / standard / util / JdbcCommon.java}} the logic is incorrect when
> using MsSQL.
> {code}
> 130 String tableName = "NiFi_ExecuteSQL_Record";
> 131 if(nrOfColumns > 0) {
> 132 String tableNameFromMeta = meta.getTableName(1);
> 133 if (!StringUtils.isBlank(tableName)) {
> 134 tableName = tableNameFromMeta;
> 135 }
> 136 }
> {code}
> When using MsSQL connection the {{meta.getTableName(1)}} returns blank, we go
> into line 133, set {{tableName}} equal to blank and then never set it to
> anything else.
> I propose that we change line 133 to read:
> {code}
> 133 if (!StringUtils.isBlank(tableNameFromMeta )) {
> {code}
> and write unit tests to correctly test this issue.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
