Hello,
We have a Kafka topic with AVRO schema as follows,
{
“type”: “record”,
“name”: “CaseInfo”,
“namespace”: “case.avro”,
“fields”: [
{
“name”: “caseid”,
“type”: “string”
},
{
“name”: “caseData”,
“type”: [
“null”,
“string”
],
“default”: null
}
]
}
Now caseData is XML string and we want to persist it in Oracle database using JDBCSinkConnector.
We have created a Table with XMLType column
Database Table case_info
caseId, varchar2
casedata, XMLType
The SinkConnector fails with following error
ORA-01461: can bind a LONG value only for insert into a LONG column.
So we tried to convert the XML to JSON and sent JSON string in caseData and tried to persist it in a Blob column and it fails with
java.sql.SQLException: ORA-01465: invalid hex number
though there are no hex chars in the string. We then tried to persist this JSON string in a CLOB column and it worked.
Is there a way to persist large String from kafka topic to XMLType or Blob using JDBCSinkConnector?