Dynamic column can't handle blobs ?

mat2121 — Sat, 16 Nov 2024 05:39:46 GMT

Hi,

I'am trying to extract data from an ORACLE database.

The table contains a BLOB, but when I try to get the data with a tJDBCInput and dynamic column I get this error

java.lang.UnsupportedOperationException: Unrecognized java class java.lang.Object
	at org.talend.codegen.converter.TypeConverter.getDiByJavaClass(TypeConverter.java:171)
	at org.talend.codegen.converter.TypeConverter.avroToDi(TypeConverter.java:123)
	at dmprocess.extractionprocess_0_1.ExtractionProcess.tJDBCInput_1Process(ExtractionProcess.java:3375)
[...]

Seems like the dynamic schema handler can't map a binary datatype.

Any idea ?

Re: Dynamic column can't handle blobs ?

fdenis — Wed, 05 Jun 2019 11:19:41 GMT

if you have blob you may have key into your tables.
so you can use dynamics for all but no clob/blob.
and an other job or lockup to get clob/blob fields.

topic Dynamic column can't handle blobs ? in Talend Studio

Dynamic column can't handle blobs ?

Re: Dynamic column can't handle blobs ?