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
