I've seen some discussion on how to log generated SQL on jasper server and iReport. Is it possible to do so in Jaspersoft Studio?
2 Answers:
Java Util Logging (but not Log4j) should work as per Configuring Apache Commons Logging and Log4J in Jaspersoft Studio if you set this in log.properties:
net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.level = FINE
and comment out the default level for the FileHandler:
# java.util.logging.FileHandler.level = INFO
Also make sure java.util.logging.FileHandler.pattern
and -Dorg.apache.commons.logging.diagnostics.dest point to different files. The file set in java.util.logging.FileHandler.pattern should contain your SQL statements.
Good question.. normaly in JSS you write the query so it's pretty straight forward, what you write is sent to the DB, the only case you may find that useful is with marameter subtitution (if your query is using $P{} or $X{}) in that case you can use the JR query logging.
To do this add "log4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter=debug" to your JSS jasperreports.properties file, check this thread http://community.jaspersoft.com/questions/526007/logging-sql-query-executed
Thank you for the reply. You are exactly right about the reasoning. I am trying to dig deeper into what is going on in my report and want to see what SQL results from my $X expressions. I believe your link is again referring to the Jasper Server. As I do not administrate the Jasper server I would like to view the SQL generated in Jaspersoft Studio. I searched the install folder for jasperreports.properties and it doesn't appear to be present. Any further suggestions?
Actually since that logger is in JasperReports it will be the same for JSS or JasperServer.
To change the jasperreports.properties file in JasperSoft Studio you have a UI to get there go to:
MyReports -> Properties -> Jaspersoft Studio group -> Properties -> Use Workspace Settings -> Configure Workspace Settings
and then you can add your log4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter=debug
But now that I look into it the log4J does not look like is configured by default in JSS so here is the info to configure it http://community.jaspersoft.com/wiki/configuring-apache-commons-logging-...
I tried the configuration as defined http://community.jaspersoft.com/wiki/configuring-apache-commons-logging-... and added og4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter=debug as mentioned above however it still does not work. Can I get some help.