Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax

Five Stars

Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax

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.

Seven Stars JGM
Seven Stars

Re: Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax

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.



To get some help from the forum you should add the following details to your future posts:
1) a quick high-level summary of what you are trying to do
2) screenshots or descriptions of your job, and any relevant component configurations
3) stack traces of the errors you're seeing ( which you did include-- thanks! )

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog