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

[talendstar]

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

[vapukov]

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

[talendstar]

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

[vapukov]

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,