I have recently installed Jaspersoft Studio 6.2.0.final x86 64 bits. MySQL database is version 5.6.24 winx64.I've downloaded and installed the JDBC java driver mysql-connector-java-3.0.17-ga.
I established connection and test it without any problem. When I try a first report I encounter the following problem:
- In the Dataset and Query Dialog of the report, the schema is repeated six times with the same information.
- Moreover I put a simple sql query (select * from operador) and push Read Fields and get the error enclosed: "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 'OPTION SQL_SELECT_LIMIT=1' at line 1"
Thank you very much for your help.