topic Re: Data type mismatch in Talend Studio

Data type mismatch

Anonymous — Sat, 16 Nov 2024 13:55:46 GMT

Hello,
I have a join (lookup) between 2 tables and I have the following error:
Starting job ArticlesUC at 11:46 08/06/2009.
Exception in component tAS400Input_3
java.sql.SQLException: Data type mismatch. (For input string: "BI")
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
at com.ibm.as400.access.SQLChar.getInt(SQLChar.java:486)
at com.ibm.as400.access.AS400JDBCResultSet.getInt(AS400JDBCResultSet.java:2889)
at projet_m3.articlesuc_0_1.ArticlesUC.tAS400Input_3Process(ArticlesUC.java:6398)
at projet_m3.articlesuc_0_1.ArticlesUC.tAS400Input_2Process(ArticlesUC.java:1916)
at projet_m3.articlesuc_0_1.ArticlesUC.runJobInTOS(ArticlesUC.java:8857)
at projet_m3.articlesuc_0_1.ArticlesUC.main(ArticlesUC.java:8770)
Job ArticlesUC ended at 11:47 08/06/2009.
How to debug this type of error??
Thanks
Didier

Re: Data type mismatch

Anonymous — Mon, 08 Jun 2009 11:02:10 GMT

Hello

java.sql.SQLException: Data type mismatch. (For input string: "BI")

As the message shows, there is a string in input rows, however the data type of column is int.
To avoid this exception,
Delete this row manually or set the data type as string, then filter this row.
Best regards

shong

Re: Data type mismatch

Anonymous — Mon, 08 Jun 2009 11:15:08 GMT

With a SQL statement it works.
So the problem is to find the record where there is the mismatch.
The join between the two tables is done on fields defined as character.
Any recommendations??
Thanks
Didier

Re: Data type mismatch

Anonymous — Mon, 08 Jun 2009 11:18:00 GMT

Change the file definition Char by string , for eatch table you work with.
I allways do this and have no problems. You'll be able to work with
string methods.
Marc

Re: Data type mismatch

Anonymous — Mon, 08 Jun 2009 11:27:29 GMT

I have changed the char type by string
Now I have another error:
Starting job ArticlesUC at 12:26 08/06/2009.
Exception in component tAS400Input_3
java.lang.ClassCastException: java.lang.String cannot be cast to java.util.List
at projet_m3.articlesuc_0_1.ArticlesUC.tAS400Input_3Process(ArticlesUC.java:6797)
at projet_m3.articlesuc_0_1.ArticlesUC.tAS400Input_2Process(ArticlesUC.java:1916)
at projet_m3.articlesuc_0_1.ArticlesUC.runJobInTOS(ArticlesUC.java:8898)
at projet_m3.articlesuc_0_1.ArticlesUC.main(ArticlesUC.java:8811)
Job ArticlesUC ended at 12:26 08/06/2009.

Re: Data type mismatch

Anonymous — Mon, 08 Jun 2009 14:46:35 GMT

Try to make you join in query with the matched fields. Do you use specific code in Tmap for working with array ?
Your message is strange or try to put some screens of your Tmap