[jira] [Updated] (NIFI-7410) Clob unreadable code when convertToAvroStream in JdbcCommon.java

["Pierre Villard (Jira)" <ji...@apache.org>]

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

Pierre Villard updated NIFI-7410:
---------------------------------
    Fix Version/s: 1.12.0
       Resolution: Fixed
           Status: Resolved  (was: Patch Available)

> Clob unreadable code when convertToAvroStream in JdbcCommon.java 
> -----------------------------------------------------------------
>
>                 Key: NIFI-7410
>                 URL: https://issues.apache.org/jira/browse/NIFI-7410
>             Project: Apache NiFi
>          Issue Type: Bug
>    Affects Versions: 1.11.4
>            Reporter: ZhangCheng
>            Assignee: ZhangCheng
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.12.0
>
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> when ExecuteSql or QueryDataBaseTable processor trigger below code in JdbcCommon.java ,clob would be unreadable code（with Chinese character）
> {code:java}
> if (javaSqlType == CLOB) {
>                         Clob clob = rs.getClob(i);
>                         if (clob != null) {
>                             long numChars = clob.length();
>                             char[] buffer = new char[(int) numChars];
>                             InputStream is = clob.getAsciiStream();
>                             int index = 0;
>                             int c = is.read();
>                             while (c >= 0) {
>                                 buffer[index++] = (char) c;
>                                 c = is.read();
>                             }
>                             rec.put(i - 1, new String(buffer));
>                             clob.free();
>                         } else {
>                             rec.put(i - 1, null);
>                         }
>                         continue;
>                     }
> {code}
> I konw this can be resoveld by using ExecuteSqlRecord and QueryDatabaseTableRecord. Then have new avroWriter(by using controller cervice), so I think ,can we change the DefaultAvroSqlWriter to the new  avroWriter?



--
This message was sent by Atlassian Jira
(v8.3.4#803005)