shuwnyuan Posted January 9, 2014 Share Posted January 9, 2014 My db source is running Postgres 9.3. I build a Jasper report with query:SELECT * FROM dblink('db_source_1', 'SELECT...... ') AS t(.....) I tested this query in db, it works perfectly. But with Jasper, I get:ERROR Validator,pool-4-thread-1:493 - Invalid SQL:An error has occurred. Please contact your system administrator. (6632) In WEB-INF/classes/esapi/security-config.properties, I already turn off sql validation by setting:security.validation.sql.on=false Restart Jasper, but still not working. Am I missing something? Any pointer here? Thanks Please see detail log as attached 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