java.lang.NumberFormatException: For input string: "08:30:00"

talendstar — Sat, 16 Nov 2024 03:28:36 GMT

I am trying to load a table from SQL Server to Snowflake.

The data type in SQL Server is Time.

Here is what the tmap looks like:

Here is the schema editor in tmap:

Originally I created the SF table with these columns setup as Time data type but that didn't work (I would like to keep the destination data type time).

However since I couldn't get that to work I changed the data type in Snowflake(SF) to varchar hoping TalendDate.formatDate can take the incoming time as output it as a string but not having much luck there either.

Here is the error that I get:

Exception in component tDBOutput_1 (DAILYTOURSLOTS)
java.lang.NumberFormatException: For input string: "08:30:00"
at java.lang.NumberFormatException.forInputString(Unknown Source)
at java.lang.Integer.parseInt(Unknown Source)
at java.lang.Integer.valueOf(Unknown Source)
at org.talend.codegen.enforcer.IncomingSchemaEnforcer.put(IncomingSchemaEnforcer.java:507)
at org.talend.codegen.enforcer.IncomingSchemaEnforcer.put(IncomingSchemaEnforcer.java:379)
at avbtalend71.dailytourslots_0_1.DAILYTOURSLOTS.tDBInput_1Process(DAILYTOURSLOTS.java:1734)
at avbtalend71.dailytourslots_0_1.DAILYTOURSLOTS.runJobInTOS(DAILYTOURSLOTS.java:2281)
at avbtalend71.dailytourslots_0_1.DAILYTOURSLOTS.main(DAILYTOURSLOTS.java:2107)

Here is what the source data for these columns looks like:

Any thoughts on how to process the time (field only contains time and does not have any date on it).

thanks

Re: java.lang.NumberFormatException: For input string: "08:30:00"

vapukov — Wed, 29 Jan 2020 00:37:44 GMT

Hi,

you must to check settings in the output component tDBOutput_1

possible in tMap you have defined columns as a String, but in database output component as Integer

Re: java.lang.NumberFormatException: For input string: "08:30:00"

talendstar — Wed, 29 Jan 2020 15:39:11 GMT

I have verified the Snowflake table. Colunms are defined as varchar in Snowflake table.

Re: java.lang.NumberFormatException: For input string: "08:30:00"

vapukov — Wed, 29 Jan 2020 21:15:05 GMT

just to be 100% correct - did you check it in Studio component schema? (or in database?)

you need to check in tSnowFlakeOutput component, you can share the picture as well

cheers,

topic Re: java.lang.NumberFormatException: For input string: "08:30:00" in Talend Studio

java.lang.NumberFormatException: For input string: "08:30:00"

Re: java.lang.NumberFormatException: For input string: "08:30:00"

Re: java.lang.NumberFormatException: For input string: "08:30:00"

Re: java.lang.NumberFormatException: For input string: "08:30:00"