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

Four Stars

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

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 ?

Highlighted
Fifteen Stars TRF
Fifteen Stars

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

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.


TRF
Four Stars

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

I don't find :/

 

all date fields are on "date"

 

you can see on screeshot

Fifteen Stars TRF
Fifteen Stars

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

Can you also share the tDBInput_23 details?


TRF
Four Stars

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

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

Fifteen Stars TRF
Fifteen Stars

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

Just capture the screen with the tDBInput_23 Settings and Advanced settings

TRF
Four Stars

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

is it that ?

Four Stars

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

can you help me ?

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now