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
No answers yet
I am also getting same error any solution please?