Add sql_mode='' to Additional Parameters in Talend 8

[MLepage1629206472]

I need to set sql_Mode = '' in my JDBC connection to MySql 8 in Talend 7.1.

When I use the following in Additional JDBC Parameters setting:

I get the following Error:

Would anyone be able to help with this or point me to some documentation on how to set sql_Mode=''

[Anonymous]

Hello,

What's JDK version are you using?

When you get some compile errors, could you please check your "Code" tab in your job to see if there will be your compile error highlighted in red line?

Best regards

Sabrina