[NIFI-5571] PutDatabaseRecord raise error while handle byte array.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.7.1
• Fix Version/s: 1.10.0
• Component/s: Core Framework
• Assignee: Unassigned
• Reporter: musarona
• Created: 04/Sep/18 06:47
• Updated: 22/Jun/21 15:07
• Resolved: 22/Jun/21 15:07

Description

line no:656

when record has some values,the code uses setObject for any value. that will raise error when the value is a Byte Array. 

ps.setObject(i + 1, values[fieldIndexes.get(i)]); 

 

to fix the problem ,use AvroTypeUtil.convertByteArray to convert the value to byte[] ,then setBytes will work OK.

 

if(field.getDataType().getFieldType() == RecordFieldType.ARRAY){
    // byte need to be converted to bytearray
    ByteBuffer byteBufferValue = AvroTypeUtil.convertByteArray((Object[])values[fieldIndexes.get(i)]);
    ps.setBytes(i + 1, byteBufferValue.array());
}else {
    ps.setObject(i + 1, values[fieldIndexes.get(i)]);
}

 

 

Issue Links

• duplicates: NIFI-6409 Error inserting null fields in Teradata (through JDBC)