topic Re: tAS400Input data type mismatch in Talend Studio

tAS400Input data type mismatch

Anonymous — Sat, 16 Nov 2024 13:27:28 GMT

I have exception in component tAS400Input:
java.sql.SQLException: Data type mismatch. (For input string: "01/01/09")
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
at com.ibm.as400.access.SQLVarchar.getFloat(SQLVarchar.java:486)
at com.ibm.as400.access.AS400JDBCResultSet.getFloat(AS400JDBCResultSet.java:2869)
Thank you

Re: tAS400Input data type mismatch

Anonymous — Thu, 22 Apr 2010 03:24:10 GMT

Hello

java.sql.SQLException: Data type mismatch. (For input string: "01/01/09")

What's the data type of this column? int or Date? as the string "01/01/09" display, it should be Date type here.
Best regards
Shong

Re: tAS400Input data type mismatch

Anonymous — Thu, 22 Apr 2010 13:48:31 GMT

The input type is integer and output type is date(dd/mm/yy)

Best regards,
dn

Re: tAS400Input data type mismatch

Anonymous — Thu, 22 Apr 2010 15:14:44 GMT

Hello
As the error message shows, it is a string ""01/01/09" in the table, so you need set the input type as string and convert string type to Date or set it as Date type.
Best regards
Shong

Re: tAS400Input data type mismatch

Anonymous — Thu, 22 Apr 2010 18:26:16 GMT

Hello,
The input type is string and output type is date. In tMap I used TalendDate.parseDate("dd/mm/yy",row13.H_TRDJ).
I have exception on component tAS400Input Data type mismatch. (For input string: "01/01/09") .

Best regards.
dn

Re: tAS400Input data type mismatch

Anonymous — Fri, 23 Apr 2010 03:54:36 GMT

Hello

at com.ibm.as400.access.SQLVarchar.getFloat(SQLVarchar.java:486)
at com.ibm.as400.access.AS400JDBCResultSet.getFloat(AS400JDBCResultSet.java:2869)

Can you upload a screenshot of schema of tAS400Input? From the error message, I see the data type is float.
Best regards
Shong

Re: tAS400Input data type mismatch

Anonymous — Fri, 23 Apr 2010 15:41:36 GMT

Hello,
I fix this problem I don't have anymore this error but when I check what is date on database isn't the format dd/mm/yy.
Best regards,
dn

Re: tAS400Input data type mismatch

Anonymous — Sun, 25 Apr 2010 03:32:49 GMT

Hello

but when I check what is date on database isn't the format dd/mm/yy.

Do you point to the target db? Which type of DB?
Best regards
Shong

Re: tAS400Input data type mismatch

Anonymous — Mon, 26 Apr 2010 17:26:06 GMT

Hello Shong,
The name of field is TRDJ and for output I put date which format dd/mm/yy like you can see in the previous image.
The database is Microsoft SQL i have the same field TRDJ and is datetime(see image 2) but when see what is data on db i see yyyy-mm-dd 00:00:00.000(see image 1)
Best regards,
dn

Re: tAS400Input data type mismatch

Anonymous — Thu, 29 Apr 2010 07:34:32 GMT

Hello
It is a display format problem in Microsoft SQL tool, yyyy-mm-dd 00:00:00.000 is the default format of datetime type in Microsoft SQL. If you want to see format dd/mm/yy, you should use convert function in Microsoft SQL tool.
For example:
select convert(varchar(12),TRDJ,3) from tableName;
Please search ms sql datetime format on google.
Best regards
Shong