topic Re: tMySQLOutput generating invalid SQL statement in Talend Studio

tMySQLOutput generating invalid SQL statement

Anonymous — Sat, 16 Nov 2024 10:44:00 GMT

Hello !
I have this on a Talend job :

The aim is to fill the table with data, the table is just a relational one (2 fields which correspond to ID of other tables)
The tJava component allows me to print the query
It contains :

System.out.println(((String)globalMap.get("tMysqlOutput_27_QUERY")));

The tMySQLOutput component is set with "Insert or update on duplicate key or unique index".

The problem is that it gives me an SQL Syntax Error.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

With the tJava component, I get the query :

INSERT IGNORE INTO `myTable` (`myField_1`,`myField_2`) VALUES (36,12766) ON DUPLICATE KEY UPDATE

In facts, this query is invalid (using MySQL 5.7)

It works with "Insert or update" mode.

Then, is it a bug/mistake from Talend ?
Or do I have misunderstood the way of using "Insert or update on duplicate key or unique index" ?

Thank you for your answers !

Anth224

Re: tMySQLOutput generating invalid SQL statement

Anonymous — Fri, 18 Mar 2016 14:15:26 GMT

I don't see what is invalid about that statement, apart from the missing UPDATE logic. This is likely to do with the component not having been configured correctly.
You need to give us more information. Have you configured the "Field Options" in the Advanced Tab? What is the actual error message?

Re: tMySQLOutput generating invalid SQL statement

Anonymous — Tue, 22 Mar 2016 09:23:13 GMT

Hi,
You are right, I didn't configured it at all through the other tabs.
I thought it will update the data using the columns I put as key, like it does through 'Insert or Update' mode.

By the way, the error message was just : 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1'
Thank you!