topic Re: Talend Job error Cannot determine value type from string 'India' in Talend Studio

Talend Job error Cannot determine value type from string 'India'

BA621858188 — Sun, 18 Sep 2022 15:58:44 GMT

Hi All,

I am facing below error in Talend job.

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

My datatype in db and schema is string only still I am getting the error. I have extracted from metadata as well to double check but still it is coming as string only.

Please find snapshots of the component.

Kindly help, Thanks.

Re: Talend Job error Cannot determine value type from string 'India'

BA621858188 — Sun, 18 Sep 2022 16:55:53 GMT

Query is as follow,

"SELECT

a.custid,

c.country,

c.state,

FROM a

inner join b

on a.no between 1 and 6

inner join c

on a.custid=c.custid;

Re: Talend Job error Cannot determine value type from string 'India'

Anonymous — Mon, 19 Sep 2022 07:06:48 GMT

The solution worked for me thanks to the community and the members for the solution.

PFM Driver Login

Re: Talend Job error Cannot determine value type from string 'India'

Anonymous — Mon, 19 Sep 2022 07:20:30 GMT

You don't have the right order of fields in query to map the columns on the schema.

Re: Talend Job error Cannot determine value type from string 'India'

BA621858188 — Mon, 19 Sep 2022 10:10:14 GMT

@Shicong Hong ,

Is it due to the order of fields?

I am using the fields from 2 different tables and added in schema to print. Can we use multiple tables in one query tdbinput component and fetch the required fields.

Re: Talend Job error Cannot determine value type from string 'India'

BA621858188 — Mon, 19 Sep 2022 10:10:56 GMT

@Irene Merrow ,

Can you explain with job design. Are you also fetching the fields from multiple tables in 1 query.

Re: Talend Job error Cannot determine value type from string 'India'

Anonymous — Mon, 19 Sep 2022 10:25:25 GMT

Yes, you can read data from multiple tables in a query if the tables are in the same DB.

The value of first field will be assigned to the first column on the schema, the third column is customerid with int type, but it is a string data 'state' in the query.

Re: Talend Job error Cannot determine value type from string 'India'

BA621858188 — Tue, 20 Sep 2022 10:03:37 GMT

Okay @Shicong Hong .

Thank you for the response.