How can I hide the jrxml code from showing in errors?

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

Hello,

I have a report that uses several connections to pull data. The issue I am running into is this : When one of the connections fails, it shows an error in AdvancedReporting that shows the connection expression, including password....

java.sql.DriverManager.getConnection("jdbc:db2://server/database","username","password")

How can I stop this from showing on error, or at least blank out the expression? This is a fairly significant security breach... Not sure why it would show the entire expression.

Thank you.

camnott's picture
122
Joined: Mar 10 2017 - 6:24am
Last seen: 3 years 11 months ago

1 Answer:

Actually found my own way to get around this.  Added new parameters p_connection p_user p_password and changed the expression to

java.sql.DriverManager.getConnection($P{p_connection},$P{p_user},$P{p_password})

Works perfectly.

camnott's picture
122
Joined: Mar 10 2017 - 6:24am
Last seen: 3 years 11 months ago
Feedback
randomness