Report with Postgres DBLink query - Error 6632

[shuwnyuan]

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