topic Re: Types for database BLOB field in Talend Studio

Types for database BLOB field

Anonymous — Wed, 12 Jul 2017 14:06:58 GMT

Hi,

I have to extract from an oracle table a BLOB field.

In the schema of my tOracleInput component, I set the type of this field to byte[] and the database type to BLOB:

It works fine but I get this warning at tOracleInput component level:
"The schema's DB type not correct for this component"

How can I get rid of it ? Are my types not correct for a BLOB field ?

Regards.

Eric

Re: Types for database BLOB field

Anonymous — Thu, 13 Jul 2017 09:27:59 GMT

Hello,

Talend will give a warning message to you if the schema type is not the same as dbType. Actually it doesn't affect your job result.

Best regards

Sabrina

Re: Types for database BLOB field

Anonymous — Tue, 23 Jan 2018 05:17:55 GMT

I would add that the warning is often erroneous (at least in 6.x versions), albeit innocuous. For example, create a MySQL table with a field of type int(10). If you do a retrieve schema, Talend will correctly map this to DB Type "INT UNSIGNED", but you'll nonetheless get the "schema's dbType not correct for this component" warning message in a tMySQLInput.