https://community.qlik.com/t5/Talend-Studio/Error-com-mysql-jdbc-exceptions-jdbc4-MySQLSyntaxErrorException/m-p/2208115#M7477 to be less than helpful: The error likely says what it means. You've got a syntax problem in your salesforce query. Without more details, it is difficult to provide any more assistance. <BR /> <BR /> <BR /> <BR />To get some help from the forum you should add the following details to your future posts: <BR />1) a quick high-level summary of what you are trying to do <BR />2) screenshots or descriptions of your job, and any relevant component configurations <BR />3) stack traces of the errors you're seeing ( which you did include-- thanks! ) Mon, 29 Oct 2018 19:05:24 GMT Anonymous 2018-10-29T19:05:24Z https://community.qlik.com/t5/Talend-Studio/Error-com-mysql-jdbc-exceptions-jdbc4-MySQLSyntaxErrorException/m-p/2208114#M7476 <P>Starting job xyz at 15:57 29/10/2018. [statistics] connecting to socket on port 4064 [statistics] connected Exception in component tDBOutput_2 (Xyz) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '$User.Role_Name__c ,`data1` VARCHAR(1300) ,`data2` VA' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4232) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4164) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2832) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2781) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:908) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:788) at project_1.xyz.xyz.tSalesforceInput_2Process(xyz.java:9866) at project_1.xyz.xyz.tSalesforceInput_1Process(xyz.java:5060) at project_1.xyz.xyz.runJobInTOS(xyz.java:14591) at project_1.xyz.xyz.main(xyz.java:14440) [statistics] disconnected Job xyzended at 15:58 29/10/2018. [exit code=0] i am getting above error message while loading data from sales force source to mysql target. Appreciate any help.</P> Sat, 16 Nov 2024 07:23:37 GMT https://community.qlik.com/t5/Talend-Studio/Error-com-mysql-jdbc-exceptions-jdbc4-MySQLSyntaxErrorException/m-p/2208114#M7476 Anonymous 2024-11-16T07:23:37Z https://community.qlik.com/t5/Talend-Studio/Error-com-mysql-jdbc-exceptions-jdbc4-MySQLSyntaxErrorException/m-p/2208115#M7477 to be less than helpful: The error likely says what it means. You've got a syntax problem in your salesforce query. Without more details, it is difficult to provide any more assistance. <BR /> <BR /> <BR /> <BR />To get some help from the forum you should add the following details to your future posts: <BR />1) a quick high-level summary of what you are trying to do <BR />2) screenshots or descriptions of your job, and any relevant component configurations <BR />3) stack traces of the errors you're seeing ( which you did include-- thanks! ) Mon, 29 Oct 2018 19:05:24 GMT https://community.qlik.com/t5/Talend-Studio/Error-com-mysql-jdbc-exceptions-jdbc4-MySQLSyntaxErrorException/m-p/2208115#M7477 Anonymous 2018-10-29T19:05:24Z