I am working on a requirement to develop a generic cdc consumer using kafka . The records are put into kafka using jdbc connector , so based on the source the avro schema may vary . For example if I use Idcol which is long data type in the java , the datatypes in the databases could be different
I am working on a requirement to develop a generic cdc consumer using kafka . The records are put into kafka using jdbc connector , so based on the source the avro schema may vary . For example if I use Idcol which is long data type in the java , the datatypes in the databases could be different
oracle:
So when ever I tried to deserialize the data using avro mapper , the code works for postgres and fails for the oracle & mssql with exception.
com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot deserialize instance of
long
out of VALUE_EMBEDDED_OBJECT tokenI can avoid this by adding a custom deserializer above the destination POJO , some thing like this
But this is the same case for all the data types like int , boolean, short etc ..,
I am mapping the pojo using the following snippet
Let me know if I am missing some thing , any help is appreciated .