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

[BA621858188]

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.

[BA621858188]

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;

[Anonymous]

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

PFM Driver Login

[Anonymous]

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

[BA621858188]

@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.

[BA621858188]

@Irene Merrow​ ,

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

[Anonymous · Accepted solution]

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.

[BA621858188]

Okay @Shicong Hong​ .

Thank you for the response.