ZhangCheng created NIFI-7410:
--------------------------------

             Summary: 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
            Reporter: ZhangCheng


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.

But I think  this should be maintained  too.





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

Reply via email to