One Star

Warning: "the schema's dbType not correct for this component"

Hi, using MysqlInput component
Have this warning occurring, what could be causing it?
Thank You Smiley Happy
9 REPLIES
One Star kcd
One Star

Re: Warning: "the schema's dbType not correct for this component"

I've been comfortably ignoring that one for years...
Moderator

Re: Warning: "the schema's dbType not correct for this component"

Hi,
The warning reminder you that you haven't set a DB type in schema yet. Certainly, for simple data type, it is not a big deal. But a complicate data type will encounter a problem when execute the whole job without setting a DB type.
The solution is that setting a DB type for your column in schema of DB input component.
Actually, the warning will not affect your job execution.
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.
One Star

Re: Warning: "the schema's dbType not correct for this component"

Hi Sabrina, can you show me where this is set? I'd like to keep everything nice and neat if possible Smiley Happy
Moderator

Re: Warning: "the schema's dbType not correct for this component"

Hi,
You can set DB type in schema setting.
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.
One Star

Re: Warning: "the schema's dbType not correct for this component"

Hi, I am doing that but some of them appear orange in the schema editor (see example attached)
Maybe this is an indication that something is wrong?
Moderator

Re: Warning: "the schema's dbType not correct for this component"

Hi,
You'd better use the same numeric types between talend schema and DB.
As we known that,
Talend Schema-->DB type(mapping)
String-->Varchar
Int-->INT
For the orange part, it is an indication that you use different numeric types between talend schema and DB, which is a warning not affect your job execution.
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.
One Star

Re: Warning: "the schema's dbType not correct for this component"

Thanks ok, so no need to worry
Seventeen Stars

Re: Warning: "the schema's dbType not correct for this component"

you can modify the defaut mapping between Talend type and DB type thanks xml metadata Talend type.
(@see preferences).
it will affect all your Talend project .
regards
laurent
One Star

Re: Warning: "the schema's dbType not correct for this component"

Ok thank You Smiley Happy