Question

12
Replies
2049
Views
AnuradhaW Member since 2015 32 posts
Virtusa
Posted: June 12, 2018
Last activity: June 14, 2018
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
Share this page LinkedIn