topic Re: Datatype mismatch AS400 in Talend Studio

Datatype mismatch AS400

Anonymous — Sat, 16 Nov 2024 13:02:19 GMT

Hi
I have created a AS400 input component.
Among the fields I want there is one that is called invoice description. In our AS400 this is set to type NCHAR(24)
When I look at the schema design I see that it is set with type String and DB Type to varchar.
It failes at the very first line. The text it finds is "2412 FEILBET."
My error code:
connecting to socket on port 3671
connected
Exception in component tAS400Input_1
java.sql.SQLException: Data type mismatch. (For input string: "2412 FEILBET.")
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
at com.ibm.as400.access.SQLChar.getFloat(SQLChar.java:464)
at com.ibm.as400.access.AS400JDBCResultSet.getFloat(AS400JDBCResultSet.java:2869)
at as400_mitmas.fapred_0_1.FAPRED.tAS400Input_1Process(FAPRED.java:700)
at as400_mitmas.fapred_0_1.FAPRED.runJobInTOS(FAPRED.java:1065)
at as400_mitmas.fapred_0_1.FAPRED.main(FAPRED.java:936)
I have tried to alter the line so it has "FEILBET". Still the same error.
Anyone got ideas on why this happends?
Dan

Re: Datatype mismatch AS400

Anonymous — Tue, 15 Mar 2011 08:46:46 GMT

Hi Dan
Can you please upload a screenshot of schema?
Best regards
Shong

Re: Datatype mismatch AS400

Anonymous — Tue, 15 Mar 2011 19:05:56 GMT

Are you sure that the problem is related to that field? in the stack trace I see something related to float / numeric fields columns....
show your data if you want help...

Re: Datatype mismatch AS400

Anonymous — Mon, 21 Mar 2011 12:21:40 GMT

Hi
Sorry for late reply. I have been on a short holiday.
Please find below my attached printscreen of my model.
Is tis what you wanted?
I also tested to remove the field I thought was worng. Imported just fine without that one.
Sp at least I know what field it is.
Dan

Re: Datatype mismatch AS400

Anonymous — Mon, 21 Mar 2011 16:39:23 GMT

The code is issuing a getFloat (...at com.ibm.as400.access.AS400JDBCResultSet.getFloat...).
Maybe somewhere you have on as400 character data mapped as float ( maybe automatically wrongly by Talend ).
Have you checked that.
Also you should compare the "dds" command on as400 to the schema you are fetching.
bye