Scenario:
You designed a report in TIBCO Jaspersoft® Studio that has a field with a name that contains the word "Into" in it, for example $F{MovedIntoFolder} or $F{ScannedIntoShipment}. The report runs fine in the Jaspersoft® Studio and it doesn't run on the server. Alternatively, it ran on the server successfully before and then you upgraded to the newest version and it doesn't anymore.
Solution:
The word INTO is causing the SQL to be deemed invalid. The regex for the valid SQL has changed in the recent version. To avoid this problem go to ${JRS WAR file}/WEB-INF/classes/validation.properties file, find the ValidSQL validator:
Validator.ValidSQL=(?is)^\\s*(select|call)\\b((?!\\binto\\b)[^;])*;?\\s*$
Remove the word into from it:
Validator.ValidSQL=(?is)^\\s*(select|call)\\b((?!\\b\\b)[^;])*;?\\s*$
Save and restart.
Recommended Comments
There are no comments to display.
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