topic Re: Interbase TO mysql / java.sql.Date cannot be cast to java.lang.Integer in Talend Studio

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

Anonymous — Sun, 25 Nov 2018 17:47:30 GMT

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 ?

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

TRF — Sun, 25 Nov 2018 17:58:21 GMT

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.

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

Anonymous — Sun, 25 Nov 2018 18:05:55 GMT

I don't find 😕

all date fields are on "date"

you can see on screeshot

g2mysql_tdbinput_23.png

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

TRF — Sun, 25 Nov 2018 18:20:33 GMT

Can you also share the tDBInput_23 details?

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

Anonymous — Sun, 25 Nov 2018 18:24:46 GMT

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

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

TRF — Sun, 25 Nov 2018 18:34:32 GMT

Just capture the screen with the tDBInput_23 Settings and Advanced settings

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

Anonymous — Sun, 25 Nov 2018 18:49:37 GMT

is it that ?

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

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

Anonymous — Fri, 30 Nov 2018 08:34:04 GMT

can you help me ?