in your Jasper Server ./WEB-INF directory find file log4j.properties – this contains all log properties.

To enable loging of SQL queries you need to allow this property


### JasperReports loggers
log4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter=debug

Logged information you can find in ./WEB-INF/logs/jasperserver.log file.
To continously monitor it you can use on Linux this command:

tail -f <your_path_to_jasper>/WEB-INF/logs/jasperserver.log

Output looks like this (“?” in query replaces parameters which are listed bellow):

2015-07-29 17:03:53,950 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:254 - SQL query string: SELECT
    _report_id 
  , _report_start 
  , _report_end 
FROM
  <your_procedure>(
   ?
) AS report_id;
2015-07-29 17:03:53,953 DEBUG JRJdbcQueryExecuter,pool-6-thread-1:396 - Parameter #1 (<your_parameter_name> of type java.lang.Integer): 4