Error in creating new data adapter in Jaspersoft Studio 6.0.4

using jaspersoft studio 6.0.4.
when createing new data adapter, we are able to connect with my mysql database (MYSQL 5.6) running in localhost and got test connection successfull.
but i'm unable to select table from database using selection query "SELECT * FROM <mytablename>"
i got error mgs show as below
"Erreur de syntaxe près de 'OPTION SQL_SELECT_LIMIT=DEFAULT' à la ligne 1"
please help to solve the problem's picture
Joined: Mar 29 2015 - 11:52pm
Last seen: 7 years 3 months ago

I am also getting same error any solution please?

rajpal.nasir - 4 years 8 months ago

0 Answers:

No answers yet