Dynamic column can't handle blobs ?

[mat2121]

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 ?

[fdenis]

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.