WHERE clause syntax error

[pawelkosi]

Hi Guys,

I am learning MySQL at the same time as Jaspersoft Studio. I am following tutorial 'Adding Parameters Activity' from the online learning portal here on the website.

I am connected to my database and I can retrieve all the tables no problem, but when I try to add simple WHERE clause to the report querry I get syntax error, even though I follow everything exactly as it is in the tutorial. I have two columns, one is called 'UniqueKPICode' and holds string value (mix of letters and numbers) and other column is called 'AugYtdAct' that holds numerical (double) value.

select UniqueKPICode, AugYtdAct from accountsimportnewwhere UniqueKPICode = "DvOvx-Dv3-2-na-SCos"[/code]

I was trying to retrieve one record as per tutorial, the editor doesnt report any problems with this expressions though when I run the querry I get MySQL syntax error.

Link to the tutorial: https://www.jaspersoft.com/scorm_data/DevelopingReportswithJaspersoftStudio_0516/data/execute

Thanks for any help!

 

Pawel

[pawelkosi]

After some digging around I have found that the problem wasn't with my querry but with built-in sorting (Select limit 100) in JasperSoft Studio

.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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=100' at line 1

I guess it is a bug, I will report it to the bug tracking system.

 

[hozawa]

Please add which version of Jaspersoft Studio you are using. 5.5 contains some bugs which won't fetch metadata from MySQL. Since you aren't having that problem, are you using 5.6 beta?

[pawelkosi]

Well I can't see metadata either. Just thought it wasn't big problem. I am using 5.5.0 Proffesional.

 

Regards