sakar.sr Posted May 12, 2015 Share Posted May 12, 2015 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 Link to comment Share on other sites More sharing options...
rajpal.nasir Posted July 28, 2018 Share Posted July 28, 2018 I am also getting same error any solution please? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now