CODEWITHSUNDEEP
eclipsebirt
user3351605
user3351605

Reputation: 1291

Unable To Change Preview Setting In Eclipse BIRT Report Designer

I've just begun using the BIRT report designer for Eclipse to create reports from data in a MySQL database. When attempting to preview the result set from a created data set, I receive the following error:

SQL error #1: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=500' at line 1

I understand that this syntax is invalid with MySQL, as it should be

SET SQL_SELECT_LIMIT=500

However, I cannot figure out if/where I can make this correction, as it is added automatically by the report builder when generating the preview.

Furthermore, in the IDE preferences, I have selected the 'No Limits of number of rows to display' option, trying to bypass this statement altogether, but continue to receive the same error, indicating that it still is trying to preview 500 or less rows, even after deleting the first data set definition and remaking it after the option was changed and restarting Eclipse.

If anyone has any suggestions for either changing the syntax or getting the No Limits option to work correctly, I would greatly appreciate it.

Upvotes: 2

Views: 1097

Answers (1)

user3351605
user3351605

Reputation: 1291

Was actually able to figure out the issue with getting the correct syntax thanks to this SO post regarding Netbeans. The MySQL JDBC driver simply needed to be updated. Preview no longer generates depreciated syntax.

Upvotes: 2

Related Questions