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 ?

Forteen Stars TRF
Forteen 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

Highlighted
Forteen Stars TRF
Forteen 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

Forteen Stars TRF
Forteen 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 ?

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.