camnott Posted July 16, 2018 Share Posted July 16, 2018 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. Link to comment Share on other sites More sharing options...
Solution camnott Posted July 16, 2018 Author Solution Share Posted July 16, 2018 Actually found my own way to get around this. Added new parameters p_connection p_user p_password and changed the expression tojava.sql.DriverManager.getConnection($P{p_connection},$P{p_user},$P{p_password})Works perfectly. Link to comment Share on other sites More sharing options...
Recommended Posts
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