the schema's dbType not correct for this component - TOS 7, OracleDB

Five Stars

the schema's dbType not correct for this component - TOS 7, OracleDB

In tOracleOutput I need to write a Talend String to an Oracle CLOB.

 

The Job always shows the yellow warning triangle for the tOracleOuput component for this association of Talend to Oracle types, though the code seems to work and write to the database ok.  The Metadata DB Connection table is defined as CLOB for the field in question.

 

Also checked the File -> Edit Project Properties ->  Metadate of TalendType [mapping_Oracle.xml)

For the <dbToTalendTypes), CLOB is set to default to String, but also accept Object as Talend types,

but for <talendToDBTypes>,  String does not include CLOB as a valid output.

 

Manually editing in <dbType type="CLOB" /> under the talendType type="id_String"> group resolves the issue.

Tags (1)

Accepted Solutions
Moderator

Re: the schema's dbType not correct for this component - TOS 7, OracleDB

Hello,

Thanks for your information.

If you are working in a team, all your coworkers should import the modified mapping xml file, otherwise they'll see the same warning you got rid of.

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.

All Replies
Moderator

Re: the schema's dbType not correct for this component - TOS 7, OracleDB

Hello,

Thanks for your information.

If you are working in a team, all your coworkers should import the modified mapping xml file, otherwise they'll see the same warning you got rid of.

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.