George created NIFI-1597:
----------------------------
Summary: 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)
