Interbase TO mysql / java.sql.Date cannot be cast to java.lang.Integer

[Anonymous]

Hello,

I transfert all tables of interbase base to mysql base

on one transfert table i have this error message:

[statistics] connected
Exception in component tDBInput_23 (g2mysql)
java.lang.ClassCastException: java.sql.Date cannot be cast to java.lang.Integer
    at interbase.interclient.ResultSet.getRowData_int(Unknown Source)
    at interbase.interclient.ResultSet.getTimestamp(Unknown Source)
    at routines.system.JDBCUtil.getDate(JDBCUtil.java:61)
    at local_project.g2mysql_0_1.g2mysql.tDBInput_23Process(g2mysql.java:1577)
    at local_project.g2mysql_0_1.g2mysql.runJobInTOS(g2mysql.java:2440)
    at local_project.g2mysql_0_1.g2mysql.main(g2mysql.java:2265)
[statistics] disconnected

can you help me ?

[TRF]

The problem is not on the tMAp component but on tDBInput_23.

Double check the schema for this component.

It seems a Date column is mapped to an Integer field in the component schema.

[Anonymous]

I don't find 😕

all date fields are on "date"

you can see on screeshot

g2mysql_tdbinput_23.png

[TRF]

Can you also share the tDBInput_23 details?

[Anonymous]

sorry but i am new on talend, if you say me how, i can give you details

[TRF]

Just capture the screen with the tDBInput_23 Settings and Advanced settings

[Anonymous]

is it that ?

Capture d’écran_2018-11-25_19-38-19.png
Capture d’écran_2018-11-25_19-46-37.png

[Anonymous]

can you help me ?