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

[Anonymous]

Hi, using MysqlInput component
Have this warning occurring, what could be causing it?
Thank You

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Hi,
You can set DB type in schema setting.
Best regards
Sabrina

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

Thanks ok, so no need to worry

[Anonymous]

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

[Anonymous]

Ok thank You