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

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
118
Joined: Mar 10 2017 - 6:24am
Last seen: 4 years 8 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
118
Joined: Mar 10 2017 - 6:24am
Last seen: 4 years 8 months ago
Feedback
randomness