Question

12
Replies
2562
Views
Anuradha Withanage (AnuradhaW)
Virtusa

Virtusa
LK
AnuradhaW Member since 2015 36 posts
Virtusa
Posted: June 12, 2018
Last activity: June 14, 2018
Posted: 12 Jun 2018 12:55 EDT
Last activity: 14 Jun 2018 10:07 EDT
Closed

error in your SQL syntax; check the manual that corresponds to your MySQL server version

I'm getting exception in report definition, My properties mapped into external mysql DB, When i was run the report definition, this exception occurred

Error:
** An error occured on executing the query for the report definition - There was a problem getting a list: code: 1064 SQLState: 42000 Message: 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 '.`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELE' at line 1 DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: 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 '.`customerid` AS "customerid" , "PC0".`customername` AS "customername" FROM TELE' at line 1 | SQL Code: 1064 | SQL State: 42000

"

Low-Code App Development DevOps Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.