Types for database BLOB field

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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.