Uncommenting is required to modify the validation.properties file's Validator.ValidSQL

Uncommenting is required to modify the validation.properties file's Validator.ValidSQL
By ghudson_1

May 1, 2020
Version: v7.5 Product: JasperReports® Server
Share

Followers 0
Issue Description
A new change in 7.2.0 and 7.5.0 requires some additional commenting for the JRS Sql Validator. If you are modifying the ValidSQL validator in validation.properties and not seeing any effect, then you have an extra step to take.
Resolution
Modify security.properties and uncomment line 460 in version 7.5.0

Before: # sqlQueryExecutor=Alpha,ValidSQL,500000,true,SQL_Query_Executor_context

After: sqlQueryExecutor=Alpha,ValidSQL,500000,true,SQL_Query_Executor_context

Ref. Case 01858739
Table of contents
Share
Followers 0
Go to entries

User Feedback
- 1 Comment
Recommended Comments

Tom C 2

Posted November 18, 2020

Share this comment

The information is in our official document TIBCO JasperReports® Server Security Guide Software Release 7.5, scetion 4.4.3 "Customizing Query Validation". An copy of the document is available at community site:
https://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v7/protecting-against-sql-injection
"Customizing Query Validation"

Link to comment

Share on other sites

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 account

Sign in

Already have an account? Sign in here.
Sign In Now

Sign In

Uncommenting is required to modify the validation.properties file's Validator.ValidSQL

Issue Description

Resolution

Table of contents

User Feedback

Recommended Comments

Tom C 2

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore