jasper report extended logs

[Alex0027]

Is it possible to view extended logs for jasperreports-library, for example, generated sql query?
What about writing jasperreports-library logs to separate file?

Thanks.

p.s. I found this possibility only for jasper server.
 

[kkriplani]

Hi,
Yes you can view the logs.
For that you will have to follow the below listed steps;
1) Jasperserver, click on Manage >> Server Settings .
2) Upon reaching the log_settings, set the property to debug for the things you want to view in the logs (inclucing "SQL Query Executer")
3) on the server where jasperserver is deploed, Go to <tomcat-directory>/webapps/jasperserver-pro/WEB_INF/logs and view the file named jasperserver.log , you will find the logs there.

[hozawa]

JasperReports is just a Java library and doesn't generate SQL statements - your program does. Just use any logging library and add statememts to output to log file yourself. That's what I do.