[KAFKA-10103] JDBC Sink Connector doesn't support numerical values in event keys

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 2.0.1
• Component/s: connect
• Assignee: Unassigned
• Reporter: Jakub
• Created: 04/Jun/20 16:55
• Updated: 04/Jun/20 16:55

Description

Our topics contain events with numerical keys and Avro values. We're trying to configure a JDBC connector to export data from these topics to Oracle DB, but it doesn't seem to work.

If we use strings as keys everything works fine, but if we switch to Longs it stops working. We tried different values of key.converter, including org.apache.kafka.connect.converters.ByteArrayConverter, but either parsing of keys doesn't work, or they cannot be mapped to Oracle data type (NUMBER - this happens if we use ByteArrayConverter). 

We also tried using transformations (CAST), but in that case we're getting Cast transformation does not support casting to/from BYTES

Please excuse if this is not a bug and there is a way to work with numerical keys, we just couldn't find anything about that in the documentation.