[jira] [Commented] (NIFI-1010) When using MSSqlServer Driver with ExecuteSQL always recieve Avro parse error: Empty: Name

["Toivo Adams (JIRA)" <ji...@apache.org>]

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

Toivo Adams commented on NIFI-1010:
-----------------------------------

Great, good catch.

This looks suspiciously same as:

nifi-users mailing list From	Tyler Hawkes <ty...@gmail.com>
Subject	Re: Help with ExecuteSQL
Date	Fri, 18 Sep 2015 03:16:46 GMT

Mark,
Sorry for taking a while to get back to you. I'm running something as
simple as "select db_name() database_name". I had it run an insert
statement just to make sure the connection is working as it should and I
get a row inserted every second into the test table. Any valid query I run
returns the same error of "org.apache.avro.SchemaParseException: empty
name". Is there a way to turn up logging to see what's coming back?


> When using MSSqlServer Driver with ExecuteSQL always recieve Avro parse error: Empty: Name
> ------------------------------------------------------------------------------------------
>
>                 Key: NIFI-1010
>                 URL: https://issues.apache.org/jira/browse/NIFI-1010
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>    Affects Versions: 0.3.0
>         Environment: MSSqlServer
>            Reporter: Scott
>              Labels: ExecuteSQL, MSSql
>   Original Estimate: 1h
>  Remaining Estimate: 1h
>
> When using ExecuteSQL with the MSSqlServerDriver from Microsoft you always get a SchemParseException , Empty: Name.
> This is located in / nifi-nar-bundles / nifi-standard-bundle / nifi-standard-processors / src / main / java / org / apache / nifi / processors / standard / util / JdbcCommon.java line 98.
> The line should read: final String tableName = meta.getTableName(1) == "" ? "table" : meta.getTableName(1);



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)