Nine Stars

Types for database BLOB field

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:

Capture.PNG

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

Re: Types for database BLOB field

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
2 REPLIES
Moderator

Re: Types for database BLOB field

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: Types for database BLOB field

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.