topic Re: java.sql.SQLDataException: Cannot determine value type from string 'USD ' in Talend Studio

java.sql.SQLDataException: Cannot determine value type from string 'USD '

shalinim1 — Sat, 16 Nov 2024 01:18:12 GMT

Hi,

I have a tfileinputdelimited connected to db table with tmap, in input file there is a column called currency_type which has data like 'USD', 'INR', 'GBR'. The job ran successfully and the data was loaded to the db table.

When I tried to load from that db table to another table, it is throwing the following exception,

Exception in component tDBInput_1 (Partdimension)

java.sql.SQLDataException: Cannot determine value type from string 'USD '

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:114)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96)

at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:895)

at case_study_etl_process.partdimension_0_1.Partdimension.tDBInput_1Process(Partdimension.java:1718)

at case_study_etl_process.partdimension_0_1.Partdimension.runJobInTOS(Partdimension.java:3559)

at case_study_etl_process.partdimension_0_1.Partdimension.main(Partdimension.java:3409)

Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string 'USD '

at com.mysql.cj.result.StringConverter.createFromBytes(StringConverter.java:131)

at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(MysqlTextValueDecoder.java:238)

at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:143)

at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:250)

at com.mysql.cj.protocol.a.result.ByteArrayRow.getValue(ByteArrayRow.java:91)

at com.mysql.cj.jdbc.result.ResultSetImpl.getNonStringValueFromRow(ResultSetImpl.java:655)

... 4 more

Re: java.sql.SQLDataException: Cannot determine value type from string 'USD '

manodwhb — Wed, 14 Oct 2020 07:11:33 GMT

@Shalini M , can you share the screenshot of schema of tDBinput and can u check do you have and USD value which is converting ?

Thanks,

Manohar

Re: java.sql.SQLDataException: Cannot determine value type from string 'USD '

shalinim1 — Wed, 14 Oct 2020 07:38:42 GMT

@Manohar B In the next process I just want to load the table. conversion will take place in next step.

Regards,

Shalini

Re: java.sql.SQLDataException: Cannot determine value type from string 'USD '

manodwhb — Wed, 14 Oct 2020 09:31:52 GMT

@Shalini M , can you import the table in repository>>metadata , which you have loaded from tfileInputDelimited to DB? and check the data type for loading?

Thanks,

Manohar

Re: java.sql.SQLDataException: Cannot determine value type from string 'USD '

shalinim1 — Wed, 14 Oct 2020 09:41:46 GMT

Yes, I have imported that file in repository. and the data type is string.

Re: java.sql.SQLDataException: Cannot determine value type from string 'USD '

shalinim1 — Wed, 14 Oct 2020 09:59:04 GMT

@Manohar B The issue got resolved. Thank you for the response.

Re: java.sql.SQLDataException: Cannot determine value type from string 'USD '

manodwhb — Wed, 14 Oct 2020 10:29:42 GMT

@Shalini M ,Great, please mark the answer so that it will help to others.

Thanks,

Manohar