Types for database BLOB field

Highlighted
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


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.

View solution in original post


All 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.

View solution in original post

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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog