topic Re: java.sql.SQLSyntaxErrorException: Unknown table 'h' in field list in Talend Studio

java.sql.SQLSyntaxErrorException: Unknown table 'h' in field list

Anonymous — Sat, 16 Nov 2024 02:16:21 GMT

Im trying to export data from a MySQL database to an Excel file. However, when I use the DBInput component and enter in my query I receive the following error message.

My query has multiple joins to other tables and I used "h" as an alias for one of the tables. If I run the same query in MySql Workbench it works.

Re: java.sql.SQLSyntaxErrorException: Unknown table 'h' in field list

manodwhb — Tue, 02 Jun 2020 05:23:44 GMT

@JeremyKing2 , is the same query executing successfully when you run outside of Talend?

Re: java.sql.SQLSyntaxErrorException: Unknown table 'h' in field list

ThWabi — Tue, 02 Jun 2020 06:25:59 GMT

Hello JeremyKing2,

have you tried removing the commented line "-- select *"?

Talend Studio might recognize it and display it in green, but after building the Java code, the SQL statement string sent to the database might not be the full text of your query.

Best regards,

Thomas